Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | null |
|
|
The Signed Documents Document ID (ULID). |
||
| ver | uuid | 2147483647 | null |
|
|
The Signed Documents Document Version Number (ULID). |
||
| type | uuid | 2147483647 | null |
|
|
The Signed Document type identifier. |
||
| _text | 2147483647 | null |
|
|
The Primary Author`s list of the Signed Document. |
|||
| metadata | jsonb | 2147483647 | √ | null |
|
|
Extra metadata extracted from the Signed Document, and encoded as JSON. |
|
| payload | jsonb | 2147483647 | √ | null |
|
|
IF the document has a compressed json payload, the uncompressed json payload is stored here. |
|
| raw | bytea | 2147483647 | null |
|
|
The RAW unaltered signed document, including its signatures, and full COSE envelope. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pk | Primary key | Asc/Asc | id + ver |
| idx_signed_docs_authors | Performance | Asc | authors |
| idx_signed_docs_metadata | Performance | Asc | metadata |
| idx_signed_docs_payload | Performance | Asc | payload |
| idx_signed_docs_type | Performance | Asc | type |
| idx_signed_docs_type_authors | Performance | Asc/Asc | type + authors |
Relationships
Close relationships within degrees of separation
