public.divisiondetails

public.divisiondetails

Description

Columns

Name Type Default Nullable Children Parents Comment
id varchar(50) false
name varchar(50) true
homedivision varchar(50) true
updated timestamp without time zone true

Constraints

Name Type Definition
divisiondetails_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
divisiondetails_pkey CREATE UNIQUE INDEX divisiondetails_pkey ON public.divisiondetails USING btree (id)

    • Related Articles

    • public.vwqueuedetails

      Description See QueueDetails: Queue Lookup data Table Definition CREATE VIEW vwqueuedetails AS ( SELECT qd.id, qd.name, qd.description, "substring"((qd.description)::text, 'queuegroup=([^;]+)(;|$)'::text) AS queuegroup, ...

    • public.vwpresencedetails

      Description See PresenceDetails: Presence Code Lookup Data Table Definition CREATE VIEW vwpresencedetails AS ( SELECT pd.id, pd.systempresence, pd.orgpresence, pd.deactivated, pd.type, CASE WHEN ((pd.divisionid)::text = '*'::text) THEN dd.id ELSE ...

    • public.vwqueueconvrealtime

      Description See QueueConvRealTime: Queue Conversation Real-Time Data Table Definition CREATE VIEW vwqueueconvrealtime AS ( SELECT queuerealtimeconvdata.conversationid, queuerealtimeconvdata.media, queuerealtimeconvdata.actingas, ...

    • public.vwuserdetail

      Description See UserDetail: User Description in detail Table Definition CREATE VIEW vwuserdetail AS ( SELECT ud.id, ud.name, ud.jabberid, ud.state, ud.title, lower((ud.email)::text) AS email, ud.username, ud.department, ud.manager AS managerid, ...

    • public.vwuserpresencedatadaily

      Description See UserPresenceDataDaily - Expands all the GUIDs with their lookups(Daily) Table Definition CREATE VIEW vwuserpresencedatadaily AS ( SELECT userpresencedatadaily.id, userpresencedatadaily.userid, userdetail.name AS agentname, ...