UMC Spring Week1

Tables (7)

Region

  • regionID (Key) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

Untitled (User)

  • Key — Primary key — NOT NULL
  • Field
  • Field3
  • Field2
  • Field4
  • Field5

Untitled (Store)

  • Key — Primary key — NOT NULL
  • Field2
  • Field
  • Field3
  • regionID (Key2) — Foreign key → Region.regionID — NOT NULL
  • Field4

Untitled (UserMission)

  • Key — Primary key — NOT NULL
  • Field2
  • Key (Key2) — Foreign key → Untitled.Key — NOT NULL
  • Key3 — Foreign key → Untitled.Key3 — NOT NULL
  • Field
  • Field3
  • Field4

Untitled (UserRegionProgress)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Key (Key2) — Foreign key → Untitled.Key — NOT NULL
  • regionID (Key3) — Foreign key → Region.regionID — NOT NULL
  • Field3
  • Field4

Untitled (PointHistory)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Key (Key2) — Foreign key → Untitled.Key — NOT NULL
  • Field4
  • Field5

Untitled (Mission)

  • Key3 — Primary key — NOT NULL
  • Key — Foreign key → Untitled.Key — NOT NULL
  • Field2
  • Field3
  • Field4
  • Field5