app_totara_core_relationship

8 rows


Description

List of relationships that can exist between users

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_totara_core_relationship_id_seq'::regclass)
app_goal_perform_status.status_changer_relationship_id Defined in XMLR
app_pathway_perform_rating.rater_relationship_id Defined in XMLR
app_perform_manual_relation_selection.manual_relationship_id Defined in XMLR
app_perform_manual_relation_selection.selector_relationship_id Defined in XMLR
app_perform_notification_recipient.core_relationship_id Defined in XMLR
app_perform_participant_instance.core_relationship_id Defined in XMLR
app_perform_section_relationship.core_relationship_id Defined in XMLR
app_perform_subject_instance_manual_participant.core_relationship_id Defined in XMLR
app_totara_core_relationship_resolver.relationship_id Defined in XMLR
idnumber varchar 255 ''::character varying
type int2 5 0
component varchar 100 √ null
sort_order int8 19 1
created_at int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_totacorerela_id_pk Primary key Asc id
app_totacorerela_idn_uix Must be unique Asc idnumber
app_totacorerela_sor_ix Performance Asc sort_order

Relationships

Close relationships within degrees of separation