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