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. |
Table contained 0 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| priority | Must be unique | Desc | priority |
Relationships
Close relationships within degrees of separation
