order

Tables (6)

tbl_category

  • category_code (카테고리코드) — NUMBER — Primary key — NOT NULL — 카테고리코드;
  • category_name (카테고리명) — VARCHAR2(30) — NOT NULL
  • ref_category_code (상위카테고리코드) — NUMBER — Foreign key → tbl_category.category_code

tbl_menu

  • menu_code (메뉴코드) — NUMBER — Primary key — NOT NULL — 메뉴코드;
  • menu_name (메뉴명) — VARCHAR2(30) — NOT NULL
  • menu_price (메뉴가격) — NUMBER — NOT NULL
  • category_code (카테고리코드) — NUMBER — Foreign key → tbl_category.category_code — NOT NULL
  • orderable_status (주문가능상태) — CHAR(1) — NOT NULL

tbl_order

  • order_code (주문코드) — NUMBER — Primary key — NOT NULL — 주문코드;
  • order_date (주문일자) — VARCHAR2(8) — NOT NULL
  • order_time (주문시간) — VARCHAR2(8) — NOT NULL
  • total_order_price (총주문금액) — NUMBER — NOT NULL

tbl_order_menu

  • order_code (주문코드) — NUMBER — Foreign key → tbl_order.order_code — NOT NULL — 주문코드;
  • menu_code (메뉴코드) — NUMBER — Foreign key → tbl_menu.menu_code — NOT NULL
  • order_amount (주문수량) — NUMBER — NOT NULL

tbl_payment

  • payment_code (결제코드) — NUMBER — Primary key — NOT NULL — 결제코드;
  • payment_date (결제일) — VARCHAR2(8) — NOT NULL
  • ㄱ (결제시간) — VARCHAR2(8) — NOT NULL
  • payment_price (결제금액) — NUMBER — NOT NULL
  • payment_type (결제구분) — VARCHAR2(6) — NOT NULL

tbl_payment_order

  • payment_code (결제코드2) — NUMBER — Foreign key → tbl_payment.payment_code — NOT NULL — 결제코드;
  • order_code (주문코드2) — NUMBER — Foreign key → tbl_order.order_code — NOT NULL — 주문코드;