public.participantattributesdynamic

public.participantattributesdynamic

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(50) false
conversationid varchar(50) false
conversationstartdate timestamp without time zone false
conversationstartdateltc timestamp without time zone true
conversationenddate timestamp without time zone true
conversationenddateltc timestamp without time zone true
updated timestamp without time zone true

Constraints

Name Type Definition
participantattributesdynamic_new_pkey PRIMARY KEY PRIMARY KEY (keyid, conversationstartdate)

Indexes

Name Definition
participantattributesdynamic_new_pkey CREATE UNIQUE INDEX participantattributesdynamic_new_pkey ON ONLY public.participantattributesdynamic USING btree (keyid, conversationstartdate)
partattirbconv CREATE INDEX partattirbconv ON ONLY public.participantattributesdynamic USING btree (conversationid)
partattribend CREATE INDEX partattribend ON ONLY public.participantattributesdynamic USING btree (conversationenddate)
partattribendltc CREATE INDEX partattribendltc ON ONLY public.participantattributesdynamic USING btree (conversationenddateltc)
partattribstart CREATE INDEX partattribstart ON ONLY public.participantattributesdynamic USING btree (conversationstartdate)
partattribstartltc CREATE INDEX partattribstartltc ON ONLY public.participantattributesdynamic USING btree (conversationstartdateltc)