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 XML R
app_auth_approved_request.organisationid Defined in XML R
app_comp_record.organisationid Defined in XML R
app_dp_plan_competency_value.organisationid Defined in XML R
app_feedback360_grp_org.orgid Defined in XML R
app_goal_grp_org.orgid Defined in XML R
app_job_assignment.organisationid Defined in XML R
app_org.parentid Defined in XML R
app_org_competencies.organisationid Defined in XML R
app_org_relations.id1 Defined in XML R
app_org_relations.id2 Defined in XML R
app_org_type_info_data.organisationid Defined in XML R
app_perform_subject_static_instance.organisation_id Defined in XML R
app_reportbuilder_grp_org_record.orgid Defined in XML R
app_reportbuilder_grp_org_user.orgid Defined in XML R
shortname varchar 100 √ null
description text 2147483647 √ null
idnumber varchar 100 √ null
frameworkid int8 19 null
app_org_framework.id Defined in XML R
path varchar 255 ''::character varying
parentid int8 19 null
app_org.id Defined in XML R
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 XML R
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

Close relationships within degrees of separation