FoodDucek Renewal

Tables (8)

Account (유저)

  • account_id (pk) — BIGINT — Primary key — NOT NULL
  • email — VARCHAR
  • password — VARCHAR
  • nickname — VARCHAR
  • is_delete — BOOLEAN
  • created_date — DATE
  • modified_date — DATE
  • last_login — DATE

Favor (좋아요)

  • favor_id (pk) — BIGINT — Primary key — NOT NULL
  • count — BIGINT
  • created_date — DATE
  • modified_date — DATE

FavorMenu (좋아요 메뉴)

  • favor_menu_id (pk) — BIGINT — Primary key — NOT NULL
  • account_id (pk2) — BIGINT — Foreign key → Account.account_id — NOT NULL
  • menu_id (pk3) — BIGINT — Foreign key → Menu.menu_id — NOT NULL
  • created_date — DATE

Image (이미지)

  • image_id (pk) — BIGINT — Primary key — NOT NULL
  • menu_id (pk2) — BIGINT — Foreign key → Menu.menu_id — NOT NULL
  • url — VARCHAR
  • created_date — DATE

Menu (메뉴)

  • menu_id (pk) — BIGINT — Primary key — NOT NULL
  • account_id (pk4) — BIGINT — Foreign key → Account.account_id — NOT NULL
  • favor_id (pk3) — BIGINT — Foreign key → Favor.favor_id — NOT NULL
  • title — VARCHAR
  • body — VARCHAR
  • is_delete — BOOLEAN
  • created_date — DATE
  • modified_date — DATE

MenuHistory (메뉴기록)

  • menu_history_id (pk) — BIGINT — Primary key — NOT NULL
  • account_id (pk2) — BIGINT — Foreign key → Account.account_id — NOT NULL
  • menu_id (pk3) — BIGINT — Foreign key → Menu.menu_id — NOT NULL
  • created_date — DATE

Tag (태그)

  • tag_id (pk) — BIGINT — Primary key — NOT NULL
  • title — VARCHAR
  • created_date — DATE

TagMenu (태그된 메뉴)

  • tag_menu_id (pk) — BIGINT — Primary key — NOT NULL
  • tag_id (pk2) — BIGINT — Foreign key → Tag.tag_id — NOT NULL
  • menu_id (pk3) — BIGINT — Foreign key → Menu.menu_id — NOT NULL