basemaps

25 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
baselayers.basemap_id FK_baselayers_basemaps_basemap_id C
basemaps.parent_id FK_basemaps_basemaps_parent_id C
layers.basemap_id FK_layers_basemaps_basemap_id N
maps.basemap_id FK_maps_basemaps_basemap_id N

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

Tenant identifier.
name varchar 256 null
service int4 10 √ null
url text 2147483647 √ null
layers text 2147483647 √ null
styles text 2147483647 √ null
format text 2147483647 √ null
version text 2147483647 √ null
min_scale int4 10 √ null
max_scale int4 10 √ null
is_composite bool 1 false
is_transparent bool 1 false
is_tiled bool 1 false
is_light bool 1 false
parent_id uuid 2147483647 √ null
basemaps.id FK_basemaps_basemaps_parent_id C
index 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

Indexes

Constraint Name Type Sort Column(s)
PK_basemaps Primary key Asc id
IX_basemaps_created_at Performance Asc created_at
IX_basemaps_id Must be unique Asc id
IX_basemaps_is_system Performance Asc is_system
IX_basemaps_name Performance Asc name
IX_basemaps_parent_id Performance Asc parent_id
IX_basemaps_tenant_id Performance Asc tenant_id

Relationships

Close relationships within degrees of separation