UMC_Practice
Tables (8)
food_category (food)
- id — bigint — Primary key — NOT NULL
- name — varchar(20)
member
- id — bigint — Primary key — NOT NULL
- name — varchar(10)
- gender — int
- address — varchar(40)
- birth — datetime
- create_at — datetime(6)
- update_at — datetime(6)
- status — int
- inactive_date — datetime
- point — bigint
- email — varchar(40)
member_mission
- id — bigint — Primary key — NOT NULL
- mission_id — bigint — Foreign key → mission.id — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- status — int
- create_at — datetime(6)
- update_at — datetime(6)
member_prefer (member_food)
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- category_id — bigint — Foreign key → food_category.id — NOT NULL
- create_at — datetime(6)
- update_at — datetime(6)
mission
- id — bigint — Primary key — NOT NULL
- id (store_id) — bigint — Foreign key → store.id — NOT NULL
- reward — int
- deadline — datetime
- mission_spec — varchar(255)
- create_at — datetime(6)
- update_at — datetime(6)
region
- id — bigint — Primary key — NOT NULL
- name — varchar(50)
- create_at — datetime(6)
- update_at — datetime(6)
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
- body — varchar(255)
- score — float
store
- id — bigint — Primary key — NOT NULL
- region_id — bigint — Foreign key → region.id — NOT NULL
- name — varchar(40)
- score — float
- address — varchar(255)
- create_at — datetime(6)
- update_at — datetime(6)