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