os_container_activity_logs

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
CONTAINER_ID BIGINT 19 null
os_storage_containers.IDENTIFIER FK_CONT_ACT_LOG_CONT_IDR
ACTIVITY_ID BIGINT 19 √ null
os_sched_cont_activities.IDENTIFIER FK_CONT_ACT_LOG_ACT_IDR
TASK_ID BIGINT 19 null
os_container_tasks.IDENTIFIER FK_CONT_ACT_LOG_TASK_IDR
PERFORMED_BY BIGINT 19 null
catissue_user.IDENTIFIER FK_CONT_ACT_LOG_USER_IDR
ACTIVITY_DATE TIMESTAMP 19 null
TIME_TAKEN BIGINT 19 √ null
COMMENTS VARCHAR 512 √ null
ACTIVITY_STATUS VARCHAR 16 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_CONT_ACT_LOG_ACT_ID Performance Asc ACTIVITY_ID
FK_CONT_ACT_LOG_CONT_ID Performance Asc CONTAINER_ID
FK_CONT_ACT_LOG_TASK_ID Performance Asc TASK_ID
FK_CONT_ACT_LOG_USER_ID Performance Asc PERFORMED_BY

Relationships

Close relationships within degrees of separation