Food service

Tables (8)

Category (category)

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

Dic (dic)

  • id — integer — Primary key — NOT NULL
  • name — varhcar(50)
  • sign — varchar(100)
  • created_at — datetime

Order (order)

  • id — integer — Primary key — NOT NULL
  • user_id — integer — Foreign key → User.id — NOT NULL
  • status — integer
  • cost — float
  • comment — varchar(100)
  • type_pay — integer
  • status_pay — integer
  • created_at — datetime
  • updated_at — datetime

Order_x_product (order_x_product)

  • order_id — integer — Foreign key → Order.id — NOT NULL
  • product_id — integer — Foreign key → Product.id — NOT NULL
  • cnt — integer
  • created_at — datetime

Product (product)

  • id — integer — Primary key — NOT NULL
  • category_id — integer — Foreign key → Category.id — NOT NULL
  • name — varchar(50)
  • price — float
  • discount — float
  • imgs — json
  • description — varchar(100)
  • full_description — varchar(500)
  • created_at — datetime
  • updated_at — datetime

Review (review)

  • id — integer — Primary key — NOT NULL
  • product_id — integer — Foreign key → Product.id — NOT NULL
  • user_id — integer — Foreign key → User.id — NOT NULL
  • message — varchar(1000)
  • photos — json
  • created_at — datetime
  • updated_at — datetime

Term (term)

  • id — integer — Primary key — NOT NULL
  • dic_id — integer — Foreign key → Dic.id — NOT NULL
  • term — varchar(100)
  • sign — varchar(100)
  • status — integer
  • val — integer
  • val_str — string
  • val_js — json
  • created_at — datetime
  • updated_at — datetime

User (user)

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