1주차 미션

테이블 (11)

Food category (food_category)

  • food id (food_categoryid) — varchar(10) — 기본 키
  • food category (food_categoryname) — varchar(10)

menu

  • menu id (menu_id) — varchar(10) — 기본 키 — NOT NULL
  • menu name (menu_name) — varchar(100)
  • price (menu_price) — bigint
  • store id (store_id) — varchar(10) — 외래 키 → store.store id — NOT NULL

mission (Untitled)

  • mission_id (Key) — varchar(10) — 기본 키 — NOT NULL
  • region_id (Key2) — varchar(10) — 외래 키 → region.region_id — NOT NULL
  • mission_name (Field) — varchar(100)
  • mission_text (Field2) — text
  • start_at (Field3) — daytime(6)
  • end_at (Field4) — daytime(6)
  • is_active (Field5) — boolean

order

  • order id (order_id) — varchar(10) — 기본 키 — NOT NULL
  • user id (user_id) — varchar(10) — 외래 키 → user.user id — NOT NULL
  • store id (store_id) — varchar(10) — 외래 키 → store.store id — NOT NULL
  • order date (order_date) — datetime(6)
  • total price (total_price) — bigint

point (Untitled3)

  • point_id (Key) — varchar(10) — 기본 키 — NOT NULL
  • user id (user_id) — varchar(10) — 외래 키 → user.user id — NOT NULL
  • current_point (Field) — bigint
  • last_use_at (Field2) — daytime(6)
  • update_at (Field3) — daytime(6)

preference food (preference_food)

  • food id (food_categoryid) — varchar(10) — 외래 키 → Food category.food id
  • user id (user_id) — varchar(10) — 외래 키 → user.user id — NOT NULL

region (Untitled5)

  • region_id (Key) — varchar(10) — 기본 키 — NOT NULL
  • region_name (Field) — varchar(40)
  • latitude (Field2) — bigint
  • radius (Field3) — bigint
  • longitude (Field4) — bigint

review (Untitled4)

  • review_id (Key) — varchar(10) — 기본 키 — NOT NULL
  • user id (user_id) — varchar(10) — 외래 키 → user.user id — NOT NULL
  • store id (store_id) — varchar(10) — 외래 키 → store.store id — NOT NULL
  • rating (Field) — bigint
  • content (Field2) — text
  • created_at (Field3) — daytime(6)
  • update_at (Field4) — daytime(6)
  • deleted (Field5) — boolean

store

  • store id (store_id) — varchar(10) — 기본 키 — NOT NULL
  • food id (food_categoryid) — varchar(10) — 외래 키 → Food category.food id
  • region_id (Key) — varchar(10) — 외래 키 → region.region_id — NOT NULL
  • store name (store_name) — varchar(40)
  • store address (store_address) — varchar(40)
  • store phone (ph_number) — varchar(20)

user

  • user id (user_id) — varchar(10) — 기본 키 — NOT NULL
  • name — varchar(10)
  • password (Field) — varchar(20)
  • gender — varchar(10)
  • address — varchar(40)
  • Date (date) — bigint

user_mission (Untitled2)

  • usermission_id (Key) — varchar(10) — 기본 키 — NOT NULL
  • user id (user_id) — varchar(10) — 외래 키 → user.user id — NOT NULL
  • mission_id (Key2) — varchar(10) — 외래 키 → mission.mission_id — NOT NULL
  • stuts (Field) — varchar(20)
  • progress (Field2) — bigint
  • complete_at (Field3) — daytime(6)
  • assigned_at (Field4) — daytime(6)