Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | null |
|
|
|||||||
| name | varchar | 255 | null |
|
|
|||||||
| description | text | 2147483647 | √ | null |
|
|
||||||
| created_at | timestamp | 22 | null |
|
|
|||||||
| address_address_line1 | varchar | 255 | √ | null |
|
|
||||||
| address_address_line2 | varchar | 255 | √ | NULL::character varying |
|
|
||||||
| address_city | varchar | 255 | null |
|
|
|||||||
| address_zip_code | varchar | 6 | null |
|
|
|||||||
| address_country_code | varchar | 2 | null |
|
|
|||||||
| slug | varchar | 128 | null |
|
|
|||||||
| updated_at | timestamp | 22 | √ | NULL::timestamp without time zone |
|
|
||||||
| website | varchar | 255 | √ | NULL::character varying |
|
|
||||||
| stations | jsonb | 2147483647 | null |
|
|
|||||||
| address_latitude | float8 | 17,17 | √ | null |
|
|
||||||
| address_longitude | float8 | 17,17 | √ | null |
|
|
||||||
| categories | _text | 2147483647 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| alternative_pkey | Primary key | Asc | id |
| idx_alternative_slug | Performance | Asc | slug |
| uniq_eff5dfa989d9b62 | Must be unique | Asc | slug |

