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 — 결제코드