Previous: project_type | Unanet Data Model | Next: project_type_exp_type_acct |
Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
1. | PK | project_type_key | decimal(15) | project_type | fk_project_type_account1 | |
2. | PK | category | tinyint | |||
3. | account_key | decimal(15) | account | fk_project_type_account2 |
Column | References | Foreign Key Name | |
Table | Column | ||
account_key | account | account_key | fk_project_type_account2 |
project_type_key | project_type | project_type_key | fk_project_type_account1 |
Name | Definition |
cc_project_type_account_cat | ([category]>=(1) AND [category]<=(99)) |
Index Name | Unique | Column Name | Asc Or Desc |
pk_project_type_account | true | project_type_key | Asc |
category | |||
idx_project_type_account1 | false | account_key | Asc |