project
Tables (9)
Category (Untitled2)
- id — varchar(50) — Primary key — NOT NULL
- name
- dish
- beverage
- desert
Order (Untitled8)
- id — integer — Primary key — NOT NULL
- user_id — integer — Primary key — NOT NULL
- id (id2) — integer — Foreign key → User.id — NOT NULL
- created_at — datetime
- cnt — integer
- Field3
Payment (Untitled9)
- id — Primary key — NOT NULL
- Field
- Field2
User (Untitled)
- id — integer — Primary key — NOT NULL
- first_name — varchar(50)
- last_name — varchar(50)
- role — varchar(50)
- phone — varchar(50)
- email — varchar(50)
- telegram_uid — varchar(50)
- login — varchar(50)
- password — varchar(50)
- created_at — datetime
- updated_at — datetime
dic (Untitled7)
- id — Primary key — NOT NULL
- id (id2) — varchar(50) — Primary key — NOT NULL
- id (id3) — varchar(50) — Foreign key → term.id — NOT NULL
- name — varchar(100)
- Field2
full descr (Untitled5)
- id — varchar(50) — Primary key — NOT NULL
- Field — varchar(50)
product (Untitled3)
- id — Primary key — NOT NULL
- name
short descr (Untitled4)
- id — Primary key — NOT NULL
- name — varchar(50)
- image — json
- price
term (Untitled6)
- id — varchar(50) — Primary key — NOT NULL
- term — varchar(50)
- sign — varchar(50)
- created_at — datetime
- updated_at — datetime
- val — integer
- val_str — string
- Field2