Mweireiteng

Tables (6)

Untitled (Restaurant)

  • id — Int — Primary key — NOT NULL
  • Field (name) — String — NOT NULL
  • Field (branch) — String
  • Field (address) — String — NOT NULL
  • Field (tel) — String
  • Field (open) — Time
  • Field (close) — Time
  • Field (img) — String

Untitled (Review)

  • Key (id) — Int — Primary key — NOT NULL
  • Field (title) — String — NOT NULL
  • Field (content) — String
  • Field (hot) — Int — NOT NULL
  • Field2 (mala) — Int — NOT NULL
  • Field (rating) — Int — NOT NULL
  • Field (recommend) — Int — NOT NULL
  • Key (user) — String — Foreign key → Untitled.Key — NOT NULL
  • id (restaurant) — Int — Foreign key → Untitled.id — NOT NULL

Untitled (User)

  • Key (username) — String — Primary key — NOT NULL
  • Field (password) — String — NOT NULL
  • Field (email) — String — NOT NULL

Untitled (Ingredient)

  • Key (id) — int — Primary key — NOT NULL
  • Field (ingredient) — String — NOT NULL
  • Key (type) — Int — Foreign key → Untitled.Key — NOT NULL

Untitled (Malatang)

  • Key (id) — Int — Primary key — NOT NULL
  • Key (review) — Int — Foreign key → Untitled.Key — NOT NULL
  • Key (ingredient) — Int — Foreign key → Untitled.Key — NOT NULL
  • Field (weight) — Int — NOT NULL

Untitled (Type)

  • Key (id) — Int — Primary key — NOT NULL
  • Field (name) — String — NOT NULL