Table: dbo.Vendor_Independent_Contractor_Reported
The table used to store when a vendor has been reported to be an independent contractor.
Columns
Name | Type | Constraints | Description
vendor_independent_contractor_reported_KEY | int (4) | NOT NULL | Primary key for this table.
vendor_KEY | int (4) | NOT NULL | The foreign key into the Vendor table for the vendor being reported as an independent contractor.
date_reported | smalldatetime (4) | NOT NULL | The date the vendor was reported as an independent contractor for the year.
contract_year | int (4) | NOT NULL | The year the contract is for. This may differ from the year the contract was reported.

Primary key
Name | Columns | Description
PK_Vendor_Independent_Contractor_Reported | vendor_independent_contractor_reported_KEY |
Unique constraints
Name | Columns | Description
UK_Vendor_Independent_Contractor_Reported$contract_year$vendor_KEY | contract_year, vendor_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Vendor_Independent_Contractor_Reported__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) |