erd_1st
Tables (7)
foodcategory
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- prefer_food — varchar(20)
member
- id — bigint — Primary key — NOT NULL
- name — varchar(20)
- gender — varchar(20)
- birthdate — datetime
- created_at — datetime(6)
- updated_at — datetime(6)
- status — varchar(20)
- last_login — datetime
- email — varchar(20)
- password — varchar(20)
- point — varchar(20)
- phone_number — varchar(20)
- nickname — varchar(20)
member_mission
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- mission_id — bigint — Foreign key → mission.id — NOT NULL
- id (id2) — bigint — Foreign key → mission.store_id — NOT NULL
- food_category_id — bigint — Foreign key → mission.food_category_id — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- address — varchar(20)
- is_completed — boolean
- deadline — datetime(6)
- activated — boolean
mission
- id — bigint — Primary key — NOT NULL
- store_id — bigint — Foreign key → store.id — NOT NULL
- food_category_id — bigint — Foreign key → store.food_category_id — NOT NULL
- description — varchar(20)
- title — varchar(20)
- point_reward — bigint
review
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- store_id — bigint — Foreign key → store.id — NOT NULL
- grade — varchar(20)
- description — varchar(30)
- created_at — datetime(6)
review_photo
- id — bigint — Primary key — NOT NULL
- review_id (reveiw_id) — bigint — Foreign key → review.id — NOT NULL
- link — varchar(60)
store
- id — bigint — Primary key — NOT NULL
- food_category_id — bigint — Foreign key → foodcategory.id — NOT NULL
- subscription — varchar(20)
- address — varchar(20)
- name — varchar(20)