From dbscript Online Help
wikibot
| Table
|
public.location_specific_status_changes
|
Columns
| Column
|
Data Type
|
Nullable
|
Default
|
Description
|
| id
|
integer
|
not null
|
|
|
| locationmonitorid
|
integer
|
not null
|
|
|
| ifserviceid
|
integer
|
not null
|
|
|
| statuscode
|
integer
|
not null
|
|
|
| statustime
|
timestamp with time zone
|
not null
|
|
|
| statusreason
|
varchar(255)
|
null
|
|
|
| responsetime
|
double precision
|
null
|
|
|
Primary Key
| Primary Key
|
Columns
|
| location_specific_status_changes_pkey
|
id
|
Indexes
| Index
|
Type
|
Columns
|
| 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
|
Foreign Keys
