UMC-5th-MissonDB
Tables (5)
Untitled (store)
- Key (id) — int — Primary key — NOT NULL
- Field (name) — varchar(30)
- Field (address) — varchar(50)
- Field (score) — float
Untitled (review)
- Key (id) — int — Primary key — NOT NULL
- Key (store_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — int — Foreign key → Untitled2.Key — NOT NULL
- Field (body) — text
- Field (score) — float
Untitled (misson)
- Key (id) — int — Primary key — NOT NULL
- Key (store_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (name) — varchar(20)
- Field (point) — int
- Field (body) — text
Untitled (misson_of_member)
- Key (misson_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — int — Foreign key → Untitled2.Key — NOT NULL
- Field (state) — varchar(20)
Untitled2 (user)
- Key (id) — int — Primary key — NOT NULL
- Field (name) — varchar(20)
- Field (gender) — varchar(10)
- Field (point) — int
- Field (age) — int