Table: dbo.Data_Origin
This table enumerates possible origins of certain data (for example, bank transactions or journal entries) in the database. For data integrity reasons, entries MUST NEVER BE REMOVED FROM THIS TABLE and can be instead documented as obsolete. Value 16 is reserved. It was OnBalance; it was removed from this table leading to the need to triage customer data by altering the audit trail to reflect such entries were manual data entry.
Columns
NameTypeConstraintsDescription
data_origin_KEYint (4)NOT NULLPrimary key.
descriptionnvarchar (50)NOT NULLDescription of a data origin.
Primary key
NameColumnsDescription
PK_Data_Origindata_origin_KEY
Unique constraints
NameColumnsDescription
UK_Data_Origin$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client__Data_Origin__data_origin_KEYdata_origin_KEYClient
FK_Journal_Entry__Data_Origin__data_origin_KEYdata_origin_KEYJournal_Entry
FK_Bank_Transaction__Data_Origin__data_origin_KEYdata_origin_KEYBank_Transaction
FK_Bank_Transaction_Template__Data_Origin__data_origin_KEYdata_origin_KEYBank_Transaction_Template
FK_Payable_Payment_Application$data_origin_KEYdata_origin_KEYPayable_Payment_Application

Schema diagram