Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ConfigID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each header/footer configuration set |
|
| HeaderFontSize | int | 4 | null |
|
|
Header font size - Font size setting for document headers in points |
||
| HeaderFontFamily | varchar | 50 | null |
|
|
Header font family - Font family name for document header text (e.g., ‘Arial’, ‘Times New Roman’) |
||
| HeaderFontColor | varchar | 50 | null |
|
|
Header font color - Color setting for document header text (hex code or color name) |
||
| int | 4 | null |
|
|
Footer font size - Font size setting for document footers in points |
|||
| varchar | 50 | null |
|
|
Footer font family - Font family name for document footer text |
|||
| varchar | 50 | null |
|
|
Footer font color - Color setting for document footer text (hex code or color name) |
|||
| SignatureInfo | varchar | 255 | √ | null |
|
|
Signature information - Configuration for signature display and formatting in documents |
|
| SignatureTypes | varchar | 255 | √ | null |
|
|
Signature types - Available signature types and formats for document signing |
|
| AgencyLogo | varchar | 255 | √ | null |
|
|
Agency logo path - File path or URL to agency logo for document branding |
|
| ShowAgencyName | bit | 1 | √ | ((0)) |
|
|
Show agency name flag - Boolean indicator whether to display agency name in documents |
|
| TextAfterSignature | varchar | 255 | √ | null |
|
|
Post-signature text - Text to display after signature lines in documents |
|
| AgencyFontColor | varchar | 50 | √ | null |
|
|
Agency text color - Color setting for agency name and branding text |
|
| AgencyFontFamily | varchar | 50 | √ | null |
|
|
Agency font family - Font family for agency name and branding text |
|
| AgencyFontSize | int | 4 | √ | null |
|
|
Agency font size - Font size for agency name and branding text in points |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_HeaderFooterConfig | Primary key | Asc | ConfigID |
Relationships
Close relationships within degrees of separation
