building

-1 rows


Columns

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

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

house_number text 2147483647 null

House number based on cadastral register / Hausnummer gemäss Grundbuch / Numéro de bâtiment selon le registre foncier

location_name text 2147483647 null

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

perimeter_geometry geometry 2147483647 null

Boundary points of the perimeter / Begrenzungspunkte der Fläche / Points de délimitation de la surface

reference_point_geometry geometry 2147483647 null

National position coordinates (East, North) (relevant point for e.g. address) / Landeskoordinate Ost/Nord (massgebender Bezugspunkt für z.B. Adressdaten ) / Coordonnées nationales Est/Nord (Point de référence pour la détermination de l’adresse par exemple)

Indexes

Constraint Name Type Sort Column(s)
pkey_tww_od_building_obj_id Primary key Asc obj_id
in_tww_building_perimeter_geometry Performance Asc perimeter_geometry
in_tww_building_reference_point_geometry Performance Asc reference_point_geometry

Check Constraints

Constraint Name Constraint
bu_house_number_length_max_50 ((char_length(house_number) <= 50))
bu_location_name_length_max_50 ((char_length(location_name) <= 50))

Relationships