Table: cost_struct

Previous: cost_report_element

Unanet Data Model

Next: cost_struct_labor

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	cost_struct_key	decimal(15)
2.		cost_structure	varchar(128)
3.		description	varchar(2000)
4.		active	char(1)	('Y')
5.		cost_pool_group_key	decimal(15)		cost_pool_group	fk_cost_struct1

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
cost_pool_group_key	cost_pool_group	cost_pool_group_key	fk_cost_struct1

Referenced from

Table	Column	Foreign Key Name
cost_struct_labor	cost_struct_key	fk_cost_struct_labor1
cost_struct_odc	cost_struct_key	fk_cost_struct_odc1
cost_struct_pool	cost_struct_key	fk_cost_struct_pool1
project	cost_struct_key	fk_project8

Check Constraints

Name	Definition
cc_cs_active	([active]='N' OR [active]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_cost_struct	true	cost_struct_key	Asc
idx_cost_struct1	true	cost_structure	Asc
idx_cost_struct2	false	cost_pool_group_key	Asc