Org Framework Table Schema (org_framework)


A collection of organisations

org_framework table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
org.frameworkid org_fra2_fk R
totara_connect_client_org_frameworks.fid totaconnclieorgfram_fid2_fk R
shortname VARCHAR 100 null
idnumber VARCHAR 100 null
description LONGTEXT 2147483647 null
sortorder BIGINT 19 null
visible TINYINT 3 null
hidecustomfields TINYINT 3 null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
usermodified BIGINT 19 null
fullname VARCHAR 1024 null

Table contained -1 rows

org_framework table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
orgfram_sor_uix Must be unique Asc sortorder

org_framework table relationships