food delivery
Tables (11)
Category (Untitled2)
- id — integer — Primary key — NOT NULL
- name — varchar(50)
- dish
- beverage
- dessert
Coupon (Untitled7)
- Key — Primary key — NOT NULL
- Field
Order (Untitled11)
- id — integer — Primary key — NOT NULL
- user_id — integer — Foreign key → User.id — NOT NULL
- created_at — datetime
- cnt — integer
Product (Untitled3)
- id — integer — Primary key — NOT NULL
- name
Restaraunt (Untitled6)
- Key — Primary key — NOT NULL
- Name (name) — varchar(200)
- Field
User (Untitled)
- id — integer — Primary key — NOT NULL
- First name (first_name) — varchar(50)
- Last name (last_name) — varchar(50)
- role — varchar(50)
- phone — varchar(11)
- email — varchar(50)
- tg_uid — varchar(50)
- login — varchar(50)
- password — varchar(30)
- created_at — datetime
- updated_at — datetime
dic (Untitled9)
- id — Primary key — NOT NULL
- id (id2) — varchar(50) — Foreign key → term.id — NOT NULL
- name — varchar(100)
- Field
fulldescr (Untitled5)
- id — varchar(50) — Primary key — NOT NULL
- name — varchar(50)
- Field
payment (Untitled10)
- Key — Primary key — NOT NULL
- Field
shortdescr (Untitled4)
- id — Primary key — NOT NULL
- name — varchar(50)
- image — json
- price
term (Untitled8)
- id — varchar(50) — Primary key — NOT NULL
- term — varchar(100)
- sign — varchar(100)
- created_at — datetime
- updated_at — datetime
- val — integer
- val_str — string
- Field