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