Table: dbo.Billing_Calculation_Type
Columns
NameTypeConstraintsDescription
billing_calculation_type_KEYint (4)NOT NULLPrimary key for this table
descriptionnvarchar (50)NOT NULLDescription of the calculation type, used for droplist display
billing_fee_type_KEYint (4)NOT NULLForeign key; to indicate the related billing fee item type
Primary key
NameColumnsDescription
PK_Billing_Calculation_Typebilling_calculation_type_KEY
Unique constraints
NameColumnsDescription
UK_Billing_Calculation_Type$billing_fee_type_KEY$descriptionbilling_fee_type_KEY, description
Foreign keys
NameColumnsReferenced tableDescription
FK_Billing_Calculation_Type__Billing_Fee_Type__billing_fee_type_KEYbilling_fee_type_KEYBilling_Fee_Type (billing_fee_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Billing_Item__Billing_Calculation_Type__billing_calculation_type_KEYbilling_calculation_type_KEYBilling_Item

Schema diagram