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 — 주문코드;