Food sevice
Tables (9)
category
- id — Integer — Primary key — NOT NULL
- up — Integer
- name — Varchar(50)
- description — Varchar(100)
- ord — Integer
- status — Integer
- image_name — Varchar(100)
- create_at — Datetime
- update_at — Datetime
dic
- Id — Integer — Primary key — NOT NULL
- name — Varchar(100)
like
- id — Integer — Primary key — NOT NULL
- review_product_id — Integer — Foreign key → review.id — NOT NULL
- type — Integer
- created_at — Datetime
order
- id — Integer — Primary key — NOT NULL
- user_id — Integer — Foreign key → user.id — NOT NULL
- comment — Varchar(100)
- phone — Varchar(50)
- status — Integer
- type_pay — Integer
- address — Varchar(50)
- Estimated_order_time — Datetime
- created_at (Field) — Datetime
product
- id — Integer — Primary key — NOT NULL
- category_id (category_id2) — Integer — Foreign key → category.id — NOT NULL
- name — Varchar(50)
- desription (description) — Varchar(100)
- full_description — Varchar(200)
- thumbnail — Varchar(50)
- images — Json
- ord — Integer
- status — Integer
- create_at — Datetime
- update_at — Datetime
- like_count — Integer
product_order
- Id — Integer — Primary key — NOT NULL
- order_id — Integer — Foreign key → order.id — NOT NULL
- product_id — Integer — Foreign key → product.id — NOT NULL
review
- id — Integer — Primary key — NOT NULL
- user_id — Integer — Foreign key → user.id — NOT NULL
- product_id — Integer — Foreign key → product.id — NOT NULL
- message — Varchar(100)
- created_at — Datetime
- updated_at — Datetime
term
- id — integer — Primary key — NOT NULL
- Id_dic — Integer — Foreign key → dic.Id — NOT NULL
- term — Varchar(100)
- sign — Varchar(100)
- status — Integer
- created_at — Datetime
- update_at — Datetime
- val_s — Varchar(50)
- val_j — Json
user
- id — Integer — Primary key — NOT NULL
- first_name — Varchar(50)
- last_name — Varchar(50)
- role — Integer
- status — Integer
- email — Varchar(50)
- login — Varchar(50)
- password — Varchar(50)
- telegram_uid — Varchar(50)
- phone — Varchar(50)
- created_at — Datatime
- updated_at — Datatime