Table: dbo.Vendor_Independent_Contractor_Reported
The table used to store when a vendor has been reported to be an independent contractor.
Columns
NameTypeConstraintsDescription
vendor_independent_contractor_reported_KEYint (4)NOT NULLPrimary key for this table.
vendor_KEYint (4)NOT NULLThe foreign key into the Vendor table for the vendor being reported as an independent contractor.
date_reportedsmalldatetime (4)NOT NULLThe date the vendor was reported as an independent contractor for the year.
contract_yearint (4)NOT NULLThe year the contract is for. This may differ from the year the contract was reported.
Primary key
NameColumnsDescription
PK_Vendor_Independent_Contractor_Reportedvendor_independent_contractor_reported_KEY
Unique constraints
NameColumnsDescription
UK_Vendor_Independent_Contractor_Reported$contract_year$vendor_KEYcontract_year, vendor_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Vendor_Independent_Contractor_Reported__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)

Schema diagram