# Contractor | Work Orders

**Problem**: Signs and Markings needed a way to track contractor work orders and wanted to track it in the same system where they track their existing Signs and Markings work orders.&#x20;

**Solution**: Add an area to the SMB Tracker for Contractor tracking

## Build Information

#### New! Object tables created

* `contract_vendor` (just Contract Vendor information)
* `contract_bid_items` (Items that are on the contract with different unit prices depending on contractor)
* `contractor_inspections` (table that tracks the inspection status information)
* `contractor_materials_log` (table that tracks what items "materials" were used in the assigned project)
* `contractor_work_order` (table that has all pertinent work order information)

#### Existing tables used

* `work_orders_signs_markings_attachments` (for inspection photo images)
* `work_orders_signs_markings_time_logs` (bc Kati A. was already pulling date from Work History page and the existing date resided in this object table)

**Connections**

* **street\_names** (for contractor work order object - Street, From/To Street in order to not have typos on location names.
* **accounts** (audit fields: Created Date/By, Modified Date/By)

[SMB Contractor Status Matrix](https://drive.google.com/file/d/1OTWQ8NzBe0_7QojCVpS9YN8qZ-0o01kA/view)

![](https://3087753818-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LzNSSXajDFpzOv2IhIv%2F-MLEwyNyp4X_BtCz30o9%2F-MLEx0mXDolCTwzElGG2%2Fimage.png?alt=media\&token=8a5f97cf-722c-477c-9496-71789f06c367)

![](https://3087753818-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LzNSSXajDFpzOv2IhIv%2F-MLEwyNyp4X_BtCz30o9%2F-MLEx4PAYcisD6OEx5Oq%2Fimage.png?alt=media\&token=53de0d0d-3d51-4c39-b103-43053e7651c4)

