week 0 ERD

Tables (6)

Member (Untitled)

  • Key — Primary key — NOT NULL
  • PK (id) — INT
  • (email) — VARCHAR(255)
  • (password) — VARCHAR(255)
  • (name) — VARCHAR(50)
  • (nickname) — VARCHAR(50)
  • (gender) — VARCHAR(10)
  • (birth_date) — DATE
  • (address) — VARCHAR(255)

Member_Mission (Untitled4)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Mission.Key — NOT NULL
  • Key (Key3) — Foreign key → Store.Key — NOT NULL
  • Key (Key22) — Foreign key → Store.Key — NOT NULL
  • Key (Key222) — Foreign key → Store.Key — NOT NULL
  • PK (id) — INT
  • FK (member_id) — INT
  • FK (mission_id) — INT
  • (status) — VARCHAR(20)

Mission (Untitled5)

  • Key — Primary key — NOT NULL
  • PK (id) — INT
  • FK (store_id) — INT
  • (reward) — VARCHAR(100)
  • (deadline) — DATE

Region (Untitled2)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Member.Key — NOT NULL
  • PK (id) — INT
  • (name) — VARCHAR(100)

Region_Progress (Untitled6)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Store.Key — NOT NULL
  • Key (Key22) — Foreign key → Store.Key — NOT NULL
  • Key (Key222) — Foreign key → Store.Key — NOT NULL
  • FK (member_id) — INT
  • FK (region_id) — INT
  • (completed_count) — INT

Store (Untitled3)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Region.Key — NOT NULL
  • Key (Key22) — Foreign key → Region.Key — NOT NULL
  • PK (id) — INT
  • FK (region_id) — INT
  • (name) — VARCHAR(100)
  • (category) — VARCHAR(50)