week1-mission

Tables (11)

food_categories

  • food_category_id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — STRING — NOT NULL

member_mission

  • member_mission_id (Key) — BIGINT — Primary key — NOT NULL
  • mission_id (Key2) — BIGINT — Foreign key → missions.mission_id — NOT NULL
  • member_id (Key3) — BIGINT — Foreign key → members.member_id — NOT NULL
  • status (Field) — ENUM('COMPLETED' | 'IN PROGRESS') — NOT NULL — 수행 완료 여부
  • completed_at (Field2) — DATETIME — 수행 완료 시점

member_preferences

  • member_preference_id (Key) — BIGINT — Primary key — NOT NULL
  • member_id (Key2) — BIGINT — Foreign key → members.member_id — NOT NULL
  • preference_id (Key3) — BIGINT — Foreign key → preferences.preference_id — NOT NULL

members

  • member_id (Key) — BIGINT — Primary key — NOT NULL
  • nickname (Field) — STRING — NOT NULL
  • created_at (Field2) — DATETIME — NOT NULL
  • password (Field3) — STRING
  • provider (Field4) — STRING
  • social_id (Field5) — STRING
  • is_widthdrawn (Field6) — BOOLEAN — NOT NULL — 탈퇴 여부
  • store_id (Key2) — BIGINT — Foreign key → stores.store_id — NOT NULL

missions

  • mission_id (Key) — BIGINT — Primary key — NOT NULL
  • title (Field) — STRING — NOT NULL — 미션 제목
  • description (Field2) — STRING — NOT NULL — 미션 설명
  • store_id (Key2) — BIGINT — Foreign key → stores.store_id — NOT NULL

notificatons

  • notificaton_id (Key) — BIGINT — Primary key — NOT NULL
  • member_id (Key2) — BIGINT — Foreign key → members.member_id — NOT NULL
  • content (Field2) — STRING — NOT NULL
  • is_read (Field) — BOOLEAN — NOT NULL — 읽었는지 여부
  • crerated_at (Field3) — DATETIME — NOT NULL

points

  • points (Key) — BIGINT — Primary key — NOT NULL
  • amount (Field) — INT — NOT NULL — 받은 포인트의 양
  • reason (Field2) — STRING — NOT NULL — 왜 받았는지
  • created_at (Field3) — DATETIME — NOT NULL — 언제 받았는지
  • region_id (Key2) — BIGINT — Foreign key → regions.region_id — NOT NULL

preferences

  • preference_id (Key) — BIGINT — Primary key — NOT NULL
  • content (Field) — STRING — NOT NULL — 선호도 내용

regions

  • region_id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — STRING — NOT NULL — 지역 이름

reviews

  • review_id (Key) — BIGINT — Primary key — NOT NULL
  • content (Field) — STRING — NOT NULL — 리뷰 내용
  • created_at (Field2) — DATETIME — NOT NULL
  • member_mission_id (Key2) — BIGINT — Foreign key → member_mission.member_mission_id — NOT NULL

stores

  • store_id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — STRING — NOT NULL
  • description (Field3) — STRING
  • region_id (Key2) — BIGINT — Foreign key → regions.region_id — NOT NULL
  • food_category_id (Key3) — BIGINT — Foreign key → food_categories.food_category_id — NOT NULL
  • latitude (Field2) — DECIMAL — 위도
  • longitude (Field4) — DECIMAL — 경도