TESTTETST

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
  • payment_time — VARCHAR2(8) — NOT NULL
  • payment_price — NUMBER — NOT NULL
  • payment_type — VARCHAR2(6) — NOT NULL

tbl_payment_order

  • payment_code — NUMBER — Primary key — NOT NULL
  • order_code — NUMBER — Primary key — NOT NULL — 주문코드;