Totara Connect Client Org Frameworks Table Schema (totara_connect_client_org_frameworks)


Description

List of organisation frameworks synced to a client

totara_connect_client_org_frameworks table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
clientid BIGINT 19 null
totara_connect_clients.id totaconnclieorgfram_cli2_fk R
fid BIGINT 19 null
org_framework.id totaconnclieorgfram_fid2_fk R
timecreated BIGINT 19 null

Table contained -1 rows

totara_connect_client_org_frameworks table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
totaconnclieorgfram_cli_ix Performance Asc clientid
totaconnclieorgfram_clifid_uix Must be unique Asc/Asc clientid + fid
totaconnclieorgfram_fid_ix Performance Asc fid

totara_connect_client_org_frameworks table relationships

Close relationships within degrees of separation