---
description: Details for all tables in the Platform database
---

# Database \| Table details

## apikeys

| Field | Type | Null | Key | Default | Extra |
| :--- | :--- | :--- | :--- | :--- | :--- |
| id | int\(11\) | NO | PRI | NULL | auto\_increment |
| api\_key | text | NO |  | NULL |  |
| client\_id | text | YES |  | NULL |  |
| client\_secret | text | YES |  | NULL |  |
| created | int\(11\) | NO |  | 0 |  |
| updated | int\(11\) | YES |  | NULL |  |

## config

| Field | Type | Null | Key | Default | Extra |
| :--- | :--- | :--- | :--- | :--- | :--- |
| id | int\(11\) | NO | PRI | NULL | auto\_increment |
| group\_name | varchar\(50\) | NO | MUL | NULL |  |
| config\_key | varchar\(50\) | NO |  | NULL |  |
| config\_value | text | YES |  | NULL |  |
| updated | timestamp | NO | MUL | CURRENT\_TIMESTAMP | on update CURRENT\_TIMESTAMP |

## contacts

| Field | Type | Null | Key | Default | Extra |
| :--- | :--- | :--- | :--- | :--- | :--- |
| id | int\(11\) | NO | PRI | NULL | auto\_increment |
| user\_id | int\(11\) | YES | MUL | NULL |  |
| data\_source | varchar\(150\) | YES | MUL | NULL |  |
| type | varchar\(20\) | YES |  | NULL |  |
| contact | varchar\(255\) | NO |  | NULL |  |
| created | int\(11\) | NO | MUL | 0 |  |
| updated | int\(11\) | YES | MUL | NULL |  |
| can\_notify | tinyint\(1\) | NO |  | 0 |  |

## country\_codes

| Field | Type | Null | Key | Default | Extra |
| :--- | :--- | :--- | :--- | :--- | :--- |
| id | int\(11\) | NO | PRI | NULL | auto\_increment |
| country\_name | varchar\(255\) | NO |  | 0 |  |
| dial\_code | varchar\(255\) | NO |  | 0 |  |
| country\_code | varchar\(255\) | NO | MUL | 0 |  |

## csv

| Field | Type | Null | Key | Default | Extra |
| :--- | :--- | :--- | :--- | :--- | :--- |
| id | int\(11\) | NO | PRI | NULL | auto\_increment |
| columns | text | NO |  | NULL |  |
| maps\_to | text | YES |  | NULL |  |
| fixed | text | YES |  | NULL |  |
| filename | varchar\(255\) | NO |  | NULL |  |
| size | int\(11\) | NO |  | 0 |  |
| mime | varchar\(50\) | NO |  |  |  |
| created | int\(11\) | NO |  | 0 |  |
| updated | int\(11\) | YES |  | NULL |  |
| status | varchar\(255\) | YES |  | NULL |  |
| errors | varchar\(255\) | YES |  | NULL |  |
| processed | varchar\(255\) | YES |  | NULL |  |
| collection\_id | int\(11\) | YES |  | NULL |  |

## export\_batches

| Field | Type | Null | Key | Default | Extra |
| :--- | :--- | :--- | :--- | :--- | :--- |
| id | int\(11\) | NO | PRI | NULL | auto\_increment |
| export\_job\_id | int\(11\) | NO | MUL | NULL |  |
| status | varchar\(255\) | NO |  | pending |  |
| batch\_number | int\(11\) | NO |  | 0 |  |
| filename | varchar\(255\) | YES |  |  |  |
| has\_headers | tinyint\(1\) | NO |  | 0 |  |
| rows | int\(11\) | NO |  | 0 |  |
| created | int\(11\) | NO |  | 0 |  |
| updated | int\(11\) | YES |  | 0 |  |

## export\_job

| Field | Type | Null | Key | Default | Extra |
| :--- | :--- | :--- | :--- | :--- | :--- |
| id | int\(11\) | NO | PRI | NULL | auto\_increment |
| user\_id | int\(11\) | NO | MUL | NULL |  |
| entity\_type | varchar\(255\) | NO |  | NULL |  |
| fields | mediumtext | YES |  | NULL |  |
| filters | mediumtext | YES |  | NULL |  |
| status | varchar\(255\) | YES |  | NULL |  |
| url | text | YES |  | NULL |  |
| created | int\(11\) | NO |  | 0 |  |
| updated | int\(11\) | NO |  | 0 |  |
| url\_expiration | varchar\(12\) | YES |  | 0 |  |
| status\_details | varchar\(255\) | YES |  | 0 |  |
| header\_row | mediumtext | YES |  | NULL |  |
| hxl\_meta\_data\_id | int\(11\) | YES | UNI | NULL |  |
| include\_hxl | tinyint\(1\) | NO |  | 0 |  |
| send\_to\_browser | tinyint\(1\) | NO |  | 0 |  |
| send\_to\_hdx | tinyint\(1\) | NO |  | 0 |  |
| hxl\_heading\_row | mediumtext | YES |  | NULL |  |
| total\_rows | int\(11\) | YES |  | NULL |  |
| total\_batches | int\(11\) | YES |  | NULL |  |

## form\_attribute\_hxl\_attribute\_tag

| Field | Type | Null | Key | Default | Extra |
| :--- | :--- | :--- | :--- | :--- | :--- |
| id | int\(11\) | NO | PRI | NULL | auto\_increment |
| form\_attribute\_id | int\(11\) | NO | MUL | 0 |  |
| hxl\_attribute\_id | int\(11\) | YES | MUL | NULL |  |
| hxl\_tag\_id | int\(11\) | NO | MUL | 0 |  |
| export\_job\_id | int\(11\) | NO | MUL | 0 |  |

## form\_attribute

| Field | Type | Null | Key | Default | Extra |
| :--- | :--- | :--- | :--- | :--- | :--- |
|  |  |  |  |  |  |
| id | int\(11\) | NO | PRI | NULL | auto\_increment |
| key | varchar\(150\) | NO | UNI | NULL |  |
| label | varchar\(150\) | NO |  | NULL |  |
| instructions | text | YES |  | NULL |  |
| input | varchar\(30\) | NO |  | text |  |
| type | varchar\(30\) | NO |  | varchar |  |
| required | tinyint\(1\) | NO |  | 0 |  |
| default | varchar\(150\) | YES |  | NULL |  |
| priority | int\(11\) | NO | MUL | 99 |  |
| options | text | YES |  | NULL |  |
| cardinality | int\(11\) | NO |  | 1 |  |
| config | text | YES |  | NULL |  |
| form\_stage\_id | omt\(11\) | YES | MUL | NULL |  |
| response\_private | tinyint\(1\) | NO |  | 0 |  |
| description | varchar\(255\) | YES |  | NULL |  |

## form\_roles

| Field | Type | Null | Key | Default | Extra |
| :--- | :--- | :--- | :--- | :--- | :--- |
| id | int\(11\) | NO | PRI | NULL | auto\_increment |
| form\_id | int\(11\) | NO | MUL | NULL |  |
| role\_id | int\(11\) | NO | MUL | NULL |  |

## form\_stages

| Field | Type | Null | Key | Default | Extra |
| :--- | :--- | :--- | :--- | :--- | :--- |
| id | int\(11\) | NO | PRI | NULL | auto\_increment |
| form\_id | int\(11\) | NO | MUL | NULL |  |
| label | varchar\(150\) | NO |  | NULL |  |
| priority | int\(11\) | NO |  | 99 |  |
| icon | varchar\(100\) | YES |  | NULL |  |
| required | tinyint\(1\) | NO |  | 0 |  |
| type | varchar\(255\) | NO |  | task |  |
| description | varchar\(255\) | YES |  | NULL |  |
| show\_when\_published | tinyint\(1\) | NO |  | 1 |  |
| task\_is\_internal\_only | tinyint\(1\) | NO |  | 1 |  |

## form\_stages\_posts

| Field | Type | Null | Key | Default | Extra |
| :--- | :--- | :--- | :--- | :--- | :--- |
| form\_stage\_id | int\(11\) | NO | PRI | NULL |  |
| post\_id | int\(11\) | NO | PRI | NULL |  |
| completed | tinyint\(1\) | NO |  | 0 |  |

## forms

| Field | Type | Null | Key | Default | Extra |
| :--- | :--- | :--- | :--- | :--- | :--- |
| id | int\(11\) | NO | PRI | NULL | auto\_increment |
| parent\_id | int\(11\) | YES | MUL | NULL |  |
| name | varchar\(255\) | NO |  | NULL |  |
| description | text | YES |  | NULL |  |
| type | varchar\(30\) | NO |  | report |  |
| created | int\(11\) | NO | MUL | 0 |  |
| updated | int\(11\) | YES | MUL | NULL |  |
| disabled | tinyint\(1\) | NO |  | 0 |  |
| require\_approval | tinyint\(1\) | NO |  | 1 |  |
| everyone\_can\_create | tinyint\(1\) | NO |  | 1 |  |
| color | varchar\(6\) | YES |  | NULL |  |
| hide\_author | tinyint\(1\) | NO |  | 0 |  |
| hide\_time | tinyint\(1\) | NO |  | 0 |  |
| hide\_location | tinyint\(1\) | NO |  | 0 |  |
| targeted\_survey | tinyint\(1\) | NO |  | 0 |  |

## hxl\_attribute\_type\_tag

| Field | Type | Null | Key | Default | Extra |
| :--- | :--- | :--- | :--- | :--- | :--- |
| id | int\(11\) | NO | PRI | NULL | auto\_increment |
| form\_attribute\_type | varchar\(255\) | NO |  | 0 |  |
| hxl\_tag\_id | int\(11\) | NO | MUL | 0 |  |

## hxl\_attributes

| Field | Type | Null | Key | Default | Extra |
| :--- | :--- | :--- | :--- | :--- | :--- |
| id | int\(11\) | NO | PRI | NULL | auto\_increment |
| attribute | varchar\(255\) | NO | UNI | 0 |  |
| description | varchar\(255\) | NO |  | 0 |  |

## hxl\_license

| Field | Type | Null | Key | Default | Extra |
| :--- | :--- | :--- | :--- | :--- | :--- |
| id | int\(11\) | NO | PRI | NULL | auto\_increment |
| name | varchar\(255\) | NO | MUL | 0 |  |
| link | varchar\(255\) | NO |  | 0 |  |
| code | varchar\(255\) | NO | UNI | 0 |  |

## hxl\_meta\_data

| Field | Type | Null | Key | Default | Extra |
| :--- | :--- | :--- | :--- | :--- | :--- |
| id | int\(11\) | NO | PRI | NULL | auto\_increment |
| private | tinyint\(1\) | NO |  | 1 |  |
| dataset\_title | varchar\(255\) | NO | MUL | NULL |  |
| license\_id | int\(11\) | NO | MUL | NULL |  |
| user\_id | int\(11\) | NO | MUL | NULL |  |
| organisation\_id | varchar\(255\) | NO |  | NULL |  |
| source | varchar\(255\) | NO |  | NULL |  |
| created | int\(11\) | NO |  | 0 |  |
| updated | int\(11\) | YES |  | NULL |  |
| organisation\_name | varchar\(255\) | YES |  | NULL |  |

## hxl\_tag\_attributes

| Field | Type | Null | Key | Default | Extra |
| :--- | :--- | :--- | :--- | :--- | :--- |
| tag\_id | int\(11\) | NO | PRI | 0 |  |
| attribute\_id | int\(11\) | NO | PRI | 0 |  |

## hxl\_tags

| Field | Type | Null | Key | Default | Extra |
| :--- | :--- | :--- | :--- | :--- | :--- |
| id | int\(11\) | NO | PRI | NULL | auto\_increment |
| tag\_name | varchar\(255\) | NO | UNI | 0 |  |
| description | varchar\(255\) | NO |  | 0 |  |

## layers

| Field | Type | Null | Key | Default | Extra |
| :--- | :--- | :--- | :--- | :--- | :--- |
| id | int\(11\) | NO | PRI | NULL | auto\_increment |
| media\_id | int\(11\) | YES | MUL | NULL |  |
| name | varchar\(50\) | NO |  | NULL |  |
| type | varchar\(20\) | NO |  | geojson |  |
| data\_url | varchar\(255\) | YES |  | NULL |  |
| options | varchar\(255\) | YES |  | NULL |  |
| acte | int\(1\) | NO |  | 1 |  |
| invisible\_by\_default | int\(1\) | NO |  | 1 |  |
| created | int\(11\) | NO | MUL | 0 |  |
| updated | int\(11\) | NO | MUL | 0 |  |

## media

| Field | Type | Null | Key | Default | Extra |
| :--- | :--- | :--- | :--- | :--- | :--- |
| id | int\(11\) | NO | PRI | NULL | auto\_increment |
| user\_id | int\(11\) | YES | MUL | NULL |  |
| mime | varchar\(50\) | NO |  | NULL |  |
| caption | varchar\(255\) | NO |  |  |  |
| o\_filename | varchar\(255\) | NO |  | NULL |  |
| o\_size | int\(11\) | NO |  | NULL |  |
| o\_width | int\(11\) | YES |  | NULL |  |
| o\_height | int\(11\) | YES |  | NULL |  |
| created | int\(11\) | NO | MUL | 0 |  |
| updated | int\(11\) | YES | MUL | NULL |  |

## messages

| Field | Type | Null | Key | Default | Extra |
| :--- | :--- | :--- | :--- | :--- | :--- |
| id | int\(11\) | NO | PRI | NULL | auto\_increment |
| parent\_id | int\(11\) | YES | MUL | NULL |  |
| contact\_id | int\(11\) | YES | MUL | NULL |  |
| post\_id | int\(11\) | YES | MUL | NULL |  |
| user\_id | int\(11\) | YES | MUL | NULL |  |
| data\_source | varchar\(150\) | YES | MUL | NULL |  |
| data\_source\_message\_id | varchar\(255\) | YES |  | NULL |  |
| title | varchar\(255\) | YES |  | NULL |  |
| message | text | YES |  | NULL |  |
| datetime | datetime | YES |  | NULL |  |
| type | varchar\(20\) | YES | MUL | NULL |  |
| status | varchar\(20\) | NO | MUL | pending |  |
| direction | varchar\(20\) | NO | MUL | incoming |  |
| created | int\(11\) | NO | MUL | 0 |  |
| additional\_data | text | YES |  | NULL |  |
| notification\_post\_id | int\(11\) | YES | MUL | NULL |  |

## notification\_queue

| Field | Type | Null | Key | Default | Extra |
| :--- | :--- | :--- | :--- | :--- | :--- |
| id | int\(11\) | NO | PRI | NULL | auto\_increment |
| post\_id | int\(11\) | NO | MUL | NULL |  |
| set\_id | int\(11\) | NO | MUL | NULL |  |
| created | int\(11\)int\(11\) | NO |  | 0 |  |