practice

Tables (6)

Mission

  • mission_id (Id) — Bigint — Primary key — NOT NULL — AutoIncrement
  • title — varchar(40) — NOT NULL
  • body — text
  • price — int — NOT NULL
  • ratio — int — NOT NULL

User

  • user_ID (id) — Bigint — Primary key — NOT NULL — Auto Increment
  • name — varchar(20) — NOT NULL — unique
  • gender — varchar(10)
  • birthday — Date — NOT NULL
  • address — varchar(255) — NOT NULL
  • point — int
  • email — varchar(40) — NOT NULL
  • password — varchar(20) — NOT NULL
  • created_date — Date — NOT NULL — Updatable = false
  • last_modified_date — Date — NOT NULL — Updatable = true

User_mission_list

  • mission_id — Bigint — Foreign key → Mission.mission_id — NOT NULL — AutoIncrement
  • user_ID (user_id) — Bigint — Foreign key → User.user_ID — NOT NULL — Auto Increment
  • Field (expired_date) — Date — NOT NULL
  • Field (solved) — bool — NOT NULL

food_category

  • food_id (id) — int — Primary key — NOT NULL — AutoIncrement
  • food_category_name (name) — varchar(20) — NOT NULL
  • user_ID (ID) — Bigint — Foreign key → User.user_ID — NOT NULL — Auto Increment
  • store_id — Bigint — Foreign key → store.store_id — NOT NULL — Auto Increment

review

  • review_id (id) — Bigint — Primary key — NOT NULL — AutoIncrement
  • star — float — NOT NULL
  • review_body (body) — text — NOT NULL
  • review_image_url (image_url) — varchar(255)
  • review_create_date (create_date) — Date — NOT NULL
  • review_reply (reply) — text
  • review_reply_create_date (reply_create_date) — Date
  • store_id — Bigint — Foreign key → store.store_id — NOT NULL — Auto Increment
  • user_ID (user_id) — Bigint — Foreign key → User.user_ID — NOT NULL — Auto Increment
  • Field (image_type) — varchar(40)

store

  • store_id (id) — Bigint — Primary key — NOT NULL — Auto Increment
  • store_name (name) — varchar(40) — NOT NULL
  • open_time — time
  • close_time — time
  • mission_id — Bigint — Foreign key → Mission.mission_id — NOT NULL — AutoIncrement
  • store_image_url (image_url) — varchar(255)
  • Field (region) — varchar(40) — NOT NULL
  • Field (image_type) — varchar(40)