From dbscript Online Help
wikibot
| Table
|
public.location_specific_status_changes
|
| Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
| id
|
integer
|
not null
|
|
location_specific_status_changes_pkey
|
|
| locationmonitorid
|
integer
|
not null
|
|
|
location_specific_status_changes_locationmonitorid_ifserviceidlocation_specific_status_changes_locationmonitoridlocation_specific_status_changes_locationmonitorid_loc_if_time
|
| ifserviceid
|
integer
|
not null
|
|
|
location_specific_status_changes_locationmonitorid_ifserviceidlocation_specific_status_changes_ifserviceidlocation_specific_status_changes_locationmonitorid_loc_if_time
|
| statuscode
|
integer
|
not null
|
|
|
|
| statustime
|
timestamp with time zone
|
not null
|
|
|
location_specific_status_changes_statustimelocation_specific_status_changes_locationmonitorid_loc_if_time
|
| statusreason
|
varchar(255)
|
null
|
|
|
|
| responsetime
|
double precision
|
null
|
|
|
|