Table: dbo.Billing_Item_Form
This table holds the different forms for each form type used for creating form fees.
Columns
NameTypeConstraintsDescription
billing_item_form_KEYint (4)NOT NULLPrimary Key
billing_item_form_type_KEYint (4)NOT NULLThe form type this form is related to.
descriptionnvarchar (64)NOT NULLThe name of the form.
Primary key
NameColumnsDescription
PK_Billing_Item_Formbilling_item_form_KEY
Unique constraints
NameColumnsDescription
UK_Billing_Item_Form$billing_item_form_type_KEY$descriptionbilling_item_form_type_KEY, description
Foreign keys
NameColumnsReferenced tableDescription
FK_Billing_Item_Form__Billing_Item_Form_Type__billing_item_form_type_KEYbilling_item_form_type_KEYBilling_Item_Form_Type (billing_item_form_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Form_Processing_Run_Form_Count__Billing_Item_Form__billing_item_form_KEYbilling_item_form_KEYForm_Processing_Run_Form_Count
FK_Billing_Item_Form_Rate__Billing_Item_Form__billing_item_form_KEYbilling_item_form_KEYBilling_Item_Form_Rate

Schema diagram