Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| obj_id | varchar | 16 | tww_app.generate_oid('tww_od'::text, 'dss15_planning_zone'::text) | 
                                         | 
                                    
                                        
  | 
                                    [primary_key] INTERLIS STANDARD OID (with Postfix/Präfix) or UUOID, see www.interlis.ch  | 
                                |||||
| kind | int4 | 10 | √ | null | 
                                         | 
                                    
                                        
  | 
                                    Type of planning zone / Art der Bauzone / Genre de zones à bâtir  | 
                                ||||
| 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_dss15_planning_zone_obj_id | Primary key | Asc | obj_id | 
| in_tww_od_dss15_planning_zone_perimeter_geometry | Performance | Asc | perimeter_geometry |