delivery
Tables (6)
Menu
- menuId — bigint(20) — Primary key — NOT NULL
- category — varchar(100) — NOT NULL
- name — varchar(255) — NOT NULL
- price — int(11) — NOT NULL
- createdAt — timestamp — NOT NULL
- modifiedAt — timestamp — NOT NULL
- deletedAt — timestamp — NOT NULL
- storeId (storeId2) — bigint(20) — Foreign key → Stores.storeId — NOT NULL
OrderMenu (Untitled)
- id — bigint — Primary key — NOT NULL
- quantity — int
- createdAt — timestamp
- modifiedAt — timestamp
- deletedAt — timestamp
- menuId — bigint(20) — Foreign key → Menu.menuId — NOT NULL
- orderId — bigint(20) — Foreign key → Orders.orderId — NOT NULL
Orders
- orderId — bigint(20) — Primary key — NOT NULL
- totalPrice — int(11) — NOT NULL
- requests — varchar(255)
- createdAt — timestamp — NOT NULL
- modifiedAt — timestamp — NOT NULL
- status — varchar — NOT NULL
- userId (userId2) — bigint(20) — Foreign key → Users.user_Id — NOT NULL
- storeId (storeId2) — bigint(20) — Foreign key → Stores.storeId — NOT NULL
Reviews
- reviewId — bigint(20) — Primary key — NOT NULL
- rating — int(1) — NOT NULL
- content — varchar(255)
- createdAt — timestamp — NOT NULL
- modifiedAt — timestamp — NOT NULL
- deletedAt — timestamp — NOT NULL
- userId (userId2) — bigint(20) — Foreign key → Users.user_Id — NOT NULL
- storeId (storeId2) — bigint(20) — Foreign key → Stores.storeId — NOT NULL
- orderId — bigint(20) — Foreign key → Orders.orderId — NOT NULL
Stores
- storeId — bigint(20) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- category — varchar(20) — NOT NULL
- address — varchar(255) — NOT NULL
- phone — varchar(20) — NOT NULL
- content — varchar(255)
- minDeliveryPrice — int(11) — NOT NULL
- deliveryTip — int(11) — NOT NULL
- rating — int — NOT NULL
- reviewCount — int(11) — NOT NULL
- openTime — varchar(255)
- closeTime — varchar(255)
- createdAt — timestamp — NOT NULL
- modifiedAt — timestamp — NOT NULL
- deletedAt — timestamp — NOT NULL
- user_Id (id) — bigint(20) — Foreign key → Users.user_Id — NOT NULL
Users
- user_Id (id) — bigint(20) — Primary key — NOT NULL
- password — varchar(255) — NOT NULL
- name — varchar(100) — NOT NULL
- phone — varchar(11) — NOT NULL
- email — varchar(100) — NOT NULL
- role — varchar(100) — NOT NULL
- address — varchar(255)
- createdAt — timestamp — NOT NULL
- modifiedAt — timestamp — NOT NULL
- deletedAt — timestamp — NOT NULL