# enrol_lti_app_registration

0 rows

### Description

Details of each application that has been registered with the tool

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |
enrol_lti_deployment.platformid | enroltidepl_pla2_fkR
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

### Relationships