Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| pdl | text | 2147483647 | null |
|
|
|||||||||||
| annee | text | 2147483647 | √ | null |
|
|
||||||||||
| ccodep | text | 2147483647 | √ | null |
|
|
code département - |
|||||||||
| ccodir | text | 2147483647 | √ | null |
|
|
code direction - |
|||||||||
| ccocom | text | 2147483647 | √ | null |
|
|
code commune INSEE - |
|||||||||
| ccopre | text | 2147483647 | √ | null |
|
|
code du préfixe - |
|||||||||
| ccosec | text | 2147483647 | √ | null |
|
|
lettres de section - |
|||||||||
| dnupla | text | 2147483647 | √ | null |
|
|
numéro de plan - |
|||||||||
| parcelle | text | 2147483647 | √ | null |
|
|
||||||||||
| dnupdl | text | 2147483647 | √ | null |
|
|
no de pdl - |
|||||||||
| dnivim | text | 2147483647 | √ | null |
|
|
niveau imbrication - |
|||||||||
| ctpdl | text | 2147483647 | √ | null |
|
|
type de pdl - bnd, cl, cv, tf, clv, mp. |
|||||||||
| dmrpdl | text | 2147483647 | √ | null |
|
|
lot mère(plan+pdl+lot) - |
|||||||||
| gprmut | text | 2147483647 | √ | null |
|
|
top '1ere mut effectuée - |
|||||||||
| dnupro | text | 2147483647 | √ | null |
|
|
compte de la pdl - |
|||||||||
| comptecommunal | text | 2147483647 | √ | null |
|
|
||||||||||
| ccocif | text | 2147483647 | √ | null |
|
|
code cdif - |
|||||||||
| lot | text | 2147483647 | √ | null |
|
|
Table contained 1975 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pdl_pk | Primary key | Asc | pdl |
| idxan_pdl | Performance | Asc | annee |
Relationships
Close relationships within degrees of separation
