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_cohort_members.cohortid Defined in XMLR
contextid int8 19 null
app_context.id Defined in XMLR
name varchar 254 ''::character varying
idnumber varchar 100 null
description text 2147483647 null
descriptionformat int2 5 null
component varchar 100 ''::character varying
timecreated int8 19 null
timemodified int8 19 null
cohorttype int8 19 0
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

Indexes

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

Relationships