Table: dbo.Finance_Charge_Date_Basis
This table stores the types of dates that finance charges can be calculated from.
Columns
NameTypeConstraintsDescription
finance_charge_date_basis_KEYint (4)NOT NULLPrimary key for this table
descriptionnvarchar (46)NOT NULLDescription of the calcualte from type.
Primary key
NameColumnsDescription
PK_Finance_Charge_Date_Basisfinance_charge_date_basis_KEY
Unique constraints
NameColumnsDescription
UK_Finance_Charge_Date_Basis$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Finance_Charge_Definition__Finance_Charge_Date_Basis__finance_charge_date_basis_KEYfinance_charge_date_basis_KEYFinance_Charge_Definition

Schema diagram