yogiyo

Tables (8)

Untitled (Restaurant)

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Field (name) — NOT NULL
  • Field2 (category) — NOT NULL
  • Field3 (thumbnailUrl) — NOT NULL
  • Field4 (address) — NOT NULL
  • Field5 (lng) — NOT NULL
  • Field (lat) — NOT NULL
  • Field2 (openTime) — NOT NULL
  • Field3 (deliveryTime) — NOT NULL
  • Field4 (representativeMenus) — NOT NULL
  • Field5 (deliveryFee) — NOT NULL
  • Field6 (minOrderAmount) — int(11)
  • Field7 (paymentMethods) — NOT NULL
  • Field8 (created_at) — NOT NULL
  • Field9 (updated_at) — NOT NULL

Untitled (Menu)

  • Key2 (id) — NOT NULL — Primary key — NOT NULL
  • Key (restaurantId) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
  • Field2 (name) — NOT NULL
  • Field (label) — NULL
  • Field3 (price) — NOT NULL
  • Field4 (created_at) — NOT NULL
  • Field5 (updated_at) — NOT NULL

Untitled (Category)

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Field (name) — NOT NULL
  • Field2 (imgUrl) — NOT NULL

Untitled (User)

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Field (name) — NOT NULL
  • Field
  • Field2 (password) — NOT NULL
  • Field3 (address) — NULL
  • Field4 (lng) — NULL
  • Field5 (lat) — NULL
  • Field (phoneNum) — NOT NULL
  • Field (created_at) — NOT NULL
  • Field (updated_atd) — NOT NULL

Untitled (History)

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Key (uid) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
  • Key (restaurantId) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
  • Field3 (orderedMenus) — NOT NULL
  • Field (orderedPrice) — NOT NULL
  • Field2 (orderedDate) — NOT NULL
  • Field (orderedAddress) — NOT NULL

Untitled (Ad)

  • Key — NOT NULL — Primary key — NOT NULL
  • Field (name) — NOT NULL
  • Field (imgUrl) — NOT NULL
  • Field2 (type) — NOT NULL
  • Field (startDate) — NOT NULL
  • Field2 (endDate) — NOT NULL

Untitled (Cart)

  • Key — Primary key — NOT NULL
  • Key2 — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

Untitled (TOS)

  • Key — Primary key — NOT NULL
  • Field (title) — NOT NULL
  • Field2 (content) — NOT NULL
  • Field (isEssential) — NOT NULL