cors back
Tables (8)
cart
- PRIMARY — KEY`
- FOREIGN — KEY(user_id) — NOT NULL
- PRIMARY — KEY2` — NOT NULL
- created_at — DATETIME
order_items
- PRIMARY — KEY`
- FOREIGN — KEY(order_id) — NOT NULL
- FOREIGN — KEY(product_id) — NOT NULL
- PRIMARY — KEY2`
- FOREIGN — KEY(user_id) — NOT NULL
- PRIMARY — KEY22`
- FOREIGN — KEY(user_id) — NOT NULL
- PRIMARY — KEY222` — NOT NULL
- quantity — INT — NOT NULL
- price_each — DECIMAL(10,2)
orders
- PRIMARY — KEY`
- FOREIGN — KEY(user_id) — NOT NULL
- PRIMARY — KEY2`
- FOREIGN — KEY(user_id) — NOT NULL
- PRIMARY — KEY22` — NOT NULL
- total_price — DECIMAL(10,2)
- payment_method — VARCHAR(50)
- status — ENUM('pending', 'paid', 'cancelled', 'completed')
- created_at — DATETIME
owners
- Key — Primary key — NOT NULL
- PRIMARY (PRIMARYKEY) — KEY` — Primary key — NOT NULL
- FOREIGN — KEY(user_id) — NOT NULL
- PRIMARY — KEY2` — NOT NULL
- store_count — INT — NOT NULL
products
- PRIMARY — KEY`
- FOREIGN — KEY(store_id) — NOT NULL
- PRIMARY — KEY`
- FOREIGN — KEY — NOT NULL
- PRIMARY — KEY2` — NOT NULL
- FOREIGN — KEY(user_id) — NOT NULL
- PRIMARY — KEY22` — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- price — DECIMAL(10,2) — NOT NULL
- category_id — BIGINT
- stock — INT
- is_active — BOOLEAN
- created_at — DATETIME
reservations
- PRIMARY — KEY`
- FOREIGN — KEY(user_id) — NOT NULL
- FOREIGN — KEY(store_id) — NOT NULL
- PRIMARY — KEY2` — NOT NULL
- PRIMARY — KEY`
- FOREIGN — KEY — NOT NULL
- PRIMARY — KEY3` — NOT NULL
- FOREIGN — KEY(user_id) — NOT NULL
- PRIMARY — KEY22` — NOT NULL
- reserve_date — DATETIME — NOT NULL
- status — ENUM('reserved', 'cancelled', 'completed')
- created_at — DATETIME
stores
- PRIMARY — KEY`
- FOREIGN — KEY — NOT NULL
- PRIMARY — KEY` — NOT NULL
- FOREIGN — KEY(user_id) — NOT NULL
- PRIMARY — KEY2` — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- address — VARCHAR(255)
- lat — DECIMAL(10,7)
- lng — DECIMAL(10,7)
- phone — VARCHAR(20)
- category_id — BIGINT
- rating_avg — DECIMAL(2,1)
- created_at — DATETIME
users
- PRIMARY — KEY` — Primary key — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50)
- phone — VARCHAR(13)
- role — ENUM(''customer, 'owner', 'admin')
- created_at — DATETIME