Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| lotslocaux | text | 2147483647 | null |
|
|
|||||
| annee | text | 2147483647 | √ | null |
|
|
||||
| ccodepl | text | 2147483647 | √ | null |
|
|
Lot - Code département - |
|||
| ccodirl | text | 2147483647 | √ | null |
|
|
Lot - Code direction - |
|||
| ccocoml | text | 2147483647 | √ | null |
|
|
Lot - Code INSEE de la commune - |
|||
| ccoprel | text | 2147483647 | √ | null |
|
|
Lot - Code préfixe - |
|||
| ccosecl | text | 2147483647 | √ | null |
|
|
Lot - Code section - |
|||
| dnuplal | text | 2147483647 | √ | null |
|
|
Lot - Numéro du plan - |
|||
| dnupdl | text | 2147483647 | √ | null |
|
|
Lot - Numéro de PDL - |
|||
| dnulot | text | 2147483647 | √ | null |
|
|
Lot - Numéro de lot - |
|||
| lots | text | 2147483647 | √ | null |
|
|
||||
| ccodebpb | text | 2147483647 | √ | null |
|
|
Local - Code département - |
|||
| ccodird | text | 2147483647 | √ | null |
|
|
Local - Code direction - |
|||
| ccocomb | text | 2147483647 | √ | null |
|
|
Local - Code commune - |
|||
| ccopreb | text | 2147483647 | √ | null |
|
|
Local - Code préfixe - |
|||
| invloc | text | 2147483647 | √ | null |
|
|
Local - Numéro invariant du local - |
|||
| local00 | text | 2147483647 | √ | null |
|
|
||||
| local10 | text | 2147483647 | √ | null |
|
|
||||
| dnumql | text | 2147483647 | √ | null |
|
|
Local - Numérateur du lot - |
|||
| ddenql | text | 2147483647 | √ | null |
|
|
Local - Dénominateur du lot - |
|||
| lot | text | 2147483647 | √ | null |
|
|
Table contained 36131 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| loclocaux_pk | Primary key | Asc | lotslocaux |
| idxan_lotslocaux | Performance | Asc | annee |
Relationships
Close relationships within degrees of separation
