Table: dbo.Billing_Item_Form | |||
This table holds the different forms for each form type used for creating form fees. | |||
Columns | |||
Name | Type | Constraints | Description |
billing_item_form_KEY | int (4) | NOT NULL | Primary Key |
billing_item_form_type_KEY | int (4) | NOT NULL | The form type this form is related to. |
description | nvarchar (64) | NOT NULL | The name of the form. |
Primary key | |||
Name | Columns | Description | |
PK_Billing_Item_Form | billing_item_form_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Billing_Item_Form$billing_item_form_type_KEY$description | billing_item_form_type_KEY, description |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Billing_Item_Form__Billing_Item_Form_Type__billing_item_form_type_KEY | billing_item_form_type_KEY | Billing_Item_Form_Type (billing_item_form_type_KEY) |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Form_Processing_Run_Form_Count__Billing_Item_Form__billing_item_form_KEY | billing_item_form_KEY | Form_Processing_Run_Form_Count | |
FK_Billing_Item_Form_Rate__Billing_Item_Form__billing_item_form_KEY | billing_item_form_KEY | Billing_Item_Form_Rate |