Order Type (Tablet, Vehicle Mount, Accessories, Services) order_type_id references order_types Tablet Request Type tablet_request_type_id references tablet_request_types Tablet Additional Items tablet_additional_items list of items tablet_request_additional_items (request_id, item_id) Tablet Scheduling scheduling table: request_id day_of_week_id Tablet Replacement Reason tablet_replacement_reason_id references tablet_replacement_reasons Tablet Replacement User Details tablet_replacement_user_report request_id service_number name position report security_paperwork Tablet Replacement Police police_event_number Tablet Replacement Mount Damaged mount_damaged Tablet Replacement Mount Damage Details mount_damaged (bit -- if stolen, was the mount damaged in the process?) Tablet Replacement Vehicle Details replacement_vehicle_details_id references tablet_vehicle_details Tablet Replacement Scheduling will link to a scheduling table Tablet Fault Details tablet_fault_details (text) Services Services Type service_type_id references tablet_service_types Services Documents details text Services Training details text Services Suggestions details text Services Issues details text Mount Request Reason mount_request_reason_id references tablet_mount_request_reasons Mount Request Details details text (either fault or damage details) Mount Old Vehicle Details mount_old_vehicle_details_id reference vehicle_details Mount New Vehicle Details mount_new_vehicle_details_id reference vehicle_details Mount Scheduling scheduling Accessories tablet_tablet_accessories table: request_id tablet_serial_number accessory_id references tablet_accessories Approval approver_service_number approver_is_acting