| 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 |