ACTIVITIES
| Documentation | Projects database |
| Name | ACTIVITIES |
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | ACTIVITY_ID | NUMBER | ||||||
| 2 | ACTIVITY_NO | VARCHAR2(50 CHAR) | ||||||
| 3 | NAME | VARCHAR2(150 CHAR) | ||||||
| 4 | PROJECT_ID | NUMBER | PROJECTS | |||||
| References: PROJECTS | ||||||||
| 5 | DESCRIPTION | VARCHAR2(4000 CHAR) | ||||||
| 6 | SCOPE | VARCHAR2(4000 CHAR) | ||||||
| 7 | DELIVERABLES | VARCHAR2(4000 CHAR) | ||||||
| 8 | ACTIVITY_TYPE_ID | NUMBER | DICTIONARY | |||||
| References: DICTIONARY | ||||||||
| 9 | STATUS_ID | NUMBER | STATUSES | |||||
| References: STATUSES | ||||||||
| 10 | MANAGER_ID | NUMBER | ||||||
| 11 | EXPECTED_BEGIN | DATE | ||||||
| 12 | EXPECTED_END | DATE | ||||||
| 13 | BUDGET_HOURS | NUMBER | ||||||
| 14 | BUDGET_COST | NUMBER | ||||||
| 15 | ASSIGNED_TO_DEPARTMENT_ID | NUMBER | DEPARTMENTS | |||||
| References: DEPARTMENTS | ||||||||
| 16 | ASSIGNED_TO_PERSON_ID | NUMBER | PEOPLE | |||||
| References: PEOPLE | ||||||||
| 17 | ASSIGNED_TO_SUPPLIER_ID | NUMBER | COMPANIES | |||||
| References: COMPANIES | ||||||||
| 18 | CONTRACT_NUMBER | VARCHAR2(50 CHAR) | ||||||
| 19 | CONTRACT_DATE | DATE | ||||||
| 20 | CONTRACT_TYPE | VARCHAR2(10 CHAR) | ||||||
| 21 | ACTUAL_BEGIN | DATE | ||||||
| 22 | ACTUAL_END | DATE | ||||||
| 23 | CREATED_DATE | DATE | Default: SYSDATE | |||||
|
Default:
SYSDATE |
||||||||
| 24 | CREATED_BY | NUMBER | ||||||
| 25 | MODIFIED_DATE | DATE | Default: SYSDATE | |||||
|
Default:
SYSDATE |
||||||||
| 26 | MODIFIED_BY | NUMBER | ||||||
| 27 | WBS_ID | NUMBER | WBS | |||||
| References: WBS | ||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| ACTIVITIES | COMPANIES | ACTIVITIES.ASSIGNED_TO_SUPPLIER_ID = COMPANIES.COMPANY_ID | FK_ACTIVITIES_SUPPLIER | |
|
ACTIVITIES.ASSIGNED_TO_SUPPLIER_ID = COMPANIES.COMPANY_ID Name: FK_ACTIVITIES_SUPPLIER |
||||
| ACTIVITIES | DEPARTMENTS | ACTIVITIES.ASSIGNED_TO_DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID | FK_ACTIVITIES_DEPARTMENT | |
|
ACTIVITIES.ASSIGNED_TO_DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID Name: FK_ACTIVITIES_DEPARTMENT |
||||
| 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 |
||||
| ACTIVITIES | PEOPLE | ACTIVITIES.ASSIGNED_TO_PERSON_ID = PEOPLE.PERSON_ID | FK_ACTIVITIES_PERSON | |
|
ACTIVITIES.ASSIGNED_TO_PERSON_ID = PEOPLE.PERSON_ID Name: FK_ACTIVITIES_PERSON |
||||
| ACTIVITIES | PROJECTS | ACTIVITIES.PROJECT_ID = PROJECTS.PROJECT_ID | FK_ACTIVITIES_PROJECT | |
|
ACTIVITIES.PROJECT_ID = PROJECTS.PROJECT_ID Name: FK_ACTIVITIES_PROJECT |
||||
| ACTIVITIES | STATUSES | ACTIVITIES.STATUS_ID = STATUSES.STATUS_ID | FK_ACTIVITIES_STATUS | |
|
ACTIVITIES.STATUS_ID = STATUSES.STATUS_ID Name: FK_ACTIVITIES_STATUS |
||||
| ACTIVITIES | WBS | ACTIVITIES.WBS_ID = WBS.WBS_ID | fk_WBS_ACTIVITIES | |
|
ACTIVITIES.WBS_ID = WBS.WBS_ID Name: fk_WBS_ACTIVITIES |
||||
| ACTIVITIES_RELATIONSHIPS | ACTIVITIES | ACTIVITIES_RELATIONSHIPS.ACTIVITY_ID = ACTIVITIES.ACTIVITY_ID | FK_ACTIVITIES_REL_ACT | |
|
ACTIVITIES_RELATIONSHIPS.ACTIVITY_ID = ACTIVITIES.ACTIVITY_ID Name: FK_ACTIVITIES_REL_ACT |
||||
| ACTIVITIES_RELATIONSHIPS | ACTIVITIES | ACTIVITIES_RELATIONSHIPS.PRECEDING_ACTIVITY_ID = ACTIVITIES.ACTIVITY_ID | FK_ACTIVITIES_REL_PREC | |
|
ACTIVITIES_RELATIONSHIPS.PRECEDING_ACTIVITY_ID = ACTIVITIES.ACTIVITY_ID Name: FK_ACTIVITIES_REL_PREC |
||||
| CST_PROJECT_COSTS | ACTIVITIES | CST_PROJECT_COSTS.ACTIVITY_ID = ACTIVITIES.ACTIVITY_ID | FK_CST_PROJECT_COSTS_ACT | |
|
CST_PROJECT_COSTS.ACTIVITY_ID = ACTIVITIES.ACTIVITY_ID Name: FK_CST_PROJECT_COSTS_ACT |
||||
| CST_PROJECT_TIME_LOG | ACTIVITIES | CST_PROJECT_TIME_LOG.ACTIVITY_ID = ACTIVITIES.ACTIVITY_ID | FK_CST_PROJECT_TIME_ACT | |
|
CST_PROJECT_TIME_LOG.ACTIVITY_ID = ACTIVITIES.ACTIVITY_ID Name: FK_CST_PROJECT_TIME_ACT |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_ACTIVITIES | ACTIVITY_ID |
Uses
| Name |
|---|
|
ACTIVITIES
|
Used by
Exported: 2019-02-04 22:52, Last imported: 2019-02-03 01:50