umc 1week
Tables (9)
Untitled (food_category)
- Key (id) — int — Primary key — NOT NULL
- Field (name) — varchar — NOT NULL
- Field
Untitled (user_food_select)
- Key (id) — Primary key — NOT NULL
- Key (user_id) — int — Foreign key → user.Key — NOT NULL
- Key (food_id) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (oauth_provider)
- Key (id) — Primary key — NOT NULL
- Field (name) — NOT NULL
- Field (activation)
Untitled (oauth_connection)
- Key (oauth_id) — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — int — Foreign key → user.Key — NOT NULL
Untitled (region)
- Key (region_id) — Primary key — NOT NULL
Untitled (store)
- Key (store_id) — Primary key — NOT NULL
- Key (region_id) — Foreign key → Untitled.Key — NOT NULL
Untitled (mission)
- Key (mission_id) — Primary key — NOT NULL
- Field (point)
- Field2 (expire_date)
- Key (store_id) — Foreign key → Untitled.Key — NOT NULL
- Field (mission_amount)
Untitled (mission_complete)
- Key (id) — Primary key — NOT NULL
- Key (user_id) — int — Foreign key → user.Key — NOT NULL
- Key (mission_id) — Foreign key → Untitled.Key — NOT NULL
- Field (complete_date)
user
- Key (id) — int — Primary key — NOT NULL
- Field (name) — varchar — NOT NULL
- Field (sex) — varchar — NOT NULL
- Field (birthday) — date — NOT NULL
- Field (address) — varchar — NOT NULL
- Field (address_detail) — varchar — NOT NULL
- Field (point)
- Field (email)
- Field (telephone)