api_gdacsevent

284 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('api_gdacsevent_id_seq'::regclass)
api_gdacsevent_countries.gdacsevent_id api_gdacsevent_count_gdacsevent_id_656d74e3_fk_api_gdacsR
eventid varchar 12 null
title text 2147483647 null
description text 2147483647 null
image varchar 200 √ null
report varchar 200 √ null
publication_date timestamptz 35,6 null
year int4 10 null
lat float8 17,17 null
lon float8 17,17 null
event_type varchar 16 null
alert_level int4 10 null
alert_score varchar 16 √ null
severity text 2147483647 √ null
severity_unit varchar 16 null
severity_value varchar 16 null
population_unit varchar 16 null
population_value varchar 16 null
vulnerability float8 17,17 null
country_text text 2147483647 null
country_text_ar text 2147483647 √ null
country_text_en text 2147483647 √ null
country_text_es text 2147483647 √ null
country_text_fr text 2147483647 √ null
description_ar text 2147483647 √ null
description_en text 2147483647 √ null
description_es text 2147483647 √ null
description_fr text 2147483647 √ null
title_ar text 2147483647 √ null
title_en text 2147483647 √ null
title_es text 2147483647 √ null
title_fr text 2147483647 √ null
translation_module_original_language varchar 2 null
translation_module_skip_auto_translation bool 1 null
disaster_type_id int4 10 √ null
api_disastertype.id api_gdacsevent_disaster_type_id_49171dd9_fk_api_disastertype_idR

Indexes

Constraint Name Type Sort Column(s)
api_gdacsevent_pkey Primary key Asc id
api_gdacsevent_disaster_type_id_49171dd9 Performance Asc disaster_type_id

Relationships

Close relationships within degrees of separation