api_appealhistory

39113 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('api_appealhistory_id_seq'::regclass)
num_beneficiaries int4 10 null
amount_requested float8 17,17 null
amount_funded float8 17,17 null
valid_from timestamptz 35,6 √ null
valid_to timestamptz 35,6 √ null
aid varchar 20 null
start_date timestamptz 35,6 √ null
end_date timestamptz 35,6 √ null
atype int4 10 null
appeal_id int4 10 √ null
api_appeal.id api_appealhistory_appeal_id_57dfabe9_fk_api_appeal_idR
country_id int4 10 null
api_country.id api_appealhistory_country_id_a6e61f17_fk_api_country_idR
region_id int4 10 √ null
api_region.id api_appealhistory_region_id_021d21f5_fk_api_region_idR
dtype_id int4 10 √ null
api_disastertype.id api_appealhistory_dtype_id_a0d98a60_fk_api_disastertype_idR
needs_confirmation bool 1 null
status int4 10 null
code varchar 20 √ null
triggering_amount numeric 12,2 null

Indexes

Constraint Name Type Sort Column(s)
api_appealhistory_pkey Primary key Asc id
api_appealhistory_appeal_id_57dfabe9 Performance Asc appeal_id
api_appealhistory_country_id_a6e61f17 Performance Asc country_id
api_appealhistory_dtype_id_a0d98a60 Performance Asc dtype_id
api_appealhistory_region_id_021d21f5 Performance Asc region_id

Relationships

Close relationships within degrees of separation