0주차

테이블 (8)

location

  • location_id — BIGINT — 기본 키 — NOT NULL
  • location_name — VARCHAR(30) — NOT NULL

mission

  • mission_id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(50) — NOT NULL
  • description — VARCHAR(200) — NOT NULL
  • point — INT — NOT NULL
  • deadline — DATE — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • store_id — BIGINT — 외래 키 → store.store_id — NOT NULL

review

  • review_id — BIGINT — 기본 키 — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • rating — INT — NOT NULL
  • user_id — NOTNULL — 외래 키 → user.user_id — NOT NULL
  • store_id — BIGINT — 외래 키 → store.store_id — NOT NULL

review_photo

  • review_photo_id — BIGINT — 기본 키 — NOT NULL
  • review_photo_url — VARCHAR(100)
  • review_id — BIGINT — 외래 키 → review.review_id — NOT NULL

review_reply

  • reply_id — BIGINT — 기본 키 — NOT NULL
  • content — TEXT — NOT NULL
  • review_id — BIGINT — 외래 키 → review.review_id — NOT NULL

store

  • store_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • manager_code — BIGINT — NOT NULL
  • detail_address — VARCHAR(100) — NOT NULL
  • location_id — NOTNULL — 외래 키 → location.location_id — NOT NULL

user

  • user_id — NOTNULL — 기본 키 — NOT NULL
  • social_type — ENUM('KAKAO','NAVER','APPLE','GOOGLE') — NOT NULL
  • social_id — VARCHAR(50) — NOT NULL
  • name — VARCHAR(10) — NOT NULL
  • gender — ENUM('FEMALE','MALE','OTHER') — NOT NULL
  • birth — DATE — NOT NULL
  • address — VARCHAR(100) — NOT NULL
  • email — VARCHAR(30) — NOT NULL
  • phone_number — VARCHAR(15)
  • point — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

user_mission

  • user_mission_id — BIGINT — 기본 키 — NOT NULL
  • status — ENUM('ASSIGNED','IN_PROGRESS','CLEARED','FAILED') — NOT NULL
  • started_at — DATETIME
  • cleared_at — DATETIME
  • updated_at — TIMESTAMP
  • mission_id — BIGINT — 외래 키 → mission.mission_id — NOT NULL
  • user_id — NOTNULL — 외래 키 → user.user_id — NOT NULL