ACTIVITIES_RELATIONSHIPS
| Documentation | Projects database |
| Name | ACTIVITIES_RELATIONSHIPS |
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | ACTIVITY_RELATIONSHIP_ID | NUMBER | ||||||
| 2 | ACTIVITY_ID | NUMBER | ACTIVITIES | |||||
| References: ACTIVITIES | ||||||||
| 3 | PRECEDING_ACTIVITY_ID | NUMBER | ACTIVITIES | |||||
| References: ACTIVITIES | ||||||||
| 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_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 |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_ACTIVITIES_RELATIONSHIPS | ACTIVITY_RELATIONSHIP_ID |
Uses
| Name |
|---|
|
ACTIVITIES_RELATIONSHIPS
|
Exported: 2019-02-04 22:52, Last imported: 2019-02-03 01:50