Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| pevlissage | text | 2147483647 | null |
|
|
|||||
| annee | text | 2147483647 | √ | null |
|
|
||||
| ccodep | text | 2147483647 | √ | null |
|
|
Code du département |
|||
| ccodir | text | 2147483647 | √ | null |
|
|
Code de direction |
|||
| ccocom | text | 2147483647 | √ | null |
|
|
Code commune INSEE |
|||
| invar | text | 2147483647 | √ | null |
|
|
Numéro invariant |
|||
| dnupev | text | 2147483647 | √ | null |
|
|
Numéro de PEV |
|||
| pev | text | 2147483647 | √ | null |
|
|
Code unique de PEV |
|||
| mlbcom | int4 | 10 | √ | null |
|
|
Quote-part de lissage de la commune |
|||
| mlbsyn | int4 | 10 | √ | null |
|
|
Quote-part de lissage du syndicat intercommunal |
|||
| mlbcu | int4 | 10 | √ | null |
|
|
Quote-part de lissage de l’intercommunalité |
|||
| mlbdep | int4 | 10 | √ | null |
|
|
Quote-part de lissage du département |
|||
| mlbts1 | int4 | 10 | √ | null |
|
|
Quote-part de lissage de la TSE |
|||
| mlbts2 | int4 | 10 | √ | null |
|
|
Quote-part de lissage de la TSE autre |
|||
| mlbtas | int4 | 10 | √ | null |
|
|
Quote-part de lissage de la TASA |
|||
| mlbgem | int4 | 10 | √ | null |
|
|
Quote-part de lissage GEMAPI |
|||
| mlbtom | int4 | 10 | √ | null |
|
|
Quote-part de lissage TEOM |
|||
| tbfpas | int4 | 10 | √ | null |
|
|
Pas de lissage du local |
|||
| mlbtfc | int4 | 10 | √ | null |
|
|
Quote-parte de lissage sur les friches commerciales (TFC) |
|||
| lot | text | 2147483647 | √ | null |
|
|
Code de lot d’import |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pevlissage_pk | Primary key | Asc | pevlissage |
Relationships
Close relationships within degrees of separation
