Totara Connect Client Pos Frameworks Table Schema (totara_connect_client_pos_frameworks)


Description

List of position frameworks synced to a client

totara_connect_client_pos_frameworks table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
clientid BIGINT 19 null
totara_connect_clients.id totaconnclieposfram_cli2_fk R
fid BIGINT 19 null
pos_framework.id totaconnclieposfram_fid2_fk R
timecreated BIGINT 19 null

Table contained -1 rows

totara_connect_client_pos_frameworks table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
totaconnclieposfram_cli_ix Performance Asc clientid
totaconnclieposfram_clifid_uix Must be unique Asc/Asc clientid + fid
totaconnclieposfram_fid_ix Performance Asc fid

totara_connect_client_pos_frameworks table relationships

Close relationships within degrees of separation