Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
id | bigserial | 19 | √ | nextval('user_layer_id_seq'::regclass) |
|
|
||||
uuid | varchar | 64 | √ | null |
|
|
||||
layer_name | varchar | 256 | null |
|
|
|||||
layer_desc | varchar | 256 | √ | null |
|
|
||||
layer_source | varchar | 256 | √ | null |
|
|
||||
publisher_name | varchar | 256 | √ | null |
|
|
||||
created | timestamptz | 35,6 | CURRENT_TIMESTAMP |
|
|
|||||
updated | timestamptz | 35,6 | √ | null |
|
|
||||
fields | json | 2147483647 | √ | null |
|
|
||||
wkt | varchar | 512 | √ | ''::character varying |
|
|
||||
options | json | 2147483647 | √ | null |
|
|
||||
locale | json | 2147483647 | √ | '{}'::json |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
user_layer_pkey | Primary key | Asc | id |
user_layer_uuid_index | Performance | Asc | uuid |