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)