Org Table Schema (org)


Description

Totara organisations

org table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
appraisal_grp_org.orgid apprgrporg_org2_fk R
auth_approved_request.organisationid authapprrequ_org2_fk R
auth_approved_request_snapshots.organisationid Implied Constraint R
comp_record.organisationid compreco_org2_fk R
course_completions.organisationid Implied Constraint R
feedback360_grp_org.orgid feedgrporg_org2_fk R
goal_grp_org.orgid goalgrporg_org2_fk R
job_assignment.organisationid jobassi_org2_fk R
org.parentid org_par2_fk R
org_competencies.organisationid orgcomp_org2_fk R
org_relations.id1 orgrela_id12_fk R
org_relations.id2 orgrela_id22_fk R
org_type_info_data.organisationid orgtypeinfodata_org2_fk R
prog_completion.organisationid Implied Constraint R
prog_completion_history.organisationid Implied Constraint R
reportbuilder_grp_org_record.orgid repogrporgreco_org2_fk R
reportbuilder_grp_org_user.orgid repogrporguser_org2_fk R
shortname VARCHAR 100 √ null
description LONGTEXT 2147483647 √ null
idnumber VARCHAR 100 √ null
frameworkid BIGINT 19 null
org_framework.id org_fra2_fk R
path VARCHAR 255
parentid BIGINT 19 null
org.id org_par2_fk R
visible TINYINT 3 null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
usermodified BIGINT 19 null
fullname VARCHAR 1024 √ null
depthlevel BIGINT 19 √ null
typeid BIGINT 19 0
org_type.id org_typ2_fk R
sortthread VARCHAR 255 √ null
totarasync BIT 1 0

Totara sync flag from totara_sync

Table contained -1 rows

org table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
org_fra_ix Performance Asc frameworkid
org_par_ix Performance Asc parentid
org_tot_ix Performance Asc totarasync
org_typ_ix Performance Asc typeid

org table relationships

Close relationships within degrees of separation