os_sched_cont_activities

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_container_activity_logs.ACTIVITY_ID FK_CONT_ACT_LOG_ACT_IDR
os_sched_cont_act_users.ACTIVITY_ID FK_SCHED_CONT_ACT_USERS_ACT_IDR
CONTAINER_ID BIGINT 19 null
os_storage_containers.IDENTIFIER FK_SCHED_ACTIVITIES_CONT_IDR
NAME VARCHAR 64 null
START_DATE TIMESTAMP 19 null
CYCLE_INTERVAL BIGINT 19 null
CYCLE_INTERVAL_UNIT VARCHAR 16 null
TASK_ID BIGINT 19 null
os_container_tasks.IDENTIFIER FK_SCHED_ACTIVITIES_TASK_IDR
REM_INTERVAL BIGINT 19 null
REM_INTERVAL_UNIT VARCHAR 16 null
REPEAT_CYCLE BIT 1 null
ACTIVITY_STATUS VARCHAR 16 null
DISABLE_REMINDERS BIT 1 b'0'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_SCHED_ACTIVITIES_CONT_ID Performance Asc CONTAINER_ID
FK_SCHED_ACTIVITIES_TASK_ID Performance Asc TASK_ID

Relationships

Close relationships within degrees of separation