ins_full_inspection_view_export

264 rows


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

Relationships

Close relationships within degrees of separation