Computer network 1
Tables (8)
Francchi (Untitled3)
- francchi id — Not Null — Primary key — NOT NULL
- menu id — Not Null
- addr
- phone number
- search tag
- Full-checker
- type — NOT NULL
Menu (Untitled4)
- menu id — Not Null — Primary key — NOT NULL
- francchi id — Not Null — Foreign key → Francchi.francchi id — NOT NULL
- menu img (menu imgi)
- product id (products) — Not Null
Order (Untitled2)
- order id — Not Null — Primary key — NOT NULL
- user id — Not Null — Foreign key → User.user id
- francchi id — Not Null — Foreign key → Francchi.francchi id — NOT NULL
- review id
- order products id
- order status
Product (Untitled5)
- product id — Not Null — Primary key — NOT NULL
- menu id — Not Null — Foreign key → Menu.menu id — NOT NULL
- francchi id — Not Null — Foreign key → Menu.francchi id — NOT NULL
- product img
- price — Not Null
- Regular Option
Regular Option (Untitled8)
- product id — Not Null — Foreign key → Product.product id — NOT NULL
- menu id — Not Null — Foreign key → Product.menu id — NOT NULL
- francchi id — Not Null — Foreign key → Product.francchi id — NOT NULL
- Option (Option 1)
Review (Untitled6)
- review idr (review id) — Not Null — Primary key — NOT NULL
- order id — Not Null — Foreign key → Order.order id — NOT NULL
- user id
- francchi id
- 별점 - 맛
- 별점 - 분위기
- 별점 - 만족도
User (Untitled)
- user id — Not Null — Primary key
- phone number
- Field
order products (Untitled7)
- order products id — Primary key — NOT NULL
- order id — Not Null — Foreign key → Order.order id — NOT NULL
- product id
- product number
- Regular Options
- Additional Option