dsfsdf

Tables (16)

food_category

  • id — BIGINT — NOT NULL
  • category_name — VARCHAR(50) — NOT NULL

inquiry

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — VARCHAR(500)
  • status — BOOLEAN
  • created_at — DATETIME — NOT NULL

inquiry_image

  • id — BIGINT — NOT NULL
  • inquiry_id — BIGINT — Foreign key → inquiry.id — NOT NULL
  • image_url — VARCHAR(200) — NOT NULL
  • image_order — BIGINT — NOT NULL

mission

  • id — BIGINT — NOT NULL
  • store_id — BIGINT — Foreign key → store.id — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • reward_point — BIGINT — NOT NULL

notification

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • review_id — BIGINT — Foreign key → review.id
  • mission_id — BIGINT — Foreign key → mission.id
  • type — VARCHAR(30) — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • is_read — BOOLEAN
  • created_at — DATETIME — NOT NULL

point_history

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • point — BIGINT — NOT NULL
  • store_name — VARCHAR(100)
  • mission_content — VARCHAR(500)
  • created_at — DATETIME — NOT NULL

region

  • id — BIGINT — NOT NULL
  • region_name — VARCHAR(100) — NOT NULL

review

  • id — BIGINT — NOT NULL
  • store_id — BIGINT — Foreign key → store.id — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • rating — DECIMAL(3,1) — NOT NULL
  • content — VARCHAR(500)
  • created_at — DATETIME — NOT NULL

review_comment

  • id — BIGINT — NOT NULL
  • review_id — BIGINT — Foreign key → review.id — NOT NULL
  • store_id — BIGINT — Foreign key → store.id — NOT NULL
  • content — VARCHAR(500)
  • created_at — DATETIME — NOT NULL

review_image

  • id — BIGINT — NOT NULL
  • review_id — BIGINT — Foreign key → review.id — NOT NULL
  • image_url — VARCHAR(200) — NOT NULL
  • image_order — BIGINT — NOT NULL

store

  • id — BIGINT — NOT NULL
  • store_name — VARCHAR(100) — NOT NULL
  • food_category_id — BIGINT — Foreign key → food_category.id — NOT NULL
  • region_id — BIGINT — Foreign key → region.id — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • latitude — DECIMAL(18,10) — NOT NULL
  • longitude — DECIMAL(18,10) — NOT NULL
  • business_start_hours — DATETIME
  • business_end_hours — DATETIME
  • created_at — DATETIME — NOT NULL

store_image

  • id — BIGINT — NOT NULL
  • store_id — BIGINT — Foreign key → store.id — NOT NULL
  • image_url — VARCHAR(200) — NOT NULL
  • image_order — BIGINT — NOT NULL

user

  • id — BIGINT — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • gender — VARCHAR(10) — NOT NULL
  • birth_date — DATE — NOT NULL
  • region_id — BIGINT — Foreign key → region.id — NOT NULL
  • address — VARCHAR(100) — NOT NULL
  • latitude — DECIMAL(18,10) — NOT NULL
  • longitude — DECIMAL(18,10) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • point — BIGINT
  • email — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(50)
  • event_notification_enabled — BOOLEAN
  • review_reply_notification_enabled — BOOLEAN
  • inquiry_reply_notification_enabled — BOOLEAN

user_food_category

  • food_category_id — BIGINT — Foreign key → food_category.id — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL

user_mission

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • mission_id — BIGINT — Foreign key → mission.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • deadline — DATETIME — NOT NULL

user_region_mission_count

  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • region_id — BIGINT — Foreign key → region.id — NOT NULL
  • mission_count — BIGINT