public.skilldetails

public.skilldetails

Columns

Name Type Default Nullable Children Parents Comment
id varchar(50) false
name varchar(50) true
state varchar(50) true
updated timestamp without time zone true

Constraints

Name Type Definition
skilldetails_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
skilldetails_pkey CREATE UNIQUE INDEX skilldetails_pkey ON public.skilldetails USING btree (id)

    • Related Articles

    • public.vwskillmemberdata

      Description Contains data on skill mappings for users Table Definition CREATE VIEW vwskillmemberdata AS ( SELECT sm.userid, ud.name AS user_name, sd.name AS skill_name, sm.proficiency, sm.state FROM ((userskillmappings sm LEFT JOIN vwuserdetail ud ON ...

    • 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.vwqueueconvrealtime

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

    • public.vwrealtimequeueconv

      Description Real-time queue conversation data Table Definition CREATE VIEW vwrealtimequeueconv AS ( SELECT qc.conversationid, qc.media, qc.actingas, datediff('second'::text, qc.startdate, timezone('utc'::text, now())) AS statussecs, ...

    • public.evalquestiondata

      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 score ...