Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| consumer_id | CHAR | 32 |
|
|
||||
| consumer_type | enum('http', 'studip', 'oauth') | 6 | studip |
|
|
|||
| auth_key | VARCHAR | 64 | √ | null |
|
|
||
| auth_secret | VARCHAR | 64 | √ | null |
|
|
||
| active | BIT | 1 | 0 |
|
|
|||
| system | BIT | 1 | 0 |
|
|
|||
| type | enum('website', 'mobile', 'desktop') | 7 | √ | website |
|
|
||
| title | VARCHAR | 128 | √ | null |
|
|
||
| contact | VARCHAR | 255 | √ | null |
|
|
||
| VARCHAR | 255 | √ | null |
|
|
|||
| url | VARCHAR | 255 | √ | null |
|
|
||
| callback | VARCHAR | 255 | √ | null |
|
|
||
| commercial | BIT | 1 | √ | null |
|
|
||
| description | TEXT | 65535 | √ | null |
|
|
||
| priority | INT UNSIGNED | 10 | 0 |
|
|
|||
| notes | TEXT | 65535 | √ | null |
|
|
||
| mkdate | INT UNSIGNED | 10 | null |
|
|
|||
| chdate | INT UNSIGNED | 10 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | consumer_id |
Diagram producer might be missing
No diagrams were produced please see application output for any errors