20250522-menudb-postgres

Tables (6)

tbl_category

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

tbl_menu

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

tbl_order

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

tbl_order_menu

  • order_code — INT — Foreign key → tbl_order.order_code — NOT NULL — 주문코드
  • menu_code — INT — Foreign key → tbl_menu.menu_code — NOT NULL — 메뉴코드
  • menu_code (menu_code2) — SERIAL — Foreign key → tbl_menu.menu_code — 메뉴코드
  • category_name (category_name2) — VARCHAR(30) — Foreign key — NOT NULL — 카테고리명
  • category_code (category_code2) — SERIAL — Foreign key
  • order_code (order_code2) — SERIAL — Foreign key → tbl_order.order_code — 주문코드
  • order_amount — INT — NOT NULL — 주문수량

tbl_payment

  • payment_code — SERIAL — 결제코드
  • payment_date — VARCHAR(8) — NOT NULL — 결제일
  • payment_time — VARCHAR(8) — NOT NULL — 결제시간
  • payment_price — INT — NOT NULL — 결제금액
  • payment_type — VARCHAR(6) — NOT NULL — 결제구분

tbl_payment_order

  • order_code — INT — Foreign key → tbl_order.order_code — NOT NULL — 주문코드
  • payment_code — INT — Foreign key → tbl_payment.payment_code — NOT NULL — 결제코드
  • order_code (order_code2) — SERIAL — Foreign key → tbl_order.order_code — 주문코드