Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | √ | null |
|
|
||
| i_created_date | timestamp | 29,6 | √ | null |
|
|
||
| i_created_by | varchar | 255 | √ | null |
|
|
||
| i_inspection_date | timestamp | 29,6 | √ | null |
|
|
||
| i_provisional_inspection_date | timestamp | 29,6 | √ | null |
|
|
||
| i_last_modified_date | timestamp | 29,6 | √ | null |
|
|
||
| i_last_modified_by | varchar | 255 | √ | null |
|
|
||
| i_number | int4 | 10 | √ | null |
|
|
||
| i_reference | varchar | 255 | √ | null |
|
|
||
| i_deleted_date | timestamp | 29,6 | √ | null |
|
|
||
| i_deleted_by | varchar | 255 | √ | null |
|
|
||
| i_version | int4 | 10 | √ | null |
|
|
||
| i_counter_inspection | bool | 1 | √ | null |
|
|
||
| i_form_id | uuid | 2147483647 | √ | null |
|
|
||
| i_external_reference_1 | varchar | 255 | √ | null |
|
|
||
| i_external_reference_2 | varchar | 255 | √ | null |
|
|
||
| ity_code | varchar | 255 | √ | null |
|
|
||
| ity_description | varchar | 2048 | √ | null |
|
|
||
| ity_id | uuid | 2147483647 | √ | null |
|
|
||
| ity_name | varchar | 255 | √ | null |
|
|
||
| ist_code | varchar | 255 | √ | null |
|
|
||
| ist_description | varchar | 2048 | √ | null |
|
|
||
| ist_id | uuid | 2147483647 | √ | null |
|
|
||
| ist_name | varchar | 255 | √ | null |
|
|
||
| ad_comment | varchar | 2048 | √ | null |
|
|
||
| ad_date | date | 13 | √ | null |
|
|
||
| ad_id | uuid | 2147483647 | √ | null |
|
|
||
| adt_code | varchar | 255 | √ | null |
|
|
||
| adt_description | varchar | 2048 | √ | null |
|
|
||
| adt_id | uuid | 2147483647 | √ | null |
|
|
||
| adt_name | varchar | 255 | √ | null |
|
|
||
| ada_email | varchar | 255 | √ | null |
|
|
||
| ada_id | uuid | 2147483647 | √ | null |
|
|
||
| ada_username | varchar | 255 | √ | null |
|
|
||
| ada_last_name | varchar | 255 | √ | null |
|
|
||
| ada_first_name | varchar | 255 | √ | null |
|
|
||
| mdt_code | varchar | 255 | √ | null |
|
|
||
| mdt_description | varchar | 2048 | √ | null |
|
|
||
| mdt_id | uuid | 2147483647 | √ | null |
|
|
||
| mdt_name | varchar | 255 | √ | null |
|
|
||
| md_comment | varchar | 2048 | √ | null |
|
|
||
| md_date | date | 13 | √ | null |
|
|
||
| md_id | uuid | 2147483647 | √ | null |
|
|
||
| mda_email | varchar | 255 | √ | null |
|
|
||
| mda_id | uuid | 2147483647 | √ | null |
|
|
||
| mda_username | varchar | 255 | √ | null |
|
|
||
| mda_last_name | varchar | 255 | √ | null |
|
|
||
| mda_first_name | varchar | 255 | √ | null |
|
|
||
| c_id | uuid | 2147483647 | √ | null |
|
|
||
| c_reference | varchar | 255 | √ | null |
|
|
||
| c_external_reference_1 | varchar | 255 | √ | null |
|
|
||
| c_external_reference_2 | varchar | 255 | √ | null |
|
|
||
| c_comment | varchar | 2048 | √ | null |
|
|
||
| c_note | varchar | 255 | √ | null |
|
|
||
| c_due_date | date | 13 | √ | null |
|
|
||
| ca_number | int4 | 10 | √ | null |
|
|
||
| ca_extra | varchar | 255 | √ | null |
|
|
||
| ca_street | varchar | 1024 | √ | null |
|
|
||
| ca_zip_code_id | uuid | 2147483647 | √ | null |
|
|
||
| ca_building | varchar | 255 | √ | null |
|
|
||
| ca_apartment | varchar | 255 | √ | null |
|
|
||
| ca_floor | varchar | 255 | √ | null |
|
|
||
| ca_stair | varchar | 255 | √ | null |
|
|
||
| ca_complement | varchar | 255 | √ | null |
|
|
||
| ca_geometry | varchar | 100 | √ | null |
|
|
||
| cp_id | uuid | 2147483647 | √ | null |
|
|
||
| p_code_insee | varchar | 255 | √ | null |
|
|
||
| p_idp | varchar | 255 | √ | null |
|
|
||
| p_area | numeric | 10,2 | √ | null |
|
|
||
| p_number | varchar | 255 | √ | null |
|
|
||
| p_section | varchar | 255 | √ | null |
|
|
||
| p_commune | varchar | 255 | √ | null |
|
|
||
| p_geometry | text | 2147483647 | √ | null |
|
|
||
| p_code_arr | varchar | 255 | √ | null |
|
|
||
| p_municipality | varchar | 255 | √ | null |
|
|
||
| p_sheet | varchar | 255 | √ | null |
|
|
||
| p_com_abs | varchar | 255 | √ | null |
|
|
||
| p_owner | varchar | 255 | √ | null |
|
|
||
| pt_code | varchar | 255 | √ | null |
|
|
||
| pt_description | varchar | 2048 | √ | null |
|
|
||
| pt_id | uuid | 2147483647 | √ | null |
|
|
||
| pt_name | varchar | 255 | √ | null |
|
|
