JAVA

Tables (4)

C_member (Untitled3)

  • 폰번호 (p_num) — varchar — Primary key — NOT NULL
  • 스탬프 (stamp) — number

C_menu (Untitled)

  • 메뉴이름 (m_name) — Varchar — Primary key — NOT NULL
  • 가격 (price) — number
  • 태그 (tag) — Varchar
  • 타입 (type) — Varchar

C_order (Untitled2)

  • 메뉴이름 (m_name) — Varchar — Foreign key → C_menu.메뉴이름 — NOT NULL
  • 날짜 (indate2) — Date — Foreign key → Sales.날짜 — NOT NULL
  • 가격 (price) — number
  • 수량 (amount) — number
  • 총가격 (t_pirce) — number
  • 주문번호 (order_num) — number
  • 날짜 (indate) — timestamp

Sales (Untitled4)

  • 날짜 (indate) — Date — Primary key — NOT NULL
  • 매출 (t_price) — number