Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||
| name | VARCHAR | 255 |
|
|
Common name to identify this platform to users |
|||||
| platformid | LONGTEXT | 2147483647 | √ | null |
|
|
The issuer URL |
|||
| clientid | VARCHAR | 1333 | √ | null |
|
|
The clientid string, generated by the platform when setting up the tool. |
|||
| uniqueid | VARCHAR | 255 |
|
|
A unique local id, which can be used in the initiate login URI to provide {iss, clientid} uniqueness in the absence of the optional client_id claim. |
|||||
| platformclienthash | VARCHAR | 64 | √ | null |
|
|
SHA256 hash of the platformid (issuer) and clientid |
|||
| platformuniqueidhash | VARCHAR | 64 | √ | null |
|
|
SHA256 hash of the platformid (issuer) and uniqueid |
|||
| authenticationrequesturl | LONGTEXT | 2147483647 | √ | null |
|
|
The authorisation endpoint of the platform |
|||
| jwksurl | LONGTEXT | 2147483647 | √ | null |
|
|
The JSON Web Key Set URL for the platform |
|||
| accesstokenurl | LONGTEXT | 2147483647 | √ | null |
|
|
||||
| status | BIT | 1 | 0 |
|
|
Status of the registration, used to denote draft (incomplete) or active (complete) |
||||
| timecreated | BIGINT | 19 | null |
|
|
|||||
| timemodified | BIGINT | 19 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| enroltiappregi_pla3_uix | Must be unique | Asc | platformclienthash |
| enroltiappregi_pla4_uix | Must be unique | Asc | platformuniqueidhash |
| enroltiappregi_uni2_uix | Must be unique | Asc | uniqueid |
Relationships
Close relationships within degrees of separation
