Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pkSignatureTypeId | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each signature type |
||||
| SignatureType | varchar | 50 | null |
|
|
Signature type name - Descriptive name of the signature type (e.g., ‘Provider Signature’, ‘Parent Consent’, ‘Witness’) |
|||||
| DeletedBy | int | 4 | √ | null |
|
|
Deleted by user - UserID of the person who deleted this signature type |
||||
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when the signature type was deleted |
||||
| ModifiedBy | int | 4 | √ | null |
|
|
Modified by user - UserID of the person who last modified this signature type |
||||
| ModifiedDate | datetime | 16,3 | √ | null |
|
|
Modification date - Date when the signature type was last modified |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this signature type |
||||
| CreatedDate | datetime | 16,3 | √ | null |
|
|
Creation date - Date when the signature type was created |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_SignatureTypes | Primary key | Asc | pkSignatureTypeId |
Relationships
Close relationships within degrees of separation
