| SIGNERCODE |
tinyint |
|
Default = 0 |
Selects if the signature is associated with an application user or not. |
| SIGNER |
nvarchar(33) (Computed) |
yes |
CASE [SIGNERCODE] WHEN 0 THEN N'Signer is an application user' WHEN 1 THEN N'Signer is not an application user' END |
Provides a translation for the 'SIGNERCODE' field. |
| NAME |
nvarchar(255) |
|
Default = '' |
Name of none application user associated with signature. |
| SIGNATURE |
varbinary |
|
|
The image of the signature |
| SIGNATURETHUMBNAIL |
varbinary |
|
|
|
| DATEADDED |
datetime |
|
Default = getdate() |
Indicates the date this record was added. |
| DATECHANGED |
datetime |
|
Default = getdate() |
Indicates the date this record was last changed. |
| TS |
timestamp |
|
|
Timestamp. |
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |