| 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 | |