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