food delivery

Tables (11)

Category (Untitled2)

  • id — integer — Primary key — NOT NULL
  • name — varchar(50)
  • dish
  • beverage
  • dessert

Coupon (Untitled7)

  • Key — Primary key — NOT NULL
  • Field

Order (Untitled11)

  • id — integer — Primary key — NOT NULL
  • user_id — integer — Foreign key → User.id — NOT NULL
  • created_at — datetime
  • cnt — integer

Product (Untitled3)

  • id — integer — Primary key — NOT NULL
  • name

Restaraunt (Untitled6)

  • Key — Primary key — NOT NULL
  • Name (name) — varchar(200)
  • Field

User (Untitled)

  • id — integer — Primary key — NOT NULL
  • First name (first_name) — varchar(50)
  • Last name (last_name) — varchar(50)
  • role — varchar(50)
  • phone — varchar(11)
  • email — varchar(50)
  • tg_uid — varchar(50)
  • login — varchar(50)
  • password — varchar(30)
  • created_at — datetime
  • updated_at — datetime

dic (Untitled9)

  • id — Primary key — NOT NULL
  • id (id2) — varchar(50) — Foreign key → term.id — NOT NULL
  • name — varchar(100)
  • Field

fulldescr (Untitled5)

  • id — varchar(50) — Primary key — NOT NULL
  • name — varchar(50)
  • Field

payment (Untitled10)

  • Key — Primary key — NOT NULL
  • Field

shortdescr (Untitled4)

  • id — Primary key — NOT NULL
  • name — varchar(50)
  • image — json
  • price

term (Untitled8)

  • id — varchar(50) — Primary key — NOT NULL
  • term — varchar(100)
  • sign — varchar(100)
  • created_at — datetime
  • updated_at — datetime
  • val — integer
  • val_str — string
  • Field