Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
||
| uuid | varchar | 64 | √ | null |
|
|
||
| category_id | int4 | 10 | √ | null |
|
|
||
| name | varchar | 256 | √ | null |
|
|
||
| attention_text | text | 2147483647 | √ | null |
|
|
||
| place_desc | text | 2147483647 | √ | null |
|
|
||
| created | timestamptz | 35,6 | √ | null |
|
|
||
| updated | timestamptz | 35,6 | √ | null |
|
|
||
| geometry | geometry | 2147483647 | √ | null |
|
|
||
| category_name | varchar | 256 | √ | null |
|
|
||
| default | bool | 1 | √ | null |
|
|
||
| stroke_width | int4 | 10 | √ | null |
|
|
||
| stroke_color | bpchar | 7 | √ | null |
|
|
||
| fill_color | bpchar | 7 | √ | null |
|
|
||
| dot_color | bpchar | 7 | √ | null |
|
|
||
| dot_size | int4 | 10 | √ | null |
|
|
||
| dot_shape | varchar | 20 | √ | null |
|
|
||
| border_width | int4 | 10 | √ | null |
|
|
||
| border_color | bpchar | 7 | √ | null |
|
|
||
| publisher_name | varchar | 256 | √ | null |
|
|
||
| link | text | 2147483647 | √ | null |
|
|
||
| image_url | varchar | 512 | √ | null |
|
|
||
| fill_pattern | int4 | 10 | √ | null |
|
|
||
| stroke_linejoin | varchar | 256 | √ | null |
|
|
||
| stroke_linecap | varchar | 256 | √ | null |
|
|
||
| stroke_dasharray | varchar | 256 | √ | null |
|
|
||
| border_linejoin | varchar | 256 | √ | null |
|
|
||
| border_dasharray | varchar | 256 | √ | null |
|
|