Table: dbo.Data_Origin
This table enumerates possible origins of certain data (for example, bank transactions or journal entries) in the database.
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