3군 2미 프로젝트
테이블 (3)
Contents
- Goods_Name (goods_name) — VARCHAR(50)
- Goods_Price (goods_price) — INTEGER
Customer_Bill
- Order_ID (order_id) — INTEGER — 기본 키 — NOT NULL
- Order_Time (order_time) — DATETIME
- Goods_Price (goods_price) — INTEGER
- Goods_Name (goods_name) — VARCHAR(50)
- Goods_Count (goods_count) — INTEGER
- Payment (payment) — VARCHAR(50)
- Payment_Method (payment_method) — BOOLEAN
Order_Bill
- Goods_Name (goods_name) — VARCHAR(50) — 기본 키 — NOT NULL
- Order_ID (order_id) — INTEGER — 외래 키 → Customer_Bill.Order_ID — NOT NULL
- Goods_Count (goods_count) — INTEGER
- Order_Time (order_time) — DATETIME