app_cohort

0 rows


Description

Each record represents one cohort (aka site-wide group).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_cohort_id_seq'::regclass)
app_appraisal_grp_cohort.cohortid Defined in XML R
app_auth_connect_user_collections.cohortid Defined in XML R
app_cohort_members.cohortid Defined in XML R
app_cohort_msg_queue.cohortid Defined in XML R
app_cohort_plan_config.cohortid Defined in XML R
app_cohort_plan_history.cohortid Defined in XML R
app_cohort_role.cohortid Defined in XML R
app_cohort_rule_collections.cohortid Defined in XML R
app_cohort_visibility.cohortid Defined in XML R
app_feedback360_grp_cohort.cohortid Defined in XML R
app_goal_grp_cohort.cohortid Defined in XML R
app_goal_user_type_cohort.cohortid Defined in XML R
app_report_builder_schedule_email_audience.cohortid Defined in XML R
app_reportbuilder_grp_cohort_record.cohortid Defined in XML R
app_reportbuilder_grp_cohort_user.cohortid Defined in XML R
app_tenant.cohortid Defined in XML R
app_totara_connect_client_cohorts.cohortid Defined in XML R
app_totara_connect_clients.cohortid Defined in XML R
app_totara_dashboard_cohort.cohortid Defined in XML R
app_totara_useraction_scheduled_rule_audience_map.cohort_id Defined in XML R
contextid int8 19 null
app_context.id Defined in XML R
name varchar 254 ''::character varying
idnumber varchar 100 √ null
description text 2147483647 √ null
descriptionformat int2 5 null
visible int2 5 1
component varchar 100 ''::character varying
timecreated int8 19 null
timemodified int8 19 null
cohorttype int8 19 1
modifierid int8 19 0
visibility int2 5 0
alertmembers int2 5 0
startdate int8 19 √ null
enddate int8 19 √ null
active int2 5 0
calculationstatus int2 5 1
activecollectionid int8 19 √ null
draftcollectionid int8 19 √ null
broken int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_coho_id_pk Primary key Asc id
app_coho_con_ix Performance Asc contextid
app_coho_tim2_ix Performance Asc timecreated
app_coho_tim_ix Performance Asc timemodified

Relationships

Close relationships within degrees of separation