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