UMC_W2
Tables (12)
alarm
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- type (Field) — varchar(30)
- checked — bool
- created_at — datetime(6)
- updated_at — datetime(6)
food_category
- id — bigint — Primary key — NOT NULL
- name — varchar(20)
meal
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- store_id — bigint — Foreign key → store.region_id — NOT NULL
- paid_amount — int
- paid_at — datetime
mission
- id — bigint — Primary key — NOT NULL
- region_id — bigint — Foreign key → region.id — NOT NULL
- store_id — bigint — Foreign key → store.id — NOT NULL
- tittle — varchar(40)
- created_at — datetime(6)
- updated_at — datetime(6)
- started_at — datetime
- end_at — datetime
- is_active — boolean
- reqiured_store_count — int
- min_amount — int
- point — int
point
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- point_date — datetime
- point_num — int
preference_survey
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- food_category_id — bigint — Foreign key → food_category.id — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
region
- id — bigint — Primary key — NOT NULL
- name — varchar(30)
review
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- store_id — bigint — Foreign key → store.id — NOT NULL
- user_mission_id — bigint — Foreign key → user_mission.mission_id — NOT NULL
- review_ image_id — bigint — Foreign key → user_mission.review_id — NOT NULL
- content — text
- score — int
- created_at — datetime(6)
- updated_at — datetime(6)
review_image
- id — bigint — Primary key — NOT NULL
- review_id — bigint — Foreign key → review.user_id — NOT NULL
- image_url (imgae_url) — varchar(50)
- created_at — datetime(6)
- updated_at — datetime(6)
store
- id — bigint — Primary key — NOT NULL
- region_id — bigint — Foreign key → region.id — NOT NULL
- name — varchar(20)
- address — varchar(30)
- oper_time — json
- created_at — datetime(6)
- updated_at — datetime(6)
user
- id — bigint — Primary key — NOT NULL
- name — varchar(20)
- gender — varchar(10)
- birth — date
- address — varchar(30)
- agree — boolean
- status — varchar(15)
- inactive_date — datetime
- created_at — datetime(6)
- updated_at — datetime(6)
- point — int
- password — varchar(255)
user_mission
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- mission_id — bigint — Foreign key → mission.id — NOT NULL
- review_id — bigint — Foreign key → mission.store_id — NOT NULL
- status — varchar(20)
- progress_count — int
- created_at — datetime