DICTIONARY
| Documentation | Projects database |
| Name | DICTIONARY |
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | DICT_VAL_ID | NUMBER | ||||||
| 2 | DICT | VARCHAR2(50 BYTE) | ||||||
| 3 | LABEL | VARCHAR2(100 BYTE) | ||||||
| 4 | VALID_FROM | DATE | ||||||
| 5 | VALID_TO | DATE | ||||||
| 6 | CREATED_DATE | DATE | Default: SYSDATE | |||||
|
Default:
SYSDATE |
||||||||
| 7 | CREATED_BY | NUMBER | ||||||
| 8 | MODIFIED_DATE | DATE | Default: SYSDATE | |||||
|
Default:
SYSDATE |
||||||||
| 9 | MODIFIED_BY | NUMBER | ||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| ACTIVITIES | DICTIONARY | ACTIVITIES.ACTIVITY_TYPE_ID = DICTIONARY.DICT_VAL_ID | FK_ACTIVITIES_TYPE | |
|
ACTIVITIES.ACTIVITY_TYPE_ID = DICTIONARY.DICT_VAL_ID Name: FK_ACTIVITIES_TYPE |
||||
| PROGRAMS | DICTIONARY | PROGRAMS.PROGRAM_TYPE_ID = DICTIONARY.DICT_VAL_ID | FK_PROGRAMS_TYPE | |
|
PROGRAMS.PROGRAM_TYPE_ID = DICTIONARY.DICT_VAL_ID Name: FK_PROGRAMS_TYPE |
||||
| PROJECTS | DICTIONARY | PROJECTS.TYPE_ID = DICTIONARY.DICT_VAL_ID | FK_PROJECTS_TYPE | |
|
PROJECTS.TYPE_ID = DICTIONARY.DICT_VAL_ID Name: FK_PROJECTS_TYPE |
||||
| 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 |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_DICTIONARY | DICT_VAL_ID |
Used by
| Name |
|---|
|
DICTIONARY
|
Exported: 2019-02-04 22:52, Last imported: 2019-02-03 01:50