1stweek

Tables (6)

Food (Untitled5)

  • Key — bigint — Primary key — NOT NULL
  • Field

Food_Prefer (Untitled6)

  • Key — bigint — Primary key — NOT NULL
  • Key (Key2) — bigint — Foreign key → Member.Key — NOT NULL
  • Key (Key3) — bigint — Foreign key → Food.Key — NOT NULL
  • Field

Member (Untitled)

  • Key — bigint — Primary key — NOT NULL
  • Field — varchar(10)
  • Field2 — enum
  • Field3 — varchar(20)
  • Field4 — varchar(1)
  • Field5

Mission (Untitled2)

  • Key — bigint — Primary key — NOT NULL
  • Key (Key2) — bigint — Foreign key → Member.Key — NOT NULL
  • Field2 — bigint
  • (Field) — bigint
  • Field3 — text
  • Field4 — bigint
  • Field5 — enum

Restaurant (Untitled4)

  • Key — bigint — Primary key — NOT NULL
  • Key (Key2) — bigint — Foreign key → Mission.Key — NOT NULL
  • Key (Key22) — bigint — Foreign key → Mission.Key — NOT NULL
  • Field — varchar(10)

Review (Untitled3)

  • Key — varchar(5) — Primary key — NOT NULL
  • Key (Key2) — bigint — Foreign key → Restaurant.Key — NOT NULL
  • Key (Key22) — bigint — Foreign key → Restaurant.Key — NOT NULL
  • Key (Key222) — bigint — Foreign key → Restaurant.Key — NOT NULL
  • Field — DateTIme
  • Field2 — text