Remove Unneeded Tables

[johnclary]

Keep these Tables

• [ ] admin_field_meta
• [ ] admin_objects_meta
• [ ] csr_signs_markings_activities
• [ ] csr_signs_issues
• [ ] csr_signs_flex_notes
• [ ] inventory_items << need to remove AMD items
• [ ] inventory_transactions
• [ ] street_names
• [ ] work_orders_markings
• [ ] work_orders_signs
• [ ] work_order_signs_locations
• [ ] work_orders_signs_asset_spec
• [ ] work_orders_signs_asset_spec_actual
• [ ] work_orders_signs_markings_attachments
• [ ] work_orders_signs_markings_comments
• [ ] work_orders_markings_specification
• [ ] work_orders_signs_markings_specification_actual
• [ ] work_orders_signs_markings_jobs
• [ ] work_orders_signs_markings_time_log

Remove These Tables

• [x] aps_button_requests
• [x] bcycle_kiosk_locations
• [x] cameras
• [x] construction_cost_estimate_report
• [x] construction_cost_items
• [x] cost_estimate_log
• [x] contract_solicitation_vendor
• [x] csr_flex_notes
• [x] damage_items
• [x] damage_report
• [x] device_status_log
• [x] dms
• [ ] fleet_vehicles
• [x] hazard_flashers
• [x] ip_switches
• [x] locations
• [x] locations_traffic_counts
• [x] performance_measures
• [x] performance_measures_fiscal
• [x] performance_measure_monthly
• [x] performance_measure_quarterly
• [x] performance_measure_annually
• [x] pole_attachments
• [x] quote_of_the_week
• [x] school_beacons
• [x] school_beacon_zones
• [x] signals
• [x] signal_id_generator
• [x] signals_cabinet
• [x] signals_cad
• [x] signals_corridors
• [x] signals_corridor_retiming
• [x] signals_corridor_retiming_special
• [x] signals_corridors_signals
• [x] signals_detectors
• [x] signals_detection_status_log
• [x] signal_file_attachments
• [x] signals_preventative_maintenance
• [x] signal_priority
• [x] signal_requests
• [x] signal_requests_phb_evals
• [x] signal_requests_traffic_eval
• [x] signal_requests_traffic_study
• [x] signal_requests_phb_study
• [x] street_segments
• [x] task_orders
• [x] tcp_tracking
• [x] tcp_tracking_submissions
• [x] technician_equipment
• [x] technician_equipment_log
• [x] tmc_activities
• [x] tmc_call_log
• [x] tmc_issues
• [x] traffic_counts
• [x] traffic_count_attachments
• [x] traffic_count_comments
• [x] travel_sensors
• [x] vision_zero_enforcement
• [x] vision_zero_enforcement_activities
• [x] vision_zero_enforcement_shifts
• [x] vision_zero_enforcement_actions
• [x] work_orders_signals
• [x] work_orders_signals_images
• [x] work_orders_signals_time_log
• [x] work_schedule_signals_engineers

[johnclary]

@dianamartin i put a dent in the delete list while watching the debates

[johnclary]

@dianamartin ok, it's done.

[dianamartin]

You deleted fleet_vehicles object and we needed that for the Time Log form. you got delete happy..haha. I re-imported it.