kooste.tamperewfs_luontopolkurastit.md

kooste.tamperewfs_luontopolkurastit

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
mi_prinx	bigint		false
geom	geometry(MultiPoint,4326)		false
visibility	boolean	true	true
name	text		false
tarmo_category	text	'Ulkoilureitit'::text	true
type_name	text	'Luontopolkurasti'::text	true
tunnus	integer		true
rasti	integer		true
infoFi	text		true
lisatietoja	text		true
deleted	boolean	false	false

Constraints

Name	Type	Definition
tamperewfs_luontopolkurastit_pk	PRIMARY KEY	PRIMARY KEY (mi_prinx)

Indexes

Name	Definition
tamperewfs_luontopolkurastit_pk	CREATE UNIQUE INDEX tamperewfs_luontopolkurastit_pk ON kooste.tamperewfs_luontopolkurastit USING btree (mi_prinx)
tamperewfs_luontopolkurastit_deleted_idx	CREATE INDEX tamperewfs_luontopolkurastit_deleted_idx ON kooste.tamperewfs_luontopolkurastit USING btree (deleted)
tamperewfs_luontopolkurastit_tarmo_category_idx	CREATE INDEX tamperewfs_luontopolkurastit_tarmo_category_idx ON kooste.tamperewfs_luontopolkurastit USING btree (tarmo_category)
tamperewfs_luontopolkurastit_visibility_idx	CREATE INDEX tamperewfs_luontopolkurastit_visibility_idx ON kooste.tamperewfs_luontopolkurastit USING btree (visibility)

Relations

---

Generated by tbls