app_org

0 rows


Description

Totara organisations

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_org_id_seq'::regclass)
app_appraisal_grp_org.orgid Defined in XMLR
app_comp_record.organisationid Defined in XMLR
app_feedback360_grp_org.orgid Defined in XMLR
app_goal_grp_org.orgid Defined in XMLR
app_org.parentid Defined in XMLR
app_org_competencies.organisationid Defined in XMLR
app_org_relations.id1 Defined in XMLR
app_org_relations.id2 Defined in XMLR
app_org_type_info_data.organisationid Defined in XMLR
app_pos_assignment.organisationid Defined in XMLR
app_pos_assignment_history.organisationid Defined in XMLR
shortname varchar 100 null
description text 2147483647 null
idnumber varchar 100 null
frameworkid int8 19 null
app_org_framework.id Defined in XMLR
path varchar 255 ''::character varying
parentid int8 19 null
app_org.id Defined in XMLR
visible int2 5 null
timecreated int8 19 null
timemodified int8 19 null
usermodified int8 19 null
fullname varchar 1024 null
depthlevel int8 19 null
typeid int8 19 0
app_org_type.id Defined in XMLR
sortthread varchar 255 null
totarasync int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_org_id_pk Primary key Asc id
app_org_fra_ix Performance Asc frameworkid
app_org_par_ix Performance Asc parentid
app_org_tot_ix Performance Asc totarasync
app_org_typ_ix Performance Asc typeid

Relationships