maps

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
baselayers.map_id FK_baselayers_maps_map_id C
layers.map_id FK_layers_maps_map_id C
layers_groups.map_id FK_layers_groups_maps_map_id C

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

Tenant identifier.
name varchar 256 null
srid int4 10 null
spatial_ref_sys.srid Implied Constraint R
basemap_id uuid 2147483647 √ null
basemaps.id FK_maps_basemaps_basemap_id N
group_id uuid 2147483647 √ null
groups.id FK_maps_groups_group_id N
center_x float8 17,17 √ null
center_y float8 17,17 √ null
scale int4 10 √ null
min_x float8 17,17 √ null
min_y float8 17,17 √ null
max_x float8 17,17 √ null
max_y float8 17,17 √ null
min_scale int4 10 √ null
max_scale int4 10 √ null
thumbnail bytea 2147483647 √ 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
version varchar 256 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_maps Primary key Asc id
IX_maps_basemap_id Performance Asc basemap_id
IX_maps_created_at Performance Asc created_at
IX_maps_group_id Performance Asc group_id
IX_maps_id Must be unique Asc id
IX_maps_is_system Performance Asc is_system
IX_maps_name Performance Asc name
IX_maps_tenant_id Performance Asc tenant_id

Relationships

Close relationships within degrees of separation