UMC-7th_week1
Tables (8)
Untitled (member)
- Key (id) — long — Primary key — NOT NULL
- Field (name) — varchar
- Field (gender) — varchar
- Field (birth) — localdate
- Field (address) — varchar
- Field (agreement) — varchar
- Field (status) — varchar
- Field (created_at) — localdate
- Field (updated_at) — localdate
Untitled (food_prefer)
- Key (id) — long — Primary key — NOT NULL
- Field (category) — varchar
Untitled (member_prefer)
- Key (id) — long — Primary key — NOT NULL
- Key (member_id) — long — Foreign key → Untitled.Key — NOT NULL
- Key (prefer_id) — long — Foreign key → Untitled.Key — NOT NULL
Untitled (region)
- Key (id) — long — Primary key — NOT NULL
- Field (name) — varchar
- Field (location) — varchar
Untitled (store)
- Key (id) — long — Primary key — NOT NULL
- Key (region_id) — long — Foreign key → Untitled.Key — NOT NULL
- Field (name) — varchar
- Field (location) — varchar
Untitled (home)
- Key (id) — long — Primary key — NOT NULL
- Key (mission_id) — long — Foreign key → Untitled.Key — NOT NULL
- Key (store_id) — long — Foreign key → Untitled.Key — NOT NULL
- Key (region_id) — long — Foreign key → Untitled.Key — NOT NULL
- Key (member_id) — long — Foreign key → Untitled.Key — NOT NULL
- Field (status) — varchar
Untitled (review)
- Key (id) — long — Primary key — NOT NULL
- Key (store_id) — long — Foreign key → Untitled.Key — NOT NULL
- Key (region_id) — long — Foreign key → Untitled.Key — NOT NULL
- Key (member_id) — long — Foreign key → Untitled.Key — NOT NULL
- Field (star_point) — int
- Field (description) — text
- Field (title) — varchar
Untitled (mission)
- Key (id) — long — Primary key — NOT NULL
- Key (store_id) — long — Foreign key → Untitled.Key — NOT NULL
- Key (region_id) — long — Foreign key → Untitled.Key — NOT NULL
- Field (point) — int