Table: dbo.Receivable_Detail_Type
Columns
NameTypeConstraintsDescription
receivable_detail_type_KEYint (4)NOT NULLPrimary key
descriptionnvarchar (80)NOT NULLA particular kind of receivable detail item - a fee, a discount, a sales tax, etc.
Primary key
NameColumnsDescription
PK_Receivable_Detail_Typereceivable_detail_type_KEY
Unique constraints
NameColumnsDescription
UK_Receivable_Detail_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Receivable_Transaction_Detail__Receivable_Detail_Type__receivable_detail_type_KEYreceivable_detail_type_KEYReceivable_Transaction_Detail

Schema diagram