ad_ctxhelp

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 null
ad_ctxhelp_id numeric 10 null
ad_ctxhelpmsg.ad_ctxhelp_id adctxhelp_adctxhelpmsg R
ad_ctxhelpsuggestion.ad_ctxhelp_id adctxhelp_adctxhelpsuggestion R
ad_form.ad_ctxhelp_id adctxhelp_adform R
ad_infowindow.ad_ctxhelp_id adctxhelp_adinfowindow R
ad_process.ad_ctxhelp_id adctxhelp_adprocess R
ad_tab.ad_ctxhelp_id adctxhelp_adtab R
ad_task.ad_ctxhelp_id adctxhelp_adtask R
ad_wf_node.ad_ctxhelp_id adctxhelp_adwfnode R
ad_workflow.ad_ctxhelp_id adctxhelp_adworkflow R
ad_ctxhelp_uu varchar 36 √ NULL::character varying
ad_form_id numeric 10 √ NULL::numeric
ad_form.ad_form_id Implied Constraint R
ad_org_id numeric 10 null
ad_process_id numeric 10 √ NULL::numeric
ad_process.ad_process_id Implied Constraint R
ad_tab_id numeric 10 √ NULL::numeric
ad_tab.ad_tab_id Implied Constraint R
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
ctxtype bpchar 1 √ null
description varchar 255 √ NULL::character varying
isactive bpchar 1 'Y'::bpchar
name varchar 120 null
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
ad_infowindow_id numeric 10 √ null
ad_infowindow.ad_infowindow_id Implied Constraint R
ad_workflow_id numeric 10 √ NULL::numeric
ad_workflow.ad_workflow_id Implied Constraint R
ad_task_id numeric 10 √ NULL::numeric
ad_task.ad_task_id Implied Constraint R
ad_table_id numeric 10 √ NULL::numeric
ad_table.ad_table_id Implied Constraint R

Indexes

Constraint Name Type Sort Column(s)
ad_ctxhelp_key Primary key Asc ad_ctxhelp_id
ad_ctxhelp_uu_idx Must be unique Asc ad_ctxhelp_uu

Check Constraints

Constraint Name Constraint
ad_ctxhelp_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation