order
Tables (3)
customer (고객)
logistics company (발주)
- product no (상품번호) — int — Primary key — NOT NULL
- product count (상품수량) — int
- product_name (상품명) — nvarchar(50)
- product_price (상품가격) — int
restaurant (레스토랑)
- table_no (Key) — int — Primary key — NOT NULL
- product no (상품번호) — int — Foreign key → logistics company.product no — NOT NULL
- pasta (파스타) — nvarchar(30)
- pizza (피자) — nvarchar(30)
- rissoto (리조또) — nvarchar(30)
- steak (스테이크) — nvarchar(30)
- beverage (음료) — nvarchar(30)
- water (물) — nvarchar(20)