Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
Connection ID |
|
| app_guid | VARCHAR | 128 | √ | null |
|
|
Application GUID |
|
| app_meta | TEXT | 65535 | √ | null |
|
|
Application Metadata (JSON) |
|
| cxn_guid | VARCHAR | 128 | √ | null |
|
|
Connection GUID |
|
| secret | TEXT | 65535 | √ | null |
|
|
Shared secret |
|
| perm | TEXT | 65535 | √ | null |
|
|
Permissions approved for the service (JSON) |
|
| options | TEXT | 65535 | √ | null |
|
|
Options for the service (JSON) |
|
| is_active | TINYINT | 3 | √ | 1 |
|
|
Is connection currently enabled? |
|
| created_date | TIMESTAMP | 19 | √ | null |
|
|
When was the connection was created. |
|
| modified_date | TIMESTAMP | 19 | √ | CURRENT_TIMESTAMP |
|
|
When the connection was created or modified. |
|
| fetched_date | TIMESTAMP | 19 | √ | null |
|
|
The last time the application metadata was fetched. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| UI_appid | Must be unique | Asc | app_guid |
| UI_keypair_cxnid | Must be unique | Asc | cxn_guid |
Diagram producer might be missing
No diagrams were produced please see application output for any errors