UMC_Week0
Tables (8)
FavoriteFood (favorite_food)
- id (favorite_food_id) — BIGINT — Primary key — NOT NULL
- id (member_id) — BIGINT — Foreign key → Member.id — NOT NULL
- id (food_id) — BIGINT — Foreign key → Food.id — NOT NULL
Food (food)
- id (food_id) — BIGINT — Primary key — NOT NULL
- name (food_name) — VARCHAR
Member (member)
- id (member_id) — BIGINT — Primary key — NOT NULL
- loginId (login_id) — VARCHAR
- password — VARCHAR
- name (member_name) — VARCHAR
- gender — VARCHAR
- birthDate (birth_date) — DATE
- address (member_address) — VARCHAR
- inactiveDate (inactive_date) — DATE
- createdAt (created_at) — DATETIME
- updatedAt (updated_at) — DATETIME
MemberMission (member_mission)
- id (member_mission_id) — BIGINT — Primary key — NOT NULL
- isComplete (is_complete) — BOOLEAN
- finishAt (finish_at) — DATETIME
- id (member_id) — BIGINT — Foreign key → Member.id — NOT NULL
- id (mission_id) — BIGINT — Foreign key → Misson.id — NOT NULL
Misson (mission)
- id (mission_id) — BIGINT — Primary key — NOT NULL
- dtype — VARCHAR
- text (misson_text) — VARCHAR
- point (mission_point) — BIGINT
- finishDate (finish_date) — DATETIME
- createdAt (created_at) — DATETIME
- updateAt (update_at) — DATETIME
- id (shop_id) — BIGINT — Foreign key → Shop.id — NOT NULL
ReviewPhoto (review_photo)
- id (review_photo_id) — BIGNIT — Primary key — NOT NULL
- photo — VARCHAR
- id (shop_review_id) — BIGINT — Foreign key → ShopReview.id — NOT NULL
Shop (shop)
- id (shop_id) — BIGINT — Primary key — NOT NULL
- name (shop_name) — VARCHAR
- shopType (shop_type) — VARCHAR
- address (shop_address) — VARCHAR
- number — BIGINT
ShopReview (shop_review)
- id (shop_review_id) — BIGINT — Primary key — NOT NULL
- rating — DOUBLE
- text (shop_text) — VARCHAR
- createdAt (created_at) — DATETIME
- updateAt (update_at) — DATETIME
- id (shop_id) — BIGINT — Foreign key → Shop.id — NOT NULL
- id (member_id) — BIGINT — Foreign key → Member.id — NOT NULL