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_pla2_uix | Must be unique | Asc | platformuniqueidhash |
enroltiappregi_pla_uix | Must be unique | Asc | platformclienthash |
enroltiappregi_uni_uix | Must be unique | Asc | uniqueid |