test1

Tables (9)

complain

  • complain_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255)
  • content — TEXT
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL

complain_image

  • image_id — BIGINT — Primary key — NOT NULL
  • url — TEXT
  • title — VARCHAR(255)
  • complain_id — BIGINT — Foreign key → complain.complain_id — NOT NULL

mission

  • id (mission_id) — BIGINT — Primary key — NOT NULL
  • Field (reward) — BIGINT
  • Field (deadline) — INT
  • Field (mission_spec) — TEXT
  • Field (created_at) — DATETIME
  • Field (updated_at) — DATETIME
  • store_id — BIGINT — Foreign key → store.store_id — NOT NULL

region

  • region_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • address — VARCHAR(255)

review

  • review_id — BIGINT — Primary key — NOT NULL
  • contents — VARCHAR(255)
  • created_date — DATETIME
  • updated_date — DATETIME
  • status — BOOLEAN
  • rating — FLOAT
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • store_id — BIGINT — Foreign key → store.store_id — NOT NULL

review_image

  • image_id — BIGINT — Primary key — NOT NULL
  • url — TEXT
  • title — VARCHAR(255)
  • review_id — BIGINT — Foreign key → review.review_id — NOT NULL

store

  • store_id — BIGINT — Primary key — NOT NULL
  • store_name — VARCHAR(255)
  • price — BIGINT
  • Field (score) — FLOAT
  • manager_id — BIGINT
  • region_id — BIGINT — Foreign key → region.region_id — NOT NULL

user

  • user_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • id — VARCHAR(255)
  • password — VARCHAR(255)
  • nickname — VARCHAR(255)
  • count — BIGINT
  • gender — INT
  • birthday — DATETIME
  • address — VARCHAR(255)
  • alarm — BOOLEAN
  • total_point — BIGINT
  • Field (email) — VARCHAR(255)

user_mission

  • id — BIGINT — Primary key — NOT NULL
  • status — VARCHAR(225)
  • created_at — DATETIME
  • updated_at — DATETIME
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • id (mission_id) — BIGINT — Foreign key → mission.id — NOT NULL