public.divisiondetails

public.divisiondetails

Columns

Name Type Default Nullable Children Parents Comment
id varchar(50) false
name varchar(50) true
description text true Division Description
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.vwbudetails

      Description Business unit details Table Definition CREATE VIEW vwbudetails AS ( SELECT bu.id, bu.name, bu.updated, bu.divisionid AS division_id, dd.name AS division_name FROM (budetails bu LEFT JOIN divisiondetails dd ON (((dd.id)::text = ...

    • public.vwpresencedetails

      Description 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 pd.divisionid END AS ...

    • public.vwqueueconvrealtime

      Description Queue conversation real-time data Table Definition CREATE VIEW vwqueueconvrealtime AS ( SELECT queuerealtimeconvdata.conversationid, queuerealtimeconvdata.media, queuerealtimeconvdata.actingas, queuerealtimeconvdata.conversationstate, ...

    • public.vwcopilotlicensedusers

      Description Users with active Copilot licenses Table Definition CREATE VIEW vwcopilotlicensedusers AS ( SELECT l.userid, l.username, l.email, l.licenseid, l.licensename, l.licensetype, l.licenseassignmentdate, l.divisionid, l.updated, ud.name AS ...

    • public.vwflowoutcomedetails

      Description Normalized Flow Outcome Details (with division and user lookups) Table Definition CREATE VIEW vwflowoutcomedetails AS ( SELECT fod.id, fod.name, fod.description, fod.divisionid, dd.name AS divisionname, fod.operationid, CASE WHEN ...