PROJECT_ROLES
| Documentation | Projects database |
| Name | PROJECT_ROLES |
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | PROJECT_ROLE_ID | NUMBER | ||||||
| 2 | PROJECT_ID | NUMBER | PROJECTS | |||||
| References: PROJECTS | ||||||||
| 3 | PERSON_ID | NUMBER | PEOPLE | |||||
| References: PEOPLE | ||||||||
| 4 | ROLE_TYPE_ID | NUMBER | ||||||
| 5 | NAME | VARCHAR2(50 BYTE) | ||||||
| 6 | VALID_FROM | DATE | ||||||
| 7 | VALID_TO | DATE | ||||||
| 8 | CREATED_DATE | DATE | Default: SYSDATE | |||||
|
Default:
SYSDATE |
||||||||
| 9 | CREATED_BY | NUMBER | ||||||
| 10 | MODIFIED_DATE | DATE | Default: SYSDATE | |||||
|
Default:
SYSDATE |
||||||||
| 11 | MODIFIED_BY | NUMBER | ||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| PROJECT_ROLES | PEOPLE | PROJECT_ROLES.PERSON_ID = PEOPLE.PERSON_ID | FK_PROJECT_ROLES_PERSON | |
|
PROJECT_ROLES.PERSON_ID = PEOPLE.PERSON_ID Name: FK_PROJECT_ROLES_PERSON |
||||
| PROJECT_ROLES | PROJECTS | PROJECT_ROLES.PROJECT_ID = PROJECTS.PROJECT_ID | FK_PROJECT_ROLES_PROJECT | |
|
PROJECT_ROLES.PROJECT_ID = PROJECTS.PROJECT_ID Name: FK_PROJECT_ROLES_PROJECT |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PROJECT_ROLES_PK | PROJECT_ROLE_ID |
Used by
| Name |
|---|
|
PROJECT_ROLES
|
Exported: 2019-02-04 22:52, Last imported: 2019-02-03 01:50