umc_1_2
Tables (10)
food_category
- id — int — Primary key — NOT NULL
- name — varchar(20)
- created_at — datetime(6)
- updated_at — datetime(6)
member
- id — bigint — Primary key — NOT NULL
- name — varchar(15)
- gender — varchar(10)
- address — text
- birth — date
- email — varchar(50)
- phone_num — varchar(20)
- points — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
- status — varchar(15)
- inactive_date — datetime
member_agree
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- title — varchar(20)
- description — text
- optional — boolean
- created_at — datetime(6)
- updated_at — datetime(6)
member_mission
- member_id — bigint — Foreign key → member.id — NOT NULL
- mission_id — bigint — Foreign key → mission.id — NOT NULL
- status — varchar(10)
- mission_name — varchar(50)
- created_at — datetime(6)
- updated_at — datetime(6)
member_prefer
- member_id — bigint — Foreign key → member.id — NOT NULL
- food_id — int — Foreign key → food_category.id — NOT NULL
- food_name — varchar(20)
- created_at — datetime(6)
- updated_at — datetime(6)
mission
- id — bigint — Primary key — NOT NULL
- name — varchar(50)
- description — text
- deadline — date
- point — int
- store_id — bigint — Foreign key → store.id — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
region
- id — bigint — Primary key — NOT NULL
- name — varchar(30)
- created_at — datetime(6)
- updated_at — datetime(6)
review
- id — bigint — Primary key — NOT NULL
- content — text
- rating — int
- image_url — text
- member_name — varchar(15)
- member_id — bigint — Foreign key → member.id — NOT NULL
- store_id — bigint — Foreign key → store.id — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
review_image
- id — bigint — Primary key — NOT NULL
- image_url — text
- review_id — bigint — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
store
- id — bigint — Primary key — NOT NULL
- name — varchar(50)
- region_id — bigint — Foreign key → region.id — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)