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