cof_entitytype_check

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

tablename

text

2147483647

√

null

record_id

numeric

10

√

null

entitytype

varchar

40

√

null

ad_entitytype.entitytype

Implied Constraint

R

Relationships

Close relationships within degrees of separation

One
One implied

View Definition

SELECT 'AD_InfoWindow'::text AS tablename,
    ad_infowindow.ad_infowindow_id AS record_id,
    ad_infowindow.entitytype
   FROM ad_infowindow
UNION
 SELECT 'AD_Modification'::text AS tablename,
    ad_modification.ad_modification_id AS record_id,
    ad_modification.entitytype
   FROM ad_modification
UNION
 SELECT 'AD_InfoColumn'::text AS tablename,
    ad_infocolumn.ad_infocolumn_id AS record_id,
    ad_infocolumn.entitytype
   FROM ad_infocolumn
UNION
 SELECT 'AD_SysConfig'::text AS tablename,
    ad_sysconfig.ad_sysconfig_id AS record_id,
    ad_sysconfig.entitytype
   FROM ad_sysconfig
UNION
 SELECT 'AD_Rule'::text AS tablename,
    ad_rule.ad_rule_id AS record_id,
    ad_rule.entitytype
   FROM ad_rule
UNION
 SELECT 'PA_ColorSchema'::text AS tablename,
    pa_colorschema.pa_colorschema_id AS record_id,
    pa_colorschema.entitytype
   FROM pa_colorschema
UNION
 SELECT 'AD_RelationType'::text AS tablename,
    ad_relationtype.ad_relationtype_id AS record_id,
    ad_relationtype.entitytype
   FROM ad_relationtype
UNION
 SELECT 'AD_TableIndex'::text AS tablename,
    ad_tableindex.ad_tableindex_id AS record_id,
    ad_tableindex.entitytype
   FROM ad_tableindex
UNION
 SELECT 'AD_IndexColumn'::text AS tablename,
    ad_indexcolumn.ad_indexcolumn_id AS record_id,
    ad_indexcolumn.entitytype
   FROM ad_indexcolumn
UNION
 SELECT 'AD_ViewComponent'::text AS tablename,
    ad_viewcomponent.ad_viewcomponent_id AS record_id,
    ad_viewcomponent.entitytype
   FROM ad_viewcomponent
UNION
 SELECT 'AD_ViewColumn'::text AS tablename,
    ad_viewcolumn.ad_viewcolumn_id AS record_id,
    ad_viewcolumn.entitytype
   FROM ad_viewcolumn
UNION
 SELECT 'AD_ToolBarButton'::text AS tablename,
    ad_toolbarbutton.ad_toolbarbutton_id AS record_id,
    ad_toolbarbutton.entitytype
   FROM ad_toolbarbutton
UNION
 SELECT 'AD_StatusLine'::text AS tablename,
    ad_statusline.ad_statusline_id AS record_id,
    ad_statusline.entitytype
   FROM ad_statusline
UNION
 SELECT 'AD_EntityType'::text AS tablename,
    ad_entitytype.ad_entitytype_id AS record_id,
    ad_entitytype.entitytype
   FROM ad_entitytype
UNION
 SELECT 'AD_InfoProcess'::text AS tablename,
    ad_infoprocess.ad_infoprocess_id AS record_id,
    ad_infoprocess.entitytype
   FROM ad_infoprocess
UNION
 SELECT 'AD_StatusLineUsedIn'::text AS tablename,
    ad_statuslineusedin.ad_statuslineusedin_id AS record_id,
    ad_statuslineusedin.entitytype
   FROM ad_statuslineusedin
UNION
 SELECT 'AD_ChartDatasource'::text AS tablename,
    ad_chartdatasource.ad_chartdatasource_id AS record_id,
    ad_chartdatasource.entitytype
   FROM ad_chartdatasource
UNION
 SELECT 'AD_Chart'::text AS tablename,
    ad_chart.ad_chart_id AS record_id,
    ad_chart.entitytype
   FROM ad_chart
UNION
 SELECT 'AD_Menu'::text AS tablename,
    ad_menu.ad_menu_id AS record_id,
    ad_menu.entitytype
   FROM ad_menu
UNION
 SELECT 'AD_Ref_Table'::text AS tablename,
    ad_ref_table.ad_reference_id AS record_id,
    ad_ref_table.entitytype
   FROM ad_ref_table
UNION
 SELECT 'AD_Element'::text AS tablename,
    ad_element.ad_element_id AS record_id,
    ad_element.entitytype
   FROM ad_element
UNION
 SELECT 'AD_Form'::text AS tablename,
    ad_form.ad_form_id AS record_id,
    ad_form.entitytype
   FROM ad_form
UNION
 SELECT 'AD_Workbench'::text AS tablename,
    ad_workbench.ad_workbench_id AS record_id,
    ad_workbench.entitytype
   FROM ad_workbench
UNION
 SELECT 'AD_Table'::text AS tablename,
    ad_table.ad_table_id AS record_id,
    ad_table.entitytype
   FROM ad_table
UNION
 SELECT 'AD_Column'::text AS tablename,
    ad_column.ad_column_id AS record_id,
    ad_column.entitytype
   FROM ad_column
UNION
 SELECT 'AD_Tab'::text AS tablename,
    ad_tab.ad_tab_id AS record_id,
    ad_tab.entitytype
   FROM ad_tab
UNION
 SELECT 'AD_Field'::text AS tablename,
    ad_field.ad_field_id AS record_id,
    ad_field.entitytype
   FROM ad_field
UNION
 SELECT 'AD_Val_Rule'::text AS tablename,
    ad_val_rule.ad_val_rule_id AS record_id,
    ad_val_rule.entitytype
   FROM ad_val_rule
UNION
 SELECT 'AD_WF_Node_Para'::text AS tablename,
    ad_wf_node_para.ad_wf_node_para_id AS record_id,
    ad_wf_node_para.entitytype
   FROM ad_wf_node_para
UNION
 SELECT 'AD_Process_Para'::text AS tablename,
    ad_process_para.ad_process_para_id AS record_id,
    ad_process_para.entitytype
   FROM ad_process_para
UNION
 SELECT 'AD_Workflow'::text AS tablename,
    ad_workflow.ad_workflow_id AS record_id,
    ad_workflow.entitytype
   FROM ad_workflow
UNION
 SELECT 'AD_ReplicationStrategy'::text AS tablename,
    ad_replicationstrategy.ad_replicationstrategy_id AS record_id,
    ad_replicationstrategy.entitytype
   FROM ad_replicationstrategy
UNION
 SELECT 'AD_ReplicationTable'::text AS tablename,
    ad_replicationtable.ad_replicationtable_id AS record_id,
    ad_replicationtable.entitytype
   FROM ad_replicationtable
UNION
 SELECT 'PP_Order_NodeNext'::text AS tablename,
    pp_order_nodenext.pp_order_nodenext_id AS record_id,
    pp_order_nodenext.entitytype
   FROM pp_order_nodenext
UNION
 SELECT 'PP_Order_Workflow'::text AS tablename,
    pp_order_workflow.pp_order_workflow_id AS record_id,
    pp_order_workflow.entitytype
   FROM pp_order_workflow
UNION
 SELECT 'AD_ModelValidator'::text AS tablename,
    ad_modelvalidator.ad_modelvalidator_id AS record_id,
    ad_modelvalidator.entitytype
   FROM ad_modelvalidator
UNION
 SELECT 'AD_FieldGroup'::text AS tablename,
    ad_fieldgroup.ad_fieldgroup_id AS record_id,
    ad_fieldgroup.entitytype
   FROM ad_fieldgroup
UNION
 SELECT 'AD_WF_Responsible'::text AS tablename,
    ad_wf_responsible.ad_wf_responsible_id AS record_id,
    ad_wf_responsible.entitytype
   FROM ad_wf_responsible
UNION
 SELECT 'AD_Ref_List'::text AS tablename,
    ad_ref_list.ad_ref_list_id AS record_id,
    ad_ref_list.entitytype
   FROM ad_ref_list
UNION
 SELECT 'AD_WF_NextCondition'::text AS tablename,
    ad_wf_nextcondition.ad_wf_nextcondition_id AS record_id,
    ad_wf_nextcondition.entitytype
   FROM ad_wf_nextcondition
UNION
 SELECT 'PP_Order_Node'::text AS tablename,
    pp_order_node.pp_order_node_id AS record_id,
    pp_order_node.entitytype
   FROM pp_order_node
UNION
 SELECT 'PP_WF_Node_Product'::text AS tablename,
    pp_wf_node_product.pp_wf_node_product_id AS record_id,
    pp_wf_node_product.entitytype
   FROM pp_wf_node_product
UNION
 SELECT 'AD_ReportView'::text AS tablename,
    ad_reportview.ad_reportview_id AS record_id,
    ad_reportview.entitytype
   FROM ad_reportview
UNION
 SELECT 'AD_Task'::text AS tablename,
    ad_task.ad_task_id AS record_id,
    ad_task.entitytype
   FROM ad_task
UNION
 SELECT 'AD_Reference'::text AS tablename,
    ad_reference.ad_reference_id AS record_id,
    ad_reference.entitytype
   FROM ad_reference
UNION
 SELECT 'AD_Window'::text AS tablename,
    ad_window.ad_window_id AS record_id,
    ad_window.entitytype
   FROM ad_window
UNION
 SELECT 'AD_Message'::text AS tablename,
    ad_message.ad_message_id AS record_id,
    ad_message.entitytype
   FROM ad_message
UNION
 SELECT 'AD_WorkbenchWindow'::text AS tablename,
    ad_workbenchwindow.ad_workbenchwindow_id AS record_id,
    ad_workbenchwindow.entitytype
   FROM ad_workbenchwindow
UNION
 SELECT 'AD_Process'::text AS tablename,
    ad_process.ad_process_id AS record_id,
    ad_process.entitytype
   FROM ad_process
UNION
 SELECT 'AD_WF_Node'::text AS tablename,
    ad_wf_node.ad_wf_node_id AS record_id,
    ad_wf_node.entitytype
   FROM ad_wf_node
UNION
 SELECT 'AD_WF_NodeNext'::text AS tablename,
    ad_wf_nodenext.ad_wf_nodenext_id AS record_id,
    ad_wf_nodenext.entitytype
   FROM ad_wf_nodenext
UNION
 SELECT 'AD_Image'::text AS tablename,
    ad_image.ad_image_id AS record_id,
    ad_image.entitytype
   FROM ad_image
UNION
 SELECT 'PA_MeasureCalc'::text AS tablename,
    pa_measurecalc.pa_measurecalc_id AS record_id,
    pa_measurecalc.entitytype
   FROM pa_measurecalc
UNION
 SELECT 'AD_InfoRelated'::text AS tablename,
    ad_inforelated.ad_inforelated_id AS record_id,
    ad_inforelated.entitytype
   FROM ad_inforelated;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views