UMC
Tables (5)
mission (Untitled3)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → user.Key — NOT NULL
- Key (Key22) — enum — Foreign key → user.Key — NOT NULL
- point — bigint
- store_name — varchar
- deadline — date
- owner_num — bigint
prefer (Untitled2)
- Key — enum — Primary key — NOT NULL
- Korean — enum
- Japanese — enum
- Chinese — enum
- Western — enum
- Chicken — enum
- Korean Street Foodld (Korean Street Food) — enum
- Meat/Grill — enum
- Lunch Box — enum
- Late Night Food — enum
- Fast Food — enum
- Dessert — enum
- Asian Food — enum
review (Untitled5)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → store.Key — NOT NULL
- Key (Key22) — Foreign key → store.Key — NOT NULL
- Key (Key222) — Foreign key → store.Key — NOT NULL
- Key (Key2222) — enum — Foreign key → store.Key — NOT NULL
- Key (Key3) — enum — Foreign key → store.Key — NOT NULL
- count — bigint
- photo — varchar
- nickname — varchar
- store (score) — varchar
- date — date
store (Untitled4)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → mission.Key — NOT NULL
- Key (Key22) — Foreign key → mission.Key — NOT NULL
- Key (Key222) — enum — Foreign key → mission.Key — NOT NULL
- Key (Key3) — enum — Foreign key → prefer.Key — NOT NULL
- name — varchar
- station — varchar
- score — bigint
- point — bigint
- distance — double
- location — varchar
- main_photo — varchar
user (Untitled)
- Key — Primary key — NOT NULL
- Key (Key2) — enum — Foreign key → prefer.Key — NOT NULL
- name — varchar
- sex — varchar
- birth — date
- address — varchar