public.location_areacode_mapping
Description
Columns
area_code |
varchar(10) |
|
false |
|
|
|
state |
varchar(255) |
|
true |
|
|
|
state_abbreviation |
varchar(10) |
|
true |
|
|
|
timezone |
varchar(10) |
|
true |
|
|
|
center_coordinates |
varchar(50) |
|
true |
|
|
|
country |
varchar(255) |
|
true |
|
|
|
short_country |
varchar(10) |
|
true |
|
|
|
latitude |
numeric(10,6) |
|
true |
|
|
|
longitude |
numeric(10,6) |
|
true |
|
|
|
Constraints
location_areacode_mapping_pkey |
PRIMARY KEY |
PRIMARY KEY (area_code) |
Indexes
location_areacode_mapping_pkey |
CREATE UNIQUE INDEX location_areacode_mapping_pkey ON
public.location_areacode_mapping USING btree (area_code) |
Related Articles
README
Logo Genesys Adapter Data Dictionary Tables Name Columns Comment Type public.tabledefinitions 5 Subscription Detailed Data BASE TABLE public.activeqmembersdata 9 Historical Active Membership of Queues BASE TABLE public.activitycodedetails 11 Activity ...
public.usergroupmappings
Description Columns Name Type Default Nullable Children Parents Comment id varchar(100) false Primary Key / Unique Identifier for User-Group Mapping name varchar(100) true Name of the User-Group Mapping userid varchar(50) true Unique Identifier for ...
public.vwusergroupmappings
Description Table Definition CREATE VIEW vwusergroupmappings AS ( SELECT ugm.id, ugm.name, ud.id AS user_id, ud.name AS user_name, ugm.groupid AS group_id, ugm.updated FROM (usergroupmappings ugm JOIN userdetails ud ON (((ugm.userid)::text = ...
public.vwuserskillmappings
Description View combining user-skill mappings with detailed user information (including manager, division, and division name) and corresponding skill details Table Definition CREATE VIEW vwuserskillmappings AS ( SELECT usm.keyid, usm.userid, ud.name ...
public.participantattributesdynamic
Description 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 ...