Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| commune | text | 2147483647 | null |
|
|
|||
| annee | text | 2147483647 | √ | null |
|
|
||
| ccodep | text | 2147483647 | √ | null |
|
|
Code département - Code département INSEE |
|
| ccodir | text | 2147483647 | √ | null |
|
|
Code direction - Code direction dge |
|
| ccocom | text | 2147483647 | √ | null |
|
|
Code commune - 3 caractères |
|
| libcom | text | 2147483647 | √ | null |
|
|
Libellé de la commune |
|
| lot | text | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| commune_majic_pk | Primary key | Asc | commune |
| idx_commune_majic_ccocom | Performance | Asc | ccocom |
Diagram producer might be missing
No diagrams were produced please see application output for any errors