ad_process

982 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_process_id numeric 10 null
ad_archive.ad_process_id adprocess_adarchive R
ad_column.ad_process_id adprocess_adcolumn N
ad_infoprocess.ad_process_id adprocess_adinfoprocess R
ad_infowindow.ad_process_id adprocess_adinfowindow R
ad_issue.ad_process_id adprocess_adissue N
ad_menu.ad_process_id adprocess_admenu R
ad_package_exp_common.ad_process_id adprocess_adpackageexpcommon R
ad_package_exp_detail.ad_process_id adprocess_adpackageexpdetail R
ad_pinstance.ad_process_id adprocess_adpinstance R
ad_preference.ad_process_id ad_process_preference R
ad_printformat.jasperprocess_id jasperprocess_adprintformat R
ad_process_access.ad_process_id adprocess_adprocessaccess C
ad_process_drillrule.ad_process_id adprocess_addrillrule R
ad_process_para.ad_process_id adprocess_adprocesspara C
ad_process_trl.ad_process_id ad_process_ad_process_trl C
ad_scheduler.ad_process_id adprocess_adscheduler C
ad_tab.ad_process_id adprocess_adtab R
ad_toolbarbutton.ad_process_id adprocess_adtoolbarbutton R
ad_toolbarbuttonrestrict.ad_process_id adprocess_adtoolbarbuttonrestr R
ad_userdef_proc.ad_process_id adprocess_aduserdefproc R
ad_userdef_tab.ad_process_id adprocess_aduserdeftab R
ad_wf_node.ad_process_id adprocess_adwfnode R
ad_workbenchwindow.ad_process_id adprocess_adworkbenchwindow R
asp_clientexception.ad_process_id adprocess_aspclientexception R
asp_process.ad_process_id adprocess_aspprocess R
pa_dashboardcontent.ad_process_id adprocess_padashboardcontent R
pa_documentstatus.ad_process_id adprocess_padocumentstatus R
pa_report.jasperprocess_id jasperprocess_pareport R
pp_order_node.ad_process_id adprocess_ppordernode R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
value varchar 40 null
name varchar 60 null
description varchar 255 √ null
help varchar 2000 √ null
accesslevel bpchar 1 null
entitytype varchar 40 'D'::character varying
ad_entitytype.entitytype entityt_adprocess R
procedurename varchar 60 √ null
isreport bpchar 1 'Y'::bpchar
isdirectprint bpchar 1 √ 'N'::bpchar
ad_reportview_id numeric 10 √ null
ad_reportview.ad_reportview_id adreportview_adprocess R
classname varchar 255 √ null
statistic_count numeric 10 √ null
statistic_seconds numeric 0 √ null
ad_printformat_id numeric 10 √ null
ad_printformat.ad_printformat_id adprintformat_adprocess R
workflowvalue varchar 40 √ null
ad_workflow_id numeric 10 √ null
ad_workflow.ad_workflow_id adworkflow_adprocess R
isbetafunctionality bpchar 1 'N'::bpchar
isserverprocess bpchar 1 √ null
showhelp bpchar 1 √ 'Y'::bpchar
jasperreport varchar 255 √ null
ad_form_id numeric 10 √ null
ad_form.ad_form_id adform_adprocess R
copyfromprocess bpchar 1 √ NULL::bpchar
ad_process_uu varchar 36 √ NULL::character varying
ad_ctxhelp_id numeric 10 √ NULL::numeric
ad_ctxhelp.ad_ctxhelp_id adctxhelp_adprocess R
executiontype bpchar 1 √ NULL::bpchar
allowmultipleexecution varchar 2 'P'::character varying
filenamepattern varchar 255 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
ad_process_pkey Primary key Asc ad_process_id
ad_process_uu_idx Must be unique Asc ad_process_uu

Check Constraints

Constraint Name Constraint
ad_process_isdirectprint_check ((isdirectprint = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_process_isreport_check ((isreport = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_process_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation