Table: Integration_Application
Columns
NameTypeConstraintsDescription
integration_application_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table
row_versiontimestampNOT NULL
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
descriptionnvarchar (250)NOT NULLUser defined description (unique).
Primary key
NameColumnsDescription
PK_Integration_Application$integration_application_KEYintegration_application_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Integration_Application$descriptiondescriptionEach description must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Status_Event__Integration_Application__integration_application_KEYintegration_application_KEYStatus_Event
FK_Client_Financial_Data__Integration_Application__integration_application_KEYintegration_application_KEYClient_Financial_Data
FK_Interaction__Integration_Application__integration_application_KEYintegration_application_KEYInteraction
FK_Integration_Invoice__Integration_Application__integration_application_KEYintegration_application_KEYIntegration_Invoice
FK_Sheet_Entry__Integration_Application__integration_application_KEYintegration_application_KEYSheet_Entry

Schema diagram