Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | 
|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| idcana | varchar | 254 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| mouvrage | varchar | 100 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| gexploit | varchar | 100 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| enservice | varchar | 1 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| branchemnt | varchar | 1 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| typreseau | varchar | 2 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| materiau | varchar | 2 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| diametre | int4 | 10 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| _dimensionhorizontale | int4 | 10 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| _forme | varchar | 2 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| _etat | varchar | 2 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| anfinpose | varchar | 4 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| modecirc | varchar | 2 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| contcanass | varchar | 2 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| fonccanass | varchar | 2 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| idnini | varchar | 254 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| idnterm | varchar | 254 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| idcanppale | varchar | 254 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| zamont | numeric | 6,3 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| zaval | numeric | 6,3 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| sensecoul | varchar | 1 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| andebpose | varchar | 4 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| _precisionannee | varchar | 2 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| longcana | int4 | 10 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| _longcana_cm | numeric | 7,2 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| _longcana_reelle | numeric | 7,2 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| _pente | numeric | 6,2 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| nbranche | int4 | 10 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| qualglocxy | varchar | 2 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| qualglocz | varchar | 2 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| datemaj | date | 13 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| sourmaj | varchar | 100 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| qualannee | varchar | 2 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| dategeoloc | date | 13 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| sourgeoloc | varchar | 100 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| sourattrib | varchar | 100 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| _source_historique | text | 2147483647 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| _code_chantier | text | 2147483647 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| _date_import | text | 2147483647 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| geom | geometry | 2147483647 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| _temp_data | hstore | 2147483647 | √ | null | 
                                         | 
                                    
                                         |