fountain

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_id varchar 16 tww_app.generate_oid('tww_od'::text, 'fountain'::text)
connection_object.obj_id oorel_od_fountain_connection_object C

INTERLIS STANDARD OID (with Postfix/Präfix), see www.interlis.ch

location_name text 2147483647 null

Street name or name of the location / Strassenname oder Ortsbezeichnung / Nom de la route ou du lieu

situation_geometry geometry 2147483647 null

National position coordinates (East, North) / Landeskoordinate Ost/Nord / Coordonnées nationales Est/Nord

Indexes

Constraint Name Type Sort Column(s)
pkey_tww_od_fountain_obj_id Primary key Asc obj_id
in_tww_fountain_situation_geometry Performance Asc situation_geometry

Check Constraints

Constraint Name Constraint
fo_location_name_length_max_50 ((char_length(location_name) <= 50))

Relationships