데이터베이스 구현
테이블 (3)
customer
- customer_id — INT
- cname — VARCHAR(50)
- city — VARCHAR(50)
- phone_number — VARCHAR(20)
delivery_drivers
- driver_id — INT
- dname — VARCHAR(20)
- delivery_areas — VARCHAR(30)
- vehicle_type — VARCHAR(50)
- delivery_cost — NUMBER(5,0)
orders
- order_id — INT
- customer_id — INT — NOT NULL
- driver_id — INT — NOT NULL
- order_date — DATE — NOT NULL
- total_price — DECIMAL(10, 0) — NOT NULL
- shipping_date — DATE
- delivery_status — VARCHAR(20)