bac_ins_f_au_request_characteristic

30 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_au.request_characteristics_id fk_bac_ins_f_au_on_request_characteristics R
bac_ins_f_au_request_characteristic_area.request_characteristic_id fk_bacinsfaurequestcharacteristicarea_on_requestcharacteristic 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
other_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_request_characteristic_on_other_document R
other_document_comment varchar 2048 √ null
floor_area_m2 numeric 10,2 √ null
declared_area_m2 numeric 10,2 √ null
computed_area_different_than_declared_area_m2 numeric 10,2 √ null
contribution_type_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_request_characteristic_on_contribution_type R
status_pfac_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_request_characteristic_on_status_pfac R
tariff_year int4 10 √ null
final_amount numeric 10,2 √ null
amount_pfac numeric 10,2 √ null
computed_amount_pfac numeric 10,2 √ null
computed_comment_pfac text 2147483647 √ null
comment_pfac varchar 2048 √ null
payment_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_request_characteristic_on_payment R
instalments_payment_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_request_characteristic_on_instalments_payment R
amount_payed numeric 10,2 √ null
payment_method varchar 255 √ null
payment_date date 13 √ null
characteristics_comment varchar 2048 √ null
completed_area_than_declared_area_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfaurequestcharacterist_on_completedareathandeclaredare R
algorithm_pfac_id uuid 2147483647 √ null
bac_algorithm_pfac_parameter.id fk_bac_ins_f_au_request_characteristic_on_algorithm_pfac R

Indexes

Constraint Name Type Sort Column(s)
pk_bac_ins_f_au_request_characteristic Primary key Asc id
idx_bac_ins_f_au_request_characteristic_contribution_type Performance Asc contribution_type_id
idx_bac_ins_f_au_request_characteristic_instalments_payment Performance Asc instalments_payment_id
idx_bac_ins_f_au_request_characteristic_other_document Performance Asc other_document_id
idx_bac_ins_f_au_request_characteristic_payment Performance Asc payment_id
idx_bac_ins_f_au_request_characteristic_status_pfac Performance Asc status_pfac_id

Relationships

Close relationships within degrees of separation