PROGRAMS
| Documentation | Projects database |
| Name | PROGRAMS |
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | PROGRAM_ID | NUMBER | ||||||
| 2 | NAME | VARCHAR2(50 BYTE) | ||||||
| 3 | DESCRIPTION | VARCHAR2(250 BYTE) | ||||||
| 4 | DEPARTMENT_ID | NUMBER | DEPARTMENTS | |||||
| References: DEPARTMENTS | ||||||||
| 5 | MANAGER_ID | NUMBER | PEOPLE | |||||
| References: PEOPLE | ||||||||
| 6 | STATUS | VARCHAR2(5 BYTE) | ||||||
| 7 | PROGRAM_TYPE_ID | NUMBER | DICTIONARY | |||||
| References: DICTIONARY | ||||||||
| 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 | |
|---|---|---|---|---|
| PROGRAMS | DEPARTMENTS | PROGRAMS.DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID | FK_PROGRAMS_DEPARTMENT | |
|
PROGRAMS.DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID Name: FK_PROGRAMS_DEPARTMENT |
||||
| 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 |
||||
| PROGRAMS | PEOPLE | PROGRAMS.MANAGER_ID = PEOPLE.PERSON_ID | FK_PROGRAMS_MANAGER | |
|
PROGRAMS.MANAGER_ID = PEOPLE.PERSON_ID Name: FK_PROGRAMS_MANAGER |
||||
| PROJECTS | PROGRAMS | PROJECTS.PROGRAM_ID = PROGRAMS.PROGRAM_ID | FK_PROJECTS_PROGRAM | |
|
PROJECTS.PROGRAM_ID = PROGRAMS.PROGRAM_ID Name: FK_PROJECTS_PROGRAM |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PROGRAMS_PK | PROGRAM_ID |
Uses
| Name |
|---|
|
PROGRAMS
|
Used by
| Name |
|---|
|
PROGRAMS
|
Exported: 2019-02-04 22:52, Last imported: 2019-02-03 01:50