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 |