node-01
Tables (18)
bonus_mission
- bonus_mission_id — varchar(5) — Primary key — NOT NULL
- title — varchar(10)
- description — varchar(30)
- required_count — int
- reward_points — int
favorite_food
- favorite_id — varchar(5) — Primary key — NOT NULL
- category_id — varcher(5) — Foreign key → food_category.category_id — NOT NULL
- user_id — varchar(5) — Foreign key → user.user_id — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
food_category
- category_id — varcher(5) — Primary key — NOT NULL
- name — varchar(10)
inquiry
- inquiry_id — varchar(5) — Primary key — NOT NULL
- user_id — varchar(5) — Foreign key → user.user_id — NOT NULL
- title — varchar(10)
- content — varchar(50)
- status — varchar(5)
- created_at — DATETIME
- updated_at — DATETIME
mission
- mission_id — varchar(5) — Primary key — NOT NULL
- title — varchar(20)
- content — varchar(50)
- created_at — DATETIME
- updated_at — DATETIME
- reward_points — int
regions
- regions_id — archer(5) — Primary key — NOT NULL
- name — varchar(10)
review
- review_id — varchar(5) — Primary key — NOT NULL
- user_id — varchar(5) — Foreign key → user.user_id — NOT NULL
- store_id — varchar(5) — Foreign key → store.store_id — NOT NULL
- title — varchar(10)
- content — archer(50)
- asterion — float
- created_at — DATATIME
- updated_at — DATATIME
review_comment
- comment_id — varchar(5) — Primary key — NOT NULL
- user_id — varchar(5) — Foreign key → user.user_id — NOT NULL
- review_id — varchar(5) — Foreign key → review.review_id — NOT NULL
- content — varchar(30)
- created_at — DATETIME
- updated_at — DATETIME
review_image
- review_image_id — varchar(5) — Primary key — NOT NULL
- review_id — varchar(5) — Foreign key → review.review_id — NOT NULL
- image_url — varcher(50)
- uploaded_at — DATETIME
shop_rating
- store_id — varchar(5) — Foreign key → store.store_id — NOT NULL
- average_rating — avg(review.asterion)
- review_count — count(*)
- updated_at — DATETIME
store
- store_id — varchar(5) — Primary key — NOT NULL
- regions_id — archer(5) — Foreign key → regions.regions_id — NOT NULL
- name — varchar(20)
- lat — decimal
- lng — decimal
- created_at — DATETIME
- updated_at — DATETIME
store_image
- store_image_id — varchar(5) — Primary key — NOT NULL
- store_id — varchar(5) — Foreign key → store.store_id — NOT NULL
- image_url — varcher(50)
- uploaded_at — DATETIME
termsOfCondition
- terms_id (trems_id) — varchar(5) — Primary key — NOT NULL
- name — varchar(10)
- content — varchar(50)
- optional — boolean
- created_at — DATETIME
- updated_at — DATETIME
user
- user_id — varchar(5) — Primary key — NOT NULL
- bonus_mission_id — varchar(5) — Foreign key → bonus_mission.bonus_mission_id — NOT NULL
- name — varchar(10)
- nickname — varchar(20)
- email — varchar(10)
- role — varchar(5)
- point — int
- gender — varchar(3)
- date — date
- address — varchar(30)
- created_at — DATETIME
- updated_at — DATETIME
user_image
- user_image_id — varchar(5) — Primary key — NOT NULL
- user_id — varchar(5) — Foreign key → user.user_id — NOT NULL
- image_url — varchar(50)
- uploaded_at — DATETIME
user_mission
- user_mission_id — varchar(5) — Primary key — NOT NULL
- user_id — varchar(5) — Foreign key → user.user_id — NOT NULL
- mission_id (mission_id2) — varchar(5) — Foreign key → mission.mission_id — NOT NULL
- status — varchar(5)
- created_at — DATETIME
- updated_at — DATETIME
user_phone
- user_id — varchar(5) — Foreign key → user.user_id — NOT NULL
- phone_number — varchar(20)
- status — varchar(5)
user_termsOfCondition
- check_id — varchar(5) — Primary key — NOT NULL
- user_id — varchar(5) — Foreign key → user.user_id — NOT NULL
- terms_id (trems_id) — varchar(5) — Foreign key → termsOfCondition.terms_id — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME