umc0주차

테이블 (7)

Member

  • member_id — INT — 기본 키
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100)
  • phone_number — VARCHAR(20)
  • total_points — INT
  • status — VARCHAR(20)
  • created_at — DATETIME
  • updated_at — DATETIME
  • point_history_id — INT — 외래 키 → Point_History.point_history_id
  • notification_id — INT — 외래 키 → Notification.notification_id

Member_Mission

  • member_mission_id — INT — 기본 키
  • member_id — INT
  • mission_id — INT
  • status — VARCHAR(20)
  • assigned_at — DATETIME
  • completed_at — DATETIME
  • mission_id (mission_id2) — INT — 외래 키 → Mission.mission_id
  • review_id — INT — 외래 키 → Review.review_id
  • member_id (member_id2) — INT — 외래 키 → Member.member_id

Mission

  • mission_id — INT — 기본 키
  • store_id — INT
  • title — VARCHAR(255)
  • description — TEXT
  • reward_points — INT
  • start_date — DATE
  • end_date — DATE
  • status — VARCHAR(20)
  • created_at — DATETIME
  • store_id (store_id2) — INT — 외래 키 → Store.store_id

Notification

  • notification_id — INT — 기본 키
  • member_id — INT
  • type — VARCHAR(50)
  • content — TEXT
  • is_read — BOOLEAN
  • created_at — DATETIME

Point_History

  • point_history_id — INT — 기본 키
  • member_id — INT
  • amount — INT
  • reason — VARCHAR(255)
  • related_id — INT
  • created_at — DATETIME

Review

  • review_id — INT — 기본 키
  • member_mission_id — INT
  • rating — INT
  • content — TEXT
  • image_url — VARCHAR(255)
  • created_at — DATETIME

Store

  • store_id — INT — 기본 키
  • store_name — VARCHAR(255) — NOT NULL
  • address — VARCHAR(255)
  • latitude — DECIMAL(10, 7)
  • longitude — DECIMAL(10, 7)
  • description — TEXT
  • phone_number — VARCHAR(20)
  • category — VARCHAR(50)