Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
---|---|---|---|---|---|---|---|---|---|---|---|
obj_id | varchar | 16 | tww_app.generate_oid('tww_od'::text, 'individual_surface'::text) |
|
|
INTERLIS STANDARD OID (with Postfix/Präfix), see www.interlis.ch |
|||||
function | int4 | 10 | √ | null |
|
|
Type of usage of surface / Art der Nutzung der Fläche / Genre d’utilisation de la surface |
||||
inclination | int2 | 5 | √ | null |
|
|
yyy_Mittlere Neigung der Oberfläche in Promill / Mittlere Neigung der Oberfläche in Promill / Pente moyenne de la surface en promille |
||||
pavement | int4 | 10 | √ | null |
|
|
Type of pavement / Art der Befestigung / Genre de couverture du sol |
||||
perimeter_geometry | geometry | 2147483647 | √ | null |
|
|
Boundary points of the perimeter / Begrenzungspunkte der Fläche / Points de délimitation de la surface |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
pkey_tww_od_individual_surface_obj_id | Primary key | Asc | obj_id |
in_tww_individual_surface_perimeter_geometry | Performance | Asc | perimeter_geometry |