ScrewTurn Wiki

Tablepublic.location_specific_status_changes

Edit

Columns

ColumnData TypeNullableDefaultDescription
idintegernot null  
locationmonitoridintegernot null  
ifserviceidintegernot null  
statuscodeintegernot null  
statustimetimestamp with time zonenot null  
statusreasonvarchar(255)null  
responsetimedouble precisionnull  

Edit

Primary Key

Primary KeyColumns
location_specific_status_changes_pkeyid

Edit

Indexes

IndexTypeColumns
location_specific_status_changes_ifserviceid ifserviceid
location_specific_status_changes_locationmonitorid locationmonitorid
location_specific_status_changes_locationmonitorid_ifserviceid locationmonitorid, ifserviceid
location_specific_status_changes_locationmonitorid_loc_if_time locationmonitorid, ifserviceid, statustime
location_specific_status_changes_statustime statustime

Edit

Foreign Keys

RelationColumnReferenced Column
public.ifservicesifserviceidid
public.location_monitorslocationmonitoridid

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.