Auth Connect Ids Table Schema (auth_connect_ids)


Description

General server to client database id mappings

auth_connect_ids table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
serverid BIGINT 19 null
auth_connect_servers.id authconnids_ser2_fk R
tablename VARCHAR 64

Database table name, maximum is 40, but use more to prevent future problems
remoteid BIGINT 19 null

Record id in server table
localid BIGINT 19 null

Record id in client table
timecreated BIGINT 19 null

Table contained -1 rows

auth_connect_ids table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
authconnids_ser_ix Performance Asc serverid
authconnids_sertabrem_uix Must be unique Asc/Asc/Asc serverid + tablename + remoteid
authconnids_tabloc_uix Must be unique Asc/Asc tablename + localid

auth_connect_ids table relationships

Close relationships within degrees of separation