Auth Connect Ids Table Schema (auth_connect_ids)


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 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