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)