| userpresencedata_pkey |
CREATE UNIQUE INDEX userpresencedata_pkey ON ONLY
public.userpresencedata USING btree (keyid, startdate) |
| userpresencedatastart |
CREATE INDEX userpresencedatastart ON ONLY public.userpresencedata
USING btree (startdate) |
| userpresencedatastartltc |
CREATE INDEX userpresencedatastartltc ON ONLY
public.userpresencedata USING btree (startdateltc) |
| userpresencedatatype |
CREATE INDEX userpresencedatatype ON ONLY public.userpresencedata
USING btree (timetype) |
| userpresencedatauser |
CREATE INDEX userpresencedatauser ON ONLY public.userpresencedata
USING btree (userid) |
| userpresencedata_timetype_startdateltc |
CREATE INDEX userpresencedata_timetype_startdateltc ON ONLY
public.userpresencedata USING btree (timetype, startdateltc) |
| userpresencedata_startdate_cover |
CREATE INDEX userpresencedata_startdate_cover ON ONLY
public.userpresencedata USING btree (startdate) INCLUDE (id, userid,
startdateltc, systempresenceid, presenceid, presencetime, routingid,
routingtime) |