Table: labor_category

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK labor_category_key decimal(15)      
2.   labor_category varchar(50)      
3.   description varchar(2000)      
4.   account_number varchar(50)      
5.   active char(1) ('Y')    
Referenced from
Table Column Foreign Key Name
labor_category_account labor_category_key fk_labor_category_account1
labor_category_assignment labor_category_key fk_labor_category_assignment1
labor_category_invc_fltr labor_category_key fk_labor_category_invc_fltr2
labor_category_rate labor_category_key fk_labor_category_rate1
person labor_category_key fk_person9
person_time_data labor_category_key fk_person_time_data8
person_time_data_history labor_category_key fk_person_time_data_history7
planned_time labor_category_key fk_planned_time4
project_assignment labor_category_key fk_project_assignment5
res_req_labor_category labor_category_key fk_res_req_labor_category2
task_assignment labor_category_key fk_task_assignment5
Check Constraints
Name Definition
cc_lc_active ([active]='N' OR [active]='Y')
Indices
Index Name Unique Column Name Asc Or Desc
pk_labor_category true labor_category_key Asc
idx_labor_category1 true labor_category Asc
Dependent Views
View Name
assignment_view