Table: dbo.Worker_Compensation_Limit
Columns
NameTypeConstraintsDescription
worker_compensation_limit_KEYint (4)NOT NULLunique key
worker_compensation_class_code_detail_KEYint (4)NOT NULLworker comp class code and state this limit is for
worker_compensation_limit_detail_KEYint (4)NOT NULLlimit for this worker comp class code and state
Primary key
NameColumnsDescription
PK_Worker_Compensation_Limitworker_compensation_limit_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Worker_Compensation_Limit__Worker_Compensation_Class_Code_Detail__worker_compensation_class_code_detail_KEYworker_compensation_class_code_detail_KEYWorker_Compensation_Class_Code_Detail (worker_compensation_class_code_detail_KEY)
FK_Worker_Compensation_Limit__Worker_Compensation_Limit_Detail__worker_compensation_limit_detail_KEYworker_compensation_limit_detail_KEYWorker_Compensation_Limit_Detail (worker_compensation_limit_detail_KEY)

Schema diagram