map_wms_tile_layer

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
deleted_by varchar 255 √ null
deleted_date timestamp 29,6 √ null
code varchar 255 null
search_key varchar 255 null
name varchar 255 √ null
description varchar 2048 √ null
sort_name varchar 255 √ null
best_confidence_origin_id uuid 2147483647 √ null
com_data_origin.id fk_map_wms_tile_layer_on_best_confidence_origin R
version int4 10 null
created_by varchar 255 √ null
created_date timestamp 29,6 √ null
last_modified_by varchar 255 √ null
last_modified_date timestamp 29,6 √ null
visible bool 1 √ null
url varchar 255 √ null
attribution varchar 255 √ null
sub_domains varchar 255 √ null
layers text 2147483647 √ null
styles text 2147483647 √ null
format varchar 255 √ null
transparent bool 1 √ null
version_service varchar 255 √ null
crs int4 10 √ null
opacity float8 17,17 √ null
min_zoom int4 10 √ null
max_zoom int4 10 √ null
color varchar 255 √ null
icon varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_map_wms_tile_layer Primary key Asc id
idx_map_wms_tile_layer_unq Must be unique Asc/Asc code + search_key
idx_map_wms_tile_layer_unq_name Must be unique Asc/Asc name + search_key

Relationships

Close relationships within degrees of separation