dfagsdfgsdfg

Tables (5)

Department (본부)

  • depart_id — Primary key — NOT NULL
  • depart_name

DispatchRecord (배차정보)

  • cre_date — Primary key — NOT NULL
  • master_id — Foreign key → Vehicle.master_id — NOT NULL
  • depart_id — Foreign key → Department.depart_id — NOT NULL
  • employee_id (user_id) — Foreign key → Employee.employee_no — NOT NULL
  • dispatch_type
  • total_distance
  • total_empty_move_dist
  • total_trip_cnt
  • order_list (order_no) — Foreign key → Order.order_no — NOT NULL — [ { order_no: 주문번호 order_cre_date: 주문생성일시 user_no: 사원번호 trip_distance: 노선거리 empty_move_dist: 공차거리 remarks: 특이사항, 비고 } ]

Employee (사용자)

  • employee_no (user_no) — Primary key — NOT NULL
  • depart_id — Foreign key → Department.depart_id — NOT NULL
  • user_name
  • user_phone
  • authority

Order (주문)

  • order_no — Primary key — NOT NULL
  • cre_date (cre_date2) — Primary key — NOT NULL
  • employee_no (user_no) — Foreign key → Employee.employee_no — NOT NULL
  • veh_type
  • veh_ton
  • load_dist_code
  • load_dist
  • uload_dist_code
  • uload_dist
  • branch_office
  • load_date
  • uload_date
  • load_loc_code
  • load_loc
  • load_address
  • uload_loc_code
  • uload_loc
  • uload_address
  • load_avail_ton
  • uload_avail_ton
  • cargo_type
  • cust_name
  • cust_code
  • tariff
  • weight
  • palette
  • status
  • remarks
  • load_admin (담당자)
  • load_admin_phone (담당자연락처)

Vehicle (차량)

  • master_id — Primary key — NOT NULL
  • depart_id — Foreign key → Department.depart_id — NOT NULL
  • veh_type
  • veh_ton
  • load_loc_code
  • load_loc
  • load_dist_code
  • load_dist
  • veh_no
  • driver_name
  • driver_phone
  • veh_orgin
  • mdm_no
  • license_no
  • usage