UMC 10th 1weak

Tables (5)

Untitled (User)

  • Key (user_id) — INT — Primary key — NOT NULL
  • Field (email) — VARCHAR(100)
  • Field2 (password) — VARCHAR(100)
  • Field3 (nickname) — VARCHAR(50)
  • Field4 (point) — INT
  • Field5 (created_at) — INT

Untitled (Region)

  • Key (region_id) — INT — Primary key — NOT NULL
  • Field (region_name) — VARCHAR(50)

Untitled2 (Store)

  • Key (store_id) — INT — Primary key — NOT NULL
  • Field (region_id) — INT
  • Field2 (store_name) — VARCHAR(100)
  • Field3 (address) — VARCHAR(200)
  • Key (region_id2) — INT — Foreign key → Untitled.Key — NOT NULL

Untitled3 (Mission)

  • Key (mission_id) — INT — Primary key — NOT NULL
  • Field2 (mission_name) — VARCHAR(100)
  • Field3 (point) — INT
  • Key (store_id) — INT — Foreign key → Untitled2.Key — NOT NULL

Untitled4 (User_Mission)

  • Key (user_mission_id) — INT — Primary key — NOT NULL
  • Field (user_id) — INT
  • Field2 (mission_id) — INT
  • Field3 (status) — VARCHAR(20)
  • Field4 (completed_at) — DATETIME
  • Key (mission_id2) — INT — Foreign key → Untitled3.Key — NOT NULL
  • Key (user_id2) — INT — Foreign key → Untitled.Key — NOT NULL