데이터베이스 구현

테이블 (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)