Table: dbo.Shortfall_Transaction_Type
Type table which defines the source of the shortfall transaction
Columns
NameTypeConstraintsDescription
shortfall_transaction_type_KEYint (4)NOT NULLPrimary Key
descriptionnvarchar (30)NOT NULLDescription of the shortfall transaction source
Primary key
NameColumnsDescription
PK_Shortfall_Transaction_Typeshortfall_transaction_type_KEY
Unique constraints
NameColumnsDescription
UK_Shortfall_Transaction_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Shortfall_Transaction__Shortfall_Transaction_Type__shortfall_transaction_type_KEYshortfall_transaction_type_KEYShortfall_Transaction

Schema diagram