Name | Type | Default | Nullable | Children | Parents | Comment |
---|---|---|---|---|---|---|
sportsPlaceId | bigint | false | ||||
geom | geometry(MultiPoint,4326) | false | ||||
name | text | false | ||||
type_typeCode | integer | false | ||||
type_name | text | false | ||||
tarmo_category | text | true | ||||
owner | text | true | ||||
admin | text | true | ||||
address | text | true | ||||
postalCode | integer | true | ||||
postalOffice | text | true | ||||
cityName | text | true | ||||
text | true | |||||
phoneNumber | text | true | ||||
www | text | true | ||||
season | text | false | ||||
toilet | boolean | true | ||||
shower | boolean | true | ||||
changingRooms | boolean | true | ||||
ligthing | boolean | true | Lippaan päässä kirjoitusvirhe | |||
restPlacesCount | numeric | true | ||||
skiTrackTraditional | boolean | true | ||||
skiTrackFreestyle | boolean | true | ||||
litRouteLengthKm | numeric | true | ||||
routeLengthKm | numeric | true | ||||
pier | boolean | true | ||||
otherPlatforms | boolean | true | ||||
accessibilityInfo | text | true | ||||
kiosk | boolean | true | ||||
skiService | boolean | true | ||||
equipmentRental | boolean | true | ||||
sauna | boolean | true | ||||
playground | boolean | true | ||||
exerciseMachines | boolean | true | ||||
infoFi | text | true | ||||
trackLengthM | numeric | true | ||||
altitudeDifference | numeric | true | ||||
climbingWallWidthM | numeric | true | ||||
climbingWallHeightM | numeric | true | ||||
climbingRoutesCount | numeric | true | ||||
holesCount | numeric | true | ||||
boatLaunchingSpot | boolean | true | ||||
iceClimbing | boolean | true | ||||
iceReduction | boolean | true | ||||
range | boolean | true | ||||
trackType | text | true | ||||
additionalInfo | text | true | ||||
images | text | true | ||||
deleted | boolean | false | false |
Name | Type | Definition |
---|---|---|
lipas_pisteet_pk | PRIMARY KEY | PRIMARY KEY ("sportsPlaceId") |
Name | Definition |
---|---|
lipas_pisteet_pk | CREATE UNIQUE INDEX lipas_pisteet_pk ON kooste.lipas_pisteet USING btree ("sportsPlaceId") |
lipas_pisteet_deleted_idx | CREATE INDEX lipas_pisteet_deleted_idx ON kooste.lipas_pisteet USING btree (deleted) |
lipas_pisteet_tarmo_category_idx | CREATE INDEX lipas_pisteet_tarmo_category_idx ON kooste.lipas_pisteet USING btree (tarmo_category) |
lipas_pisteet_cityname_idx | CREATE INDEX lipas_pisteet_cityname_idx ON kooste.lipas_pisteet USING btree ("cityName") |
Generated by tbls