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)