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)