Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each provider signature record, auto-incrementing integer |
|
| ProviderId | int | 4 | √ | null |
|
|
Provider reference - Reference to the healthcare provider who created this signature |
|
| Signature | varchar | 2147483647 | √ | null |
|
|
Digital signature data - Encoded digital signature data for authentication and legal compliance |
|
| CreatedDate | datetime | 16,3 | √ | null |
|
|
Signature timestamp - When this digital signature was created |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - When this signature was logically deleted |
|
| Latitude | float | 8 | √ | null |
|
|
GPS latitude - Geographic latitude coordinate where signature was captured for location verification |
|
| Longitude | float | 8 | √ | null |
|
|
GPS longitude - Geographic longitude coordinate where signature was captured for location verification |
|
| Agent | varchar | 500 | √ | null |
|
|
User agent - Browser or device information used to capture the signature for audit purposes |
|
| Ip | varchar | 50 | √ | null |
|
|
IP address - Network IP address from which the signature was captured for security tracking |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__Provider__3214EC2701D345B0 | Primary key | Asc | ID |