Totara Learn 12
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
Org Framework Table Schema (org_framework)
Description
A collection of organisations
org_framework table columns
Related columns
Constraint
Comments
Search:
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
Showing 1 to 11 of 11 entries
Table contained
-1
rows
org_framework table indexes
Search:
Constraint Name
Type
Sort
Column(s)
PRIMARY
Primary key
Asc
id
orgfram_sor_uix
Must be unique
Asc
sortorder
Showing 1 to 2 of 2 entries
org_framework table relationships
Close relationships within degrees of separation
One
Two degrees
One implied
Two implied