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
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.mvwconvvoiceoverviewdata
Description Columns Name Type Default Nullable Children Parents Comment conversationid varchar(50) false sentimentscore numeric(20,2) true sentimenttrend numeric(20,2) true agentdurationpercentage numeric(20,2) true customerdurationpercentage ...
public.mvwconvvoicesentimentdetaildata
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) true starttime timestamp without time zone true starttimeltc timestamp without time zone true duration numeric(20,2) true ...