Table: dbo.Quick_Books_Transaction_Type
This table stores transaction types used in quickbooks.
Columns
NameTypeConstraintsDescription
quick_books_transaction_type_KEYtinyint (1)NOT NULLthe primary key for this table.
descriptionnvarchar (42)NOT NULLThe transaction type description.
Primary key
NameColumnsDescription
PK_Quick_Books_Transaction_Typequick_books_transaction_type_KEY
Unique constraints
NameColumnsDescription
UK_Quick_Books_Transaction_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Quick_Books_Retrieved_Transaction__Quick_Books_Transaction_Type__quick_books_transaction_type_KEYquick_books_transaction_type_KEYQuick_Books_Retrieved_Transaction

Schema diagram