project

Tables (9)

Category (Untitled2)

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

Order (Untitled8)

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

Payment (Untitled9)

  • id — Primary key — NOT NULL
  • Field
  • Field2

User (Untitled)

  • id — integer — Primary key — NOT NULL
  • first_name — varchar(50)
  • last_name — varchar(50)
  • role — varchar(50)
  • phone — varchar(50)
  • email — varchar(50)
  • telegram_uid — varchar(50)
  • login — varchar(50)
  • password — varchar(50)
  • created_at — datetime
  • updated_at — datetime

dic (Untitled7)

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

full descr (Untitled5)

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

product (Untitled3)

  • id — Primary key — NOT NULL
  • name

short descr (Untitled4)

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

term (Untitled6)

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