alert_system_loaditem

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
alert_system_alertemaillog.item_id alert_system_alertem_item_id_d6f2fa56_fk_alert_sysR
alert_system_loaditem_related_go_events.loaditem_id alert_system_loadite_loaditem_id_0977d307_fk_alert_sysR
alert_system_loaditem_related_montandon_events.from_loaditem_id alert_system_loadite_from_loaditem_id_1990ed67_fk_alert_sysR
alert_system_loaditem_related_montandon_events.to_loaditem_id alert_system_loadite_to_loaditem_id_e26922e2_fk_alert_sysR
extraction_run_id uuid 2147483647 √ null
created_at timestamptz 35,6 null
event_id varchar 2147483647 null
parent_event_id varchar 2147483647 null
event_title varchar 255 null
event_description text 2147483647 null
start_datetime timestamptz 35,6 null
end_datetime timestamptz 35,6 √ null
country_codes _varchar 150 √ null
severity_unit varchar 100 √ null
severity_label varchar 255 √ null
severity_value int4 10 √ null
episode_number int4 10 √ null
total_people_exposed int4 10 √ null
total_buildings_exposed int4 10 √ null
impact_metadata jsonb 2147483647 null
item_eligible bool 1 null
is_past_event bool 1 null
event_url varchar 200 null
connector_id int8 19 null
alert_system_connector.id alert_system_loadite_connector_id_e35e3cbe_fk_alert_sysR

Indexes

Constraint Name Type Sort Column(s)
alert_system_loaditem_pkey Primary key Asc id
alert_system_loaditem_connector_id_e35e3cbe Performance Asc connector_id
alert_system_loaditem_event_id_fdb7b815_like Performance Asc event_id
alert_system_loaditem_event_id_key Must be unique Asc event_id
alert_system_loaditem_event_url_83af1975_like Performance Asc event_url
alert_system_loaditem_event_url_key Must be unique Asc event_url
alert_system_loaditem_extraction_run_id_bb1db26e Performance Asc extraction_run_id

Relationships

Close relationships within degrees of separation