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)