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.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 ...
public.evalquestiondata
Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false evaluationid varchar(50) false evaluationformid varchar(50) false questiongroupid varchar(50) true questionid varchar(50) true answerid varchar(50) true ...