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