WBS
| Documentation | Projects database |
| Name | WBS |
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | WBS_ID | NUMBER | ||||||
| 2 | WBS_NO | VARCHAR2(50 CHAR) | ||||||
| 3 | PARENT_WBS_ID | NUMBER | WBS | |||||
| References: WBS | ||||||||
| 4 | NAME | VARCHAR2(150 CHAR) | ||||||
| 5 | PROJECT_ID | NUMBER | PROJECTS | |||||
| References: PROJECTS | ||||||||
| 6 | WBS_TYPE_ID | NUMBER | DICTIONARY | |||||
| References: DICTIONARY | ||||||||
| 7 | STATUS_ID | NUMBER | STATUSES | |||||
| References: STATUSES | ||||||||
| 8 | DESCRIPTION | VARCHAR2(4000 CHAR) | ||||||
| 9 | DELIVERABLES | VARCHAR2(4000 CHAR) | ||||||
| 10 | EXPECTED_BEGIN | DATE | ||||||
| 11 | EXPECTED_END | DATE | ||||||
| 12 | CREATED_DATE | DATE | Default: SYSDATE | |||||
|
Default:
SYSDATE |
||||||||
| 13 | CREATED_BY | NUMBER | ||||||
| 14 | MODIFIED_DATE | DATE | Default: SYSDATE | |||||
|
Default:
SYSDATE |
||||||||
| 15 | MODIFIED_BY | NUMBER | ||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| WBS | DICTIONARY | WBS.WBS_TYPE_ID = DICTIONARY.DICT_VAL_ID | FK_WBS_TYPE | |
|
WBS.WBS_TYPE_ID = DICTIONARY.DICT_VAL_ID Name: FK_WBS_TYPE |
||||
| WBS | PROJECTS | WBS.PROJECT_ID = PROJECTS.PROJECT_ID | FK_WBS_PROJECT | |
|
WBS.PROJECT_ID = PROJECTS.PROJECT_ID Name: FK_WBS_PROJECT |
||||
| WBS | STATUSES | WBS.STATUS_ID = STATUSES.STATUS_ID | FK_WBS_STATUS | |
|
WBS.STATUS_ID = STATUSES.STATUS_ID Name: FK_WBS_STATUS |
||||
| WBS | WBS | WBS.PARENT_WBS_ID = WBS.WBS_ID | FK_WBS | |
|
WBS.PARENT_WBS_ID = WBS.WBS_ID Name: FK_WBS |
||||
| WBS | WBS | WBS.PARENT_WBS_ID = WBS.WBS_ID | FK_WBS | |
|
WBS.PARENT_WBS_ID = WBS.WBS_ID Name: FK_WBS |
||||
| ACTIVITIES | WBS | ACTIVITIES.WBS_ID = WBS.WBS_ID | fk_WBS_ACTIVITIES | |
|
ACTIVITIES.WBS_ID = WBS.WBS_ID Name: fk_WBS_ACTIVITIES |
||||
| CST_PROJECT_COSTS | WBS | CST_PROJECT_COSTS.WBS_ID = WBS.WBS_ID | FK_CST_PROJECT_COSTS_WBS | |
|
CST_PROJECT_COSTS.WBS_ID = WBS.WBS_ID Name: FK_CST_PROJECT_COSTS_WBS |
||||
| CST_PROJECT_TIME_LOG | WBS | CST_PROJECT_TIME_LOG.WBS_ID = WBS.WBS_ID | FK_CST_PROJECT_TIME_WBS | |
|
CST_PROJECT_TIME_LOG.WBS_ID = WBS.WBS_ID Name: FK_CST_PROJECT_TIME_WBS |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_WBS | WBS_ID |
Uses
| Name |
|---|
|
WBS
|
|
WBS
|
Used by
| Name |
|---|
|
WBS
|
|
WBS
|
Exported: 2019-02-04 22:52, Last imported: 2019-02-03 01:50