UMC-Week1

Tables (8)

book (Untitled2)

  • Key — int — Primary key — NOT NULL
  • Field — VARCHAR
  • Field2 — VARCHAR
  • Field3 — int
  • Field4 — boolean

category (Untitled3)

  • Key — int — Primary key — NOT NULL
  • Field — VARCHAR

map (Untitled7)

  • Key — int — Primary key — NOT NULL

mission (Untitled6)

  • Key (Key2) — int — Foreign key → user.Key — NOT NULL
  • Field2 — VARCHAR
  • Field3 — VARCHAR(100)

notice (Untitled4)

  • Key — int — Primary key — NOT NULL
  • Field — int
  • Field2 — VARCHAR
  • Field3 — VARCHAR

store (Untitled8)

  • Key (Key2) — int — Foreign key → map.Key — NOT NULL
  • Field — VARCHAR
  • Field2 — float
  • Field3 — doublereal
  • Field4 — VARCHAR

user (Untitled)

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

user (Untitled5)

  • Key — int — Primary key — NOT NULL
  • Field2 — VARCHAR
  • Field3 — int
  • Field4 — datetime
  • Field5 — datetime
  • Field6 — VARCHAR(40)
  • Field7 — int