api_appeal

3929 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('api_appeal_id_seq'::regclass)
api_appealdocument.appeal_id api_appealdocument_appeal_id_46e3b0a3_fk_api_appeal_idR
api_appealhistory.appeal_id api_appealhistory_appeal_id_57dfabe9_fk_api_appeal_idR
deployments_eru.appeal_id deployments_eru_appeal_id_11bd74db_fk_api_appeal_idR
deployments_personneldeployment.appeal_deployed_to_id deployments_personne_appeal_deployed_to_i_03cee064_fk_api_appeaR
aid varchar 20 null
name varchar 100 null
atype int4 10 null
status int4 10 null
code varchar 20 √ null
per_opslearning.appeal_code per_opslearning_appeal_code_9a170029_fk_api_appeal_codeR
sector varchar 100 null
num_beneficiaries int4 10 null
amount_requested float8 17,17 null
amount_funded float8 17,17 null
start_date timestamptz 35,6 √ null
end_date timestamptz 35,6 √ null
created_at timestamptz 35,6 null
modified_at timestamptz 35,6 null
country_id int4 10 null
api_country.id api_appeal_country_id_914a0751_fk_api_country_idR
dtype_id int4 10 √ null
api_disastertype.id api_appeal_dtype_id_74019430_fk_api_disastertype_idR
event_id int4 10 √ null
api_event.id api_appeal_event_id_97067607_fk_api_event_idR
region_id int4 10 √ null
api_region.id api_appeal_region_id_2119ea34_fk_api_region_idR
needs_confirmation bool 1 null
previous_update timestamptz 35,6 √ null
real_data_update timestamptz 35,6 √ null
name_ar varchar 100 √ null
name_en varchar 100 √ null
name_es varchar 100 √ null
name_fr varchar 100 √ null
triggering_amount numeric 12,2 null
translation_module_original_language varchar 2 null
translation_module_skip_auto_translation bool 1 null

Indexes

Constraint Name Type Sort Column(s)
api_appeal_pkey Primary key Asc id
api_appeal_code_1f62030f_like Performance Asc code
api_appeal_code_1f62030f_uniq Must be unique Asc code
api_appeal_country_id_914a0751 Performance Asc country_id
api_appeal_dtype_id_74019430 Performance Asc dtype_id
api_appeal_event_id_97067607 Performance Asc event_id
api_appeal_region_id_2119ea34 Performance Asc region_id

Relationships

Close relationships within degrees of separation