STATUSES
| Documentation | Projects database |
| Name | STATUSES |
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | STATUS_ID | NUMBER | ||||||
| 2 | NAME | VARCHAR2(100 BYTE) | ||||||
| 3 | IS_OPEN | CHAR(1 BYTE) | Default: 'Y' | |||||
|
Default:
'Y' |
||||||||
| 4 | CREATED_DATE | DATE | Default: SYSDATE | |||||
|
Default:
SYSDATE |
||||||||
| 5 | CREATED_BY | NUMBER | ||||||
| 6 | MODIFIED_DATE | DATE | Default: SYSDATE | |||||
|
Default:
SYSDATE |
||||||||
| 7 | MODIFIED_BY | NUMBER | ||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| ACTIVITIES | STATUSES | ACTIVITIES.STATUS_ID = STATUSES.STATUS_ID | FK_ACTIVITIES_STATUS | |
|
ACTIVITIES.STATUS_ID = STATUSES.STATUS_ID Name: FK_ACTIVITIES_STATUS |
||||
| PROJECTS | STATUSES | PROJECTS.STATUS_ID = STATUSES.STATUS_ID | FK_PROJECTS_STATUS | |
|
PROJECTS.STATUS_ID = STATUSES.STATUS_ID Name: FK_PROJECTS_STATUS |
||||
| WBS | STATUSES | WBS.STATUS_ID = STATUSES.STATUS_ID | FK_WBS_STATUS | |
|
WBS.STATUS_ID = STATUSES.STATUS_ID Name: FK_WBS_STATUS |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| STATUSES_PK | STATUS_ID |
Used by
| Name |
|---|
|
STATUSES
|
Exported: 2019-02-04 22:52, Last imported: 2019-02-03 01:50