PK category
description
requirement
PK barcode
FK1 trip_id
FK2 pickup_customer_ref
FK3 delivery_customer_ref
FK4 category
weight
PK reference
company_name
address
town
post_code
telephone
contact_fname
contact_sname
contact_email
PK cam_id
first_name
last_name
mobile
email
start_date
end_date
PK customer_cam_id
FK customer_ref
FK cam_id
PK vehicle_id
registration
FK1 model
body
year
PK trip_id
departure_date
return_date
FK1 vehicle_id
FK2 employee_no
PK enquiry_id
FK initial_cam_id
created_at
status
subject
closed_at
PK entry_id
FK enquiry_id
entry_datetime
author_type
customer_ref
cam_id
notes
PK model
make
kerb
gvw
PK employee_no
ni_no
hazardous_goods
by vonni614
