Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | √ | null |
|
|
|||||
| name | VARCHAR | 50 |
|
|
|||||||
| base_url | VARCHAR | 200 | √ | null |
|
|
Base URL for calling the API of the platform (for GDPR services) |
||||
| public_key | VARCHAR | 512 | √ | null |
|
|
Public key of this platform |
||||
| regexp | TEXT | 65535 | √ | null |
|
|
Regexp matching the urls, to automatically detect content from this platform. It is the only way to specify which items are from which platform. Recomputation of items.platform_id is triggered when changed. |
||||
| priority | INT | 10 | 0 |
|
|
Priority of the regexp compared to others (higher value is tried first). Recomputation of items.platform_id is triggered when changed. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| priority | Must be unique | Desc | priority |