Table: dbo.Client_Synchronization
This tables stores the last synchronization time per client.
Columns
Name | Type | Constraints | Description
client_synchronization_KEY | int (4) | NOT NULL | Primary Key for this table.
client_KEY | int (4) | NOT NULL | The key of the client who did the synchronization.
client_synchronization_type_KEY | int (4) | NOT NULL | The type of synchronization the client did.
last_synchronization_time_utc | datetime (8, 3) | NOT NULL | The time in UTC of the last synchronization.

Primary key
Name | Columns | Description
PK_Client_Synchronization | client_synchronization_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_Synchronization__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Client_Synchronization__Client_Synchronization_Type__client_synchronization_type_KEY | client_synchronization_type_KEY | Client_Synchronization_Type (client_synchronization_type_KEY) |