Table: dbo.Client_Synchronization
This tables stores the last synchronization time per client.
Columns
NameTypeConstraintsDescription
client_synchronization_KEYint (4)NOT NULLPrimary Key for this table.
client_KEYint (4)NOT NULLThe key of the client who did the synchronization.
client_synchronization_type_KEYint (4)NOT NULLThe type of synchronization the client did.
last_synchronization_time_utcdatetime (8, 3)NOT NULLThe time in UTC of the last synchronization.
Primary key
NameColumnsDescription
PK_Client_Synchronizationclient_synchronization_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Synchronization__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_Synchronization__Client_Synchronization_Type__client_synchronization_type_KEYclient_synchronization_type_KEYClient_Synchronization_Type (client_synchronization_type_KEY)

Schema diagram