public.userinteractionpresencedetaileddata

public.userinteractionpresencedetaileddata

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(255) false
userid varchar(50) true
starttime timestamp without time zone false
starttimeltc timestamp without time zone true
endtime timestamp without time zone true
endtimeltc timestamp without time zone true
systempresence varchar(50) true
orgpresence varchar(50) true
organizationpresenceid varchar(50) true Organisation Presence GUID
routingstatus varchar(50) true
conversationid varchar(50) true
mediatype varchar(50) true
timeinstate numeric(20,2) true
updated timestamp without time zone true

Constraints

Name Type Definition
userinteractionpresencedetaileddata_pkey PRIMARY KEY PRIMARY KEY (keyid, starttime)

Indexes

Name Definition
userinteractionpresencedetaileddata_pkey CREATE UNIQUE INDEX userinteractionpresencedetaileddata_pkey ON ONLY public.userinteractionpresencedetaileddata USING btree (keyid, starttime)
userinteractionpresencedetaileddata_starttime CREATE INDEX userinteractionpresencedetaileddata_starttime ON ONLY public.userinteractionpresencedetaileddata USING btree (starttime)
userinteractionpresencedetaileddata_starttimeltc CREATE INDEX userinteractionpresencedetaileddata_starttimeltc ON ONLY public.userinteractionpresencedetaileddata USING btree (starttimeltc)
userinteractionpresencedetaileddata_endtime CREATE INDEX userinteractionpresencedetaileddata_endtime ON ONLY public.userinteractionpresencedetaileddata USING btree (endtime)
userinteractionpresencedetaileddata_endtimeltc CREATE INDEX userinteractionpresencedetaileddata_endtimeltc ON ONLY public.userinteractionpresencedetaileddata USING btree (endtimeltc)
userinteractionpresencedetaileddata_orgpresence CREATE INDEX userinteractionpresencedetaileddata_orgpresence ON ONLY public.userinteractionpresencedetaileddata USING btree (orgpresence)
userinteractionpresencedetaileddata_routingstatus CREATE INDEX userinteractionpresencedetaileddata_routingstatus ON ONLY public.userinteractionpresencedetaileddata USING btree (routingstatus)
userinteractionpresencedetaileddata_systempresence CREATE INDEX userinteractionpresencedetaileddata_systempresence ON ONLY public.userinteractionpresencedetaileddata USING btree (systempresence)
userinteractionpresencedetaileddata_userid CREATE INDEX userinteractionpresencedetaileddata_userid ON ONLY public.userinteractionpresencedetaileddata USING btree (userid)