Food service

Tables (7)

category

  • id_category — integer — Primary key — NOT NULL
  • id — integer
  • up — integer
  • thumb — varchar(100)
  • name — varchar(50)
  • description — varchar(300)
  • ord — integer
  • created_at — datatime
  • updated_at — timetime

dictionary

  • id_dictionary — integer
  • name — varchar(50)

order

  • id_order — integer — Primary key — NOT NULL
  • id_product — integer — Foreign key → product.id_product — NOT NULL
  • id_category — integer — Foreign key → product.id_category — NOT NULL
  • id (id2) — integer — Foreign key → user.id — NOT NULL
  • price — float
  • status — integer
  • created_at — datatime
  • updated_at — datatime

product

  • id_product — integer — Primary key — NOT NULL
  • id_category — integer — Foreign key → category.id_category — NOT NULL
  • imgs — json
  • category_id — integer
  • name — varchar(50)
  • price — numeric
  • description — varchar(300)
  • full_description — varchar(500)
  • created_at — datatime
  • updated-at — datatime

review

  • id_product — integer — Foreign key → product.id_product — NOT NULL
  • id_category — integer — Foreign key → product.id_category — NOT NULL
  • id (id2) — integer — Foreign key → user.id — NOT NULL
  • id_review — integer
  • photos — json
  • message — varchar(200)
  • created_at — datatime
  • updated_at — datatime

term

  • term — varchar(100)
  • sign — varchar(100)
  • id_term — integer

user

  • id — integer — Primary key — NOT NULL
  • first_name — varchar(50)
  • last_name — varchar(50) — NOT NULL
  • role — Integer
  • status — Integer
  • email — varchar(50)
  • login — varcahar(50)
  • password — varchar(50)
  • phone — integer
  • created_at (create_at) — datatime
  • updated_at — datatime
  • telegram_uid — varchar(50)