Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| FileExtension | Unknown | 0 | null |
|
|
File extension - File extension for this format |
|||||
| FormatDescription | Unknown | 0 | null |
|
|
Format description - Description of the output format |
|||||
| FormatId | Unknown | 0 | null |
|
|
Primary key - OutputFormat unique identifier for each output format |
|||||
| FormatName | Unknown | 0 | null |
|
|
Format name - Name of the output format (PDF, Excel, CSV, etc.) |
|||||
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this format is currently available |
|||||
| MimeType | Unknown | 0 | null |
|
|
MIME type - MIME type for web delivery |
|||||
| pkOutputID | int identity | 4 | √ | null |
|
|
Primary key - OutputFormat unique identifier for each record |
||||
| OutputName | varchar | 100 | √ | null |
|
|
Name field - Descriptive name or identifier for OutputFormat records |
||||
| showOptions | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for OutputFormat records |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pkOutputID | Primary key | Asc | pkOutputID |