umc5-chap04
Tables (11)
food_category
- category_id — bigint — Primary key — NOT NULL
- name — varchar(20)
mission
- mission_id — bigint — Primary key — NOT NULL
- store_id — bigint — Foreign key → store.store_id — NOT NULL
- contents — text
- score — int
review
- review_id — bigint — Primary key — NOT NULL
- store_id — bigint — Foreign key → store.store_id — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- rating — double
- contents — varchar(500)
- update_at — datetime
- create_at — datetime
review_comment
- comment_id — bigint — Primary key — NOT NULL
- contents — text
- create_at — datetime
- update_at — datetime
- review_id — bigint — Foreign key → review.review_id — NOT NULL
review_image
- image_id — bigint — Primary key — NOT NULL
- url — text
- review_id — bigint — Foreign key → review.review_id — NOT NULL
store
- store_id — bigint — Primary key — NOT NULL
- name — varchar(50)
- category_id — bigint — Foreign key → food_category.category_id — NOT NULL
- zip_code_id — Foreign key → zip_code.zip_code_id — NOT NULL
- coordinate — point
- detail_address — varchar(255)
- img_url — text
- status — varchar(20)
- rating — double
- rate_count — int
store_image
- image_id — bigint — Primary key — NOT NULL
- url — text
- store_id — bigint — Foreign key → store.store_id — NOT NULL
user
- user_id — bigint — Primary key — NOT NULL
- gender — varchar(10)
- birth — datetime
- email — varchar(320)
- phonenumber — vharchar(15)
- user_name — varchar(20)
- password — varchar(20)
- nickname — varchar(20)
- location_permission — boolean
- marketing_permission — boolean
- zip_code_id — Foreign key → zip_code.zip_code_id — NOT NULL
- detail_address — varchar(255)
- coordinate — point
- status — varchar(20)
- inactive_date — datetime
user_mission
- user_mission_id — bigint — Primary key — NOT NULL
- mission_id — bigint — Foreign key → mission.mission_id — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- status — varchar(10)
- create_at — datetime
- complete_at — datetime
user_prefer_food_category
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- category_id — bigint — Foreign key → food_category.category_id — NOT NULL
zip_code
- zip_code_id — bigint — Primary key — NOT NULL
- zip_code — varchar(10)