Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| AuthorizedBy | Unknown | 0 | null |
|
|
Authorized by - Person who authorized the legal stamp |
|||||
| DateInserted | smalldatetime | 16 | (getdate()) |
|
|
Date/time field - Date and time when inserted occurred or was recorded |
|||||
| DocumentId | Unknown | 0 | null |
|
|
Document reference - Reference to the stamped document |
|||||
| fkLegalContentID | int | 4 | null |
|
|
Foreign key reference - Reference to LegalContent table for data relationships |
|||||
| fkAgreementID | int | 4 | null |
|
|
Foreign key reference - Reference to Agreement table for data relationships |
|||||
| IsValid | Unknown | 0 | null |
|
|
Valid flag - Whether the stamp is currently valid |
|||||
| pkStampID | int identity | 4 | √ | null |
|
|
Primary key - LegalStamp unique identifier for each record |
||||
| StampData | Unknown | 0 | null |
|
|
Stamp data - Digital signature or stamp information |
|||||
| StampDate | Unknown | 0 | null |
|
|
Stamp date - Date when the legal stamp was applied |
|||||
| StampId | Unknown | 0 | null |
|
|
Primary key - LegalStamp unique identifier for each legal stamp |
|||||
| StampType | Unknown | 0 | null |
|
|
Stamp type - Type of legal stamp or approval |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_LegalStamp | Primary key | Asc | pkStampID |