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 |
|
|