Table: dbo.Import_Source
This table enumerates the different types of import sources that are available when we import data. Examples of import sources: Client Bookkeeping Solution, and QuickBooks.
Columns
NameTypeConstraintsDescription
import_source_KEYint (4)NOT NULLPrimary key.
descriptionnvarchar (80)NOT NULLDescription of an import source.
Primary key
NameColumnsDescription
PK_Import_Sourceimport_source_KEY
Unique constraints
NameColumnsDescription
UK_Import_Source$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client__Import_Source__import_source_KEYimport_source_KEYClient

Schema diagram