project

Tables (12)

MENU_CATEGORY (메뉴_카테고리(menu_catagory))

  • Key (menu_category_idx) — number(4) — Primary key — NOT NULL — 카테고리IDX
  • Field (menu_category_name) — varchar2(40) — NOT NULL — 카테고리이름
  • Field (menu_category_in_date) — date — NOT NULL — 등록일

MENU_SET (세트메뉴(menu_set))

  • Key (set_idx) — number(6) — Primary key — NOT NULL — 세트메뉴IDX
  • Field (set_name) — varchar2(40) — NOT NULL — 세트이름
  • Field (set_img_path) — varchar(50) — NOT NULL — 세트이미지
  • Field (set_price) — number(8) — NOT NULL — 세트가격
  • Field (set_sale) — number(3) — NOT NULL — 할인율
  • Field (set_use_flag) — varchar2(1) — NOT NULL — 사용여부
  • Field (set_in_date) — date — NOT NULL — 등록일
  • Field (set_id_id) — varchar2(30) — NOT NULL — 등록인ID
  • Field (set_mod_date) — date — 수정일
  • Field (set_mod_id) — date — 수정인ID
  • Field (set_rep) — number — 대표메뉴

MENU_SET_LIST (세트메뉴 내역)

  • Key (list_idx) — number(6) — Primary key — NOT NULL — 목록IDX
  • Key (set_idx) — number(6) — Foreign key → MENU_SET.Key — NOT NULL — 세트메뉴IDX
  • Key (menu_idx) — number(6) — Foreign key → menu.Key — NOT NULL — 메뉴IDX
  • Field (list_in_date) — date — NOT NULL — 메뉴추가일
  • Field (list_in_id) — varchar2(30) — NOT NULL — 메뉴추가자

calculate_list (정산정보(calculate_list))

  • Key (calculate_idx) — number(8) — Primary key — NOT NULL — 정산IDX
  • Field (calculate_st_date) — date — NOT NULL — 정산오픈시간
  • Field (calculate_ed_date) — date — 정산마감시간

member_list (직원정보(member_list))

  • Key (member_idx) — number(4) — Primary key — NOT NULL — 직원번호
  • Key (member_id) — varchar2(20) — Primary key — NOT NULL — 직원ID
  • Key (store_idx) — number(4) — Foreign key → store_info.Key — NOT NULL — 매정번호
  • Field (mamber_name) — varchar2(30) — NOT NULL — 직원이름
  • Field (member_pass) — varchar2(100) — NOT NULL — 직원비밀번호
  • Field (member_use_flag) — varchar(1) — 직원사용유무

menu (메뉴(menu))

  • Key (menu_idx) — number(6) — Primary key — NOT NULL — 메뉴IDX
  • FKey (menu_category_idx) — number(4) — Foreign key → MENU_CATEGORY.Key — NOT NULL
  • Field (img_big_path) — varchar2(40) — NOT NULL — 이미지경로
  • Field (menu_name) — varchar2(60) — NOT NULL — 메뉴이름
  • Field (menu_price) — number(8) — NOT NULL — 메뉴가격
  • Field (menu_sale) — number(3) — NOT NULL — 할인율
  • Field (menu_in_date) — date — NOT NULL — 등록일
  • Field (menu_in_id) — varchar2(30) — NOT NULL — 등록인ID
  • Field (menu_mod_date) — date — 수정일
  • Field (menu_mod_id) — varchar2(30) — 수정인ID
  • Field (menu_use_flag) — varchar2(1) — 사용여부

menu_details (메뉴_세부정보(menu_details))

  • Key (detail_idx) — number(4) — Primary key — NOT NULL — 세부정보IDX
  • FKey (menu_idx) — number(4) — Foreign key → menu.Key — NOT NULL — 메뉴IDX
  • Field (detail_memo) — varchar2(100) — 제품설명
  • Field (detail_kcal) — number(4) — 칼로리
  • Field (detail_weight) — number(4) — 총중량

order_list (주문목록(order_list))

  • Key (order_idx) — number(8) — Primary key — NOT NULL — 주문번호
  • FKey (set_idx) — number(4) — Foreign key → MENU_SET.Key — 세트메뉴IDX
  • FKey (menu_idx) — number(4) — Foreign key → menu.Key — 메뉴IDX
  • Key (payment_idx) — number(8) — Foreign key → payment_list.Key — NOT NULL — 결제내역IDX
  • Field (order_state) — number(1) — NOT NULL — 주문상태
  • Field (order_price) — number(8) — NOT NULL — 주문가격
  • Field (order_type) — varchar2(1) — NOT NULL — 세트단품구분
  • Field (order_in_date) — date — NOT NULL — 주문시간
  • Field (order_mod_date) — date — 주문상태변경시간
  • Field (order_mod_id) — varchar(30) — 주문상태변경직원
  • Field (order_cnt) — number(3) — NOT NULL — 주문수량

order_list_total (주문목록 전체(order_list_total)(매일00시에 insert))

  • Key (order_idx) — number(12) — Primary key — NOT NULL — 주문번호
  • FKey (set_idx) — number(4) — Foreign key → MENU_SET.Key — 세트메뉴IDX
  • FKey (menu_idx) — number(4) — Foreign key → menu.Key — 메뉴IDX
  • Field (order_state) — number(1) — NOT NULL — 주문상태
  • Field (order_price) — number(8) — NOT NULL — 주문가격
  • Field (order_type) — varchar2(1) — NOT NULL — 세트단품구분
  • Field (order_in_date) — date — NOT NULL — 주문시간
  • Field (order_mod_date) — date — 주문상태변경시간
  • Field (order_mod_id) — varchar(30) — 주문상태변경직원

payment_list (결제내역(payment_list))

  • Key (payment_idx) — number(8) — Primary key — NOT NULL — 결제내역IDX
  • Field (payment_type) — number(4) — NOT NULL — 결제종류
  • Field (payment_cash_receipts) — varchar2(1) — 현금영수증여부
  • Field (payment_price) — number(8) — NOT NULL — 결제금액
  • Field (payment_date) — date — NOT NULL — 결제시간

payment_list_total (결제내역 총괄(payment_list)(매일 00시에 insert))

  • Key (payment_idx) — number(12) — Primary key — NOT NULL — 결제내역IDX
  • FKey (order_idx) — number(8) — Foreign key → order_list.Key — NOT NULL — 주문번호
  • Key (payment_idx2) — number(8) — Foreign key → order_list.Key — NOT NULL — 결제내역IDX
  • Field (payment_type) — number(4) — NOT NULL — 결제종류
  • Field (payment_cash_receipts) — varchar2(1) — 현금영수증여부
  • Field (payment_price) — number(8) — NOT NULL — 결제금액
  • Field (payment__date) — date — NOT NULL — 결제시간

store_info (매장정보(store_info))

  • Key (store_idx) — number(4) — Primary key — NOT NULL — 매정번호
  • Field (store_name) — varchar2(60) — NOT NULL — 매장상호
  • Field (store_business_number) — varchar2(30) — 사업자번호
  • Field (store_address) — varchar2(100) — 주소
  • Field (store_ceo) — varchar2(30) — NOT NULL — 대표자
  • Field (store_phone) — varchar2(20) — NOT NULL — 전화번호
  • Field (store_in_date) — date — NOT NULL — 등록일