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