ad_entitytype

35 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
entitytype varchar 40 'D'::character varying
ad_chart.entitytype entityt_adchart R
ad_chartdatasource.entitytype entityt_adchartdatasource R
ad_column.entitytype entityt_adcolumn R
ad_element.entitytype entityt_adelement R
ad_field.entitytype entityt_adfield R
ad_fieldgroup.entitytype entityt_adfieldgroup R
ad_form.entitytype entityt_adform R
ad_image.entitytype entityt_adimage R
ad_indexcolumn.entitytype entityt_adindexcolumn R
ad_infocolumn.entitytype entityt_adinfocolumn R
ad_infoprocess.entitytype entitytype_adinfoprocess R
ad_inforelated.entitytype entitytype_adinforelated R
ad_infowindow.entitytype entityt_adinfowindow R
ad_menu.entitytype entityt_admenu R
ad_message.entitytype entityt_admessage R
ad_modelvalidator.entitytype entityt_admodelvalidator R
ad_modification.entitytype adenritytype_admodification R
ad_process.entitytype entityt_adprocess R
ad_process_para.entitytype entityt_adprocesspara R
ad_ref_list.entitytype entityt_adreflist R
ad_ref_table.entitytype entityt_adreftable R
ad_reference.entitytype entityt_adreference R
ad_relationtype.entitytype entitytype_adrelationtype R
ad_replicationstrategy.entitytype entityt_adreplicationstrategy R
ad_replicationtable.entitytype entityt_adreplicationtable R
ad_reportview.entitytype entityt_adreportview R
ad_requiredplugin.entitytype entitytype_adrequiredplugin R
ad_rule.entitytype entityt_adrule R
ad_searchdefinition.entitytype entitytype_adsearchdefinition R
ad_statusline.entitytype entitytype_adstatusline R
ad_statuslineusedin.entitytype entitytype_adstatuslineusedin R
ad_style.entitytype entitytype_adstyle R
ad_styleline.entitytype entitytype_adstyleline R
ad_sysconfig.entitytype entityt_adsysconfig R
ad_tab.entitytype entityt_adtab R
ad_table.entitytype entityt_adtable R
ad_tableindex.entitytype entityt_adtableindex R
ad_task.entitytype entityt_adtask R
ad_toolbarbutton.entitytype entitytype_adtoolbarbutton R
ad_val_rule.entitytype entityt_advalrule R
ad_viewcolumn.entitytype entityt_adviewcolumn R
ad_viewcomponent.entitytype entityt_adviewcomponent R
ad_wf_nextcondition.entitytype entityt_adwfnextcondition R
ad_wf_node.entitytype entityt_adwfnode R
ad_wf_node_para.entitytype entityt_adwfnodepara R
ad_wf_nodenext.entitytype entityt_adwfnodenext R
ad_wf_responsible.entitytype entityt_adwfresponsible R
ad_window.entitytype entityt_adwindow R
ad_workbench.entitytype entityt_adworkbench R
ad_workbenchwindow.entitytype entityt_adworkbenchwindow R
ad_workflow.entitytype entityt_adworkflow R
ad_zoomcondition.entitytype entitytype_adzoomcondition R
pa_colorschema.entitytype entityt_pacolorschema R
pa_documentstatus.entitytype entitytype_padocumentstatus R
pa_measurecalc.entitytype entityt_pameasurecalc R
pp_order_node.entitytype entityt_ppordernode R
pp_order_nodenext.entitytype entityt_ppordernodenext R
pp_order_workflow.entitytype entityt_pporderworkflow R
pp_wf_node_product.entitytype entityt_ppwfnodeproduct R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
ad_entitytype_id numeric 10 null
ad_package_exp_detail.ad_entitytype_id adentitytype_adpackageexpdetai R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
name varchar 60 null
description varchar 255 √ null
help varchar 2000 √ null
version varchar 20 √ null
modelpackage varchar 255 √ null
classpath varchar 255 √ null
processing bpchar 1 √ null
ad_entitytype_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
ad_entitytype_pkey Primary key Asc entitytype
ad_entitytype_id_unq Must be unique Asc ad_entitytype_id
ad_entitytype_uu_idx Must be unique Asc ad_entitytype_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation