erd1.0
테이블 (8)
category
- category_number — number(2)
- category_name — VARCHAR(40)
manager
- manager_id — VARCHAR2(16)
- manager_password — VARCHAR2(255)
membership
- member_phonenumber — varchar2(20)
- member_point — number(5)
- member_join — date
menu
- menu_number — number(20)
- menu_name — VARCHAR(40)
- price — number(5)
- category_number — number(2)
menu_option
- option_number — number(20)
- option_name — VARCHAR2(40)
- category_number — number(2)
- option_price — NUMBER(5)
sales
- sales_number — number(20)
- member_phonenumber — varchar2(20)
- saleDate — DATE
sales_management
- sales_number — number(20)
- menu_number — number(20)
- option_number — number(20)
- product_qty — number(3)
- total_price — number(10)
결제 (Untitled)
- 결제번호 (Field2)
- 결제수단 (Field)
- 금액 (Field3)
- 포인트 (Field4)
- Field5