outsourcing
Tables (5)
Menu (menus)
- Menu Id (menu_id) — bigint — Primary key — NOT NULL
- Name (menu_name)
- Price (menu_price)
- Type (menu_type)
- SoldOut (sold_out) — boolean
- Status (status) — boolean
- CreatedAt (created_at)
- ModifiedAt (modified_at)
- Store Id (store_id) — bigint — Foreign key → Store.Store Id — NOT NULL
Order (orders)
- Order Id (order_id) — bigint — Primary key — NOT NULL
- Process (process)
- TotalPrice (total_price) — int
- CreatedAt (created_at)
- ModifiedAt (modified_at)
- User Id (user_id) — bigint — Foreign key → User.User Id — NOT NULL
- Store Id (store_id) — bigint — Foreign key → Store.Store Id — NOT NULL
Review (reviews)
- Review Id (review_id) — bigint — Primary key — NOT NULL
- Username (username) — varchar(20)
- Content (content) — Text
- Star (star) — int
- Order Id (order_id) — bigint — Foreign key → Order.Order Id — NOT NULL
- Store Id (store_id) — bigint — Foreign key → Store.Store Id — NOT NULL
Store (stores)
- Store Id (store_id) — bigint — Primary key — NOT NULL
- Name (store_name)
- OpenTime (open_time)
- CloseTime (close_time)
- MinPrice (min_price)
- Status (status) — boolean
- CreatedAt (created_at)
- ModifiedAt (modified_at)
- User Id (user_id) — bigint — Foreign key → User.User Id — NOT NULL
User (users)
- User Id (user_id) — bigint — Primary key — NOT NULL
- Email (email) — varchar
- Password (password) — varchar(20)
- Username (username) — varchar(20)
- Authority (authority)
- Status (status) — boolean
- Address (address) — varchar(50)
- Telephone (telephone) — varchar(20)