Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ConfirmationName | varchar | 50 | √ | null |
|
|
Name field - Descriptive name or identifier for ConfirmationTypes records |
||||
| ConfirmationDesc | varchar | 100 | √ | null |
|
|
Description field - Detailed description or explanation of ConfirmationTypes information |
||||
| ConfirmTypeDescription | Unknown | 0 | null |
|
|
Description - Detailed explanation of what requires confirmation |
|||||
| ConfirmTypeName | Unknown | 0 | null |
|
|
Confirmation type name - Descriptive name of the confirmation type |
|||||
| ExpirationDays | Unknown | 0 | null |
|
|
Expiration days - Number of days before confirmation expires |
|||||
| IsRequired | Unknown | 0 | null |
|
|
Required flag - Whether this confirmation is mandatory |
|||||
| pkConfirmTypeID | int | 4 | null |
|
|
Primary key - ConfirmationTypes unique identifier for each record |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ConfirmationTypes | Primary key | Asc | pkConfirmTypeID |