UnitTest
Tables (7)
Untitled (Category)
- Key (CategoryID) — INT — Primary key — NOT NULL — 카테고리코드
- Field (CategoryName) — VARCHAR(30) — NOT NULL — 카테고리명
Untitled (Menu)
- Key (MenuID) — INT — Primary key — NOT NULL — 메뉴코드
- Field (MenuName) — VARCHAR(30) — NOT NULL — 메뉴명
- Field (MenuPrice) — INT — NOT NULL — 메뉴가격
- Field (OrderableStatus) — CHAR(1) — NOT NULL — 주문가능상태
- Key (CategoryID) — INT — Foreign key → Untitled.Key — NOT NULL — 카테고리코드
Untitled (DineOrder)
- Key (OrderID) — INT — Primary key — NOT NULL — 주문코드
- Field (OrderDate) — VARCHAR(8) — NOT NULL — 주문일자
- Field (OrderTime) — VARCHAR(8) — NOT NULL — 주문시간
- Field (OrderTotal) — INT — NOT NULL — 총주문금액
Untitled (OrderMenu)
- Key (OrderID) — INT — Foreign key → Untitled.Key — NOT NULL — 주문코드
- Key (MenuID) — INT — Foreign key → Untitled.Key — NOT NULL — 메뉴코드
- Field (Quantity) — INT — NOT NULL
Untitled (Payment)
- Key (PaymentID) — INT — Primary key — NOT NULL — 결제코드
- Field (PaymentDate) — VARCHAR(30) — NOT NULL — 결제일자
- Field (PaymentTime) — VARCHAR(30) — NOT NULL — 결제시간
- Field (PaymentTotal) — INT — NOT NULL — 총결제금액
- Key (PaymentTypeID) — INT — Foreign key → Untitled.Key — NOT NULL — 결제방식코드
Untitled (PaymentType)
- Key (PaymentTypeID) — INT — Primary key — NOT NULL — 결제수단코드
- Field (PaymentTypeName) — VARCHAR(30) — NOT NULL — 결제수단
Untitled (OrderPayment)
- Key (OrderID) — INT — Foreign key → Untitled.Key — NOT NULL — 주문코드
- Key (PaymentID) — INT — Foreign key → Untitled.Key — NOT NULL — 결제코드