bac_ins_f_db_provided_doc

28 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_db.provided_document_id fk_bac_ins_f_db_on_provided_document R
deleted_by varchar 255 √ null
deleted_date timestamp 29,6 √ null
version int4 10 null
created_by varchar 255 √ null
created_date timestamp 29,6 √ null
last_modified_by varchar 255 √ null
last_modified_date timestamp 29,6 √ null
signed_connection_request_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_db_provided_doc_on_signed_connection_request R
quotation_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_db_provided_doc_on_quotation R
purchase_order_number_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_db_provided_doc_on_purchase_order_number R
invoice_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_db_provided_doc_on_invoice R
complete_file_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_db_provided_doc_on_complete_file R
certificate_of_conformity_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_db_provided_doc_on_certificate_of_conformity R
other_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_db_provided_doc_on_other R
other_description varchar 1024 √ null
number_of_os varchar 255 √ null
amount_of_os_actual_euros numeric 10,2 √ null
amount_of_os_with_tax_actual_euros numeric 10,2 √ null
cost_of_work_actual_euros numeric 10,2 √ null
taxe numeric 10,2 √ null
cost_of_work_with_taxe_actual_euros numeric 10,2 √ null
cost_for_the_owner_actual_euros numeric 10,2 √ null
cost_with_taxe_for_the_owner_actual_euros numeric 10,2 √ null
comments varchar 2048 √ null
invoice_number varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_bac_ins_f_db_provided_doc Primary key Asc id
idx_bac_ins_f_db_provided_doc_certificate Performance Asc certificate_of_conformity_id
idx_bac_ins_f_db_provided_doc_complete_file Performance Asc complete_file_id
idx_bac_ins_f_db_provided_doc_invoice_number Performance Asc invoice_id
idx_bac_ins_f_db_provided_doc_other Performance Asc other_id
idx_bac_ins_f_db_provided_doc_purchase_order Performance Asc purchase_order_number_id
idx_bac_ins_f_db_provided_doc_quotation Performance Asc quotation_id
idx_bac_ins_f_db_provided_doc_signed_connection Performance Asc signed_connection_request_id

Relationships

Close relationships within degrees of separation