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
|
|
|
|