Previous: project_post_history | Unanet Data Model | Next: project_status |
Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
1. | PK | project_key | decimal(15) | project | fk_project_restrict_access1 | |
2. | PK | role_key | decimal(15) | role | fk_project_restrict_access2 |
Column | References | Foreign Key Name | |
Table | Column | ||
project_key | project | project_key | fk_project_restrict_access1 |
role_key | role | role_key | fk_project_restrict_access2 |
Name | Definition |
cc_project_restrict_role_key | ([role_key]=(53) OR [role_key]=(48) OR [role_key]=(44) OR [role_key]=(20) OR [role_key]=(19) OR [role_key]=(18) OR [role_key]=(17) OR [role_key]=(15) OR [role_key]=(14) OR [role_key]=(3)) |
Index Name | Unique | Column Name | Asc Or Desc |
pk_project_restrict_access | true | project_key | Asc |
role_key |
View Name |
project_open_access_view |