layers

7 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
layers_styles.layer_id FK_layers_styles_layers_layer_id C

Unique identifier.
tenant_id uuid 2147483647 null
tenants.id FK_layers_tenants_tenant_id C

Tenant identifier.
map_id uuid 2147483647 null
maps.id FK_layers_maps_map_id C
name varchar 256 null
type int4 10 0
element_id uuid 2147483647 √ null
elements.id FK_layers_elements_element_id N
basemap_id uuid 2147483647 √ null
basemaps.id FK_layers_basemaps_basemap_id N
label text 2147483647 √ null
is_hidden bool 1 false
is_selected bool 1 false
is_expanded bool 1 false
is_selectable bool 1 false
is_expandable bool 1 false
is_editable bool 1 false
group_id uuid 2147483647 √ null
layers_groups.id FK_layers_layers_groups_group_id N
index int4 10 √ null
created_at timestamptz 35,6 now()

DateTime the record was created.
created_by uuid 2147483647 √ null

User who create the record. Null if System.
updated_at timestamptz 35,6 √ null

DateTime the record was last updated.
updated_by uuid 2147483647 √ null

User who last updated the record.
is_system bool 1 false

A system-generated record. Default = false
description text 2147483647 √ null
refresh_interval int4 10 0

Indexes

Constraint Name Type Sort Column(s)
PK_layers Primary key Asc id
IX_layers_basemap_id Performance Asc basemap_id
IX_layers_created_at Performance Asc created_at
IX_layers_element_id Performance Asc element_id
IX_layers_group_id Performance Asc group_id
IX_layers_id Must be unique Asc id
IX_layers_is_system Performance Asc is_system
IX_layers_map_id Performance Asc map_id
IX_layers_name Performance Asc name
IX_layers_tenant_id Performance Asc tenant_id
IX_layers_type Performance Asc type

Relationships

Close relationships within degrees of separation