public.location_areacode_mapping
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
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 the User ...
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.vwuserlanguagemappings
Description User routing language assignments with user and division context Table Definition CREATE VIEW vwuserlanguagemappings AS ( SELECT (ulm.userid)::text AS user_id, (ud.name)::text AS user_name, (ud.divisionid)::text AS division_id, ...