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