Table: cost_struct_labor

Previous: cost_struct

Unanet Data Model

Next: cost_struct_odc

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	cost_struct_labor_key	decimal(15)
2.		cost_struct_key	decimal(15)		cost_struct	fk_cost_struct_labor1
3.		cost_element_key	decimal(15)		cost_element	fk_cost_struct_labor2

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
cost_element_key	cost_element	cost_element_key	fk_cost_struct_labor2
cost_struct_key	cost_struct	cost_struct_key	fk_cost_struct_labor1

Referenced from

Table	Column	Foreign Key Name
person_rate	cost_struct_labor_key	fk_person_rate3
person_time_data	cost_struct_labor_key	fk_person_time_data9
planned_time	cost_struct_labor_key	fk_planned_time5
project_assignment	cost_struct_labor_key	fk_project_assignment6
task_assignment	cost_struct_labor_key	fk_task_assignment7

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_cost_struct_labor	true	cost_struct_labor_key	Asc
idx_cost_struct_labor1	true	cost_struct_key	Asc
		cost_element_key
idx_cost_struct_labor2	false	cost_element_key	Asc