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 — 등록일