Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| IDENTIFIER | BIGINT | 19 | √ | null |
|
|
||||
| FORM_CTXT_ID | BIGINT | 19 | null |
|
|
|||||
| OBJECT_ID | BIGINT | 19 | null |
|
|
|||||
| TOKEN | VARCHAR | 255 | null |
|
|
|||||
| CREATED_BY | BIGINT | 19 | null |
|
|
|||||
| CREATION_TIME | TIMESTAMP | 19 | √ | null |
|
|
||||
| EXPIRY_TIME | TIMESTAMP | 19 | √ | null |
|
|
||||
| COMPLETION_TIME | TIMESTAMP | 19 | √ | null |
|
|
||||
| STATUS | VARCHAR | 32 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | IDENTIFIER |
| FK_FDE_TK_CREATOR | Performance | Asc | CREATED_BY |
| FK_FDE_TOKENS_FORM_CTXT_ID | Performance | Asc | FORM_CTXT_ID |
| OS_FDE_TOKEN_UQ | Must be unique | Asc | TOKEN |



