ad_package_exp_common

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_package_exp_common_id numeric 10 null
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
ad_form_id numeric 10 √ null
ad_form.ad_form_id adform_adpackageexpcommon R
ad_impformat_id numeric 10 √ null
ad_impformat.ad_impformat_id adimpformat_adpackageexpcommon R
ad_reportview_id numeric 10 √ null
ad_reportview.ad_reportview_id adreportview_adpackageexpcommo R
ad_table_id numeric 10 √ null
ad_table.ad_table_id adtable_adpackageexpcommon R
ad_workbench_id numeric 10 √ null
ad_workbench.ad_workbench_id adworkbench_adpackageexpcommon R
dbtype varchar 22 √ null
processed bpchar 1 √ null
name varchar 60 √ null
name2 varchar 60 √ null
line numeric 0 √ null
file_directory varchar 255 √ null
filename varchar 255 √ null
destination_directory varchar 255 √ null
description varchar 1000 √ null
type varchar 10 √ null
target_directory varchar 255 √ null
sqlstatement varchar 255 √ null
processing bpchar 1 √ null
ad_workflow_id numeric 10 √ null
ad_workflow.ad_workflow_id adworkflow_adpackageexpcommon R
ad_window_id numeric 10 √ null
ad_window.ad_window_id adwindow_adpackageexpcommon R
ad_role_id numeric 10 √ null
ad_role.ad_role_id adrole_adpackageexpcommon R
ad_process_id numeric 10 √ null
ad_process.ad_process_id adprocess_adpackageexpcommon R
ad_menu_id numeric 10 √ null
ad_menu.ad_menu_id admenu_adpackageexpcommon R
ad_package_exp_common_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
ad_package_exp_common_pkey Primary key Asc ad_package_exp_common_id
ad_package_exp_common_uu_idx Must be unique Asc ad_package_exp_common_uu

Relationships

Close relationships within degrees of separation