ad_package_exp_detail

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_package_exp_detail_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 0 null
updated timestamp 29,6 now()
updatedby numeric 0 null
ad_form_id numeric 10 √ null
ad_form.ad_form_id adform_adpackageexpdetail R
ad_impformat_id numeric 10 √ null
ad_impformat.ad_impformat_id adimpformat_adpackageexpdetail R
ad_menu_id numeric 10 √ null
ad_menu.ad_menu_id admenu_adpackageexpdetail R
ad_process_id numeric 10 √ null
ad_process.ad_process_id adprocess_adpackageexpdetail R
ad_role_id numeric 10 √ null
ad_role.ad_role_id adrole_adpackageexpdetail R
ad_window_id numeric 10 √ null
ad_window.ad_window_id adwindow_adpackageexpdetail R
ad_workflow_id numeric 10 √ null
ad_workflow.ad_workflow_id adworkflow_adpackageexpdetail R
file_directory varchar 255 √ null
filename varchar 255 √ null
destination_filename varchar 255 √ null
destination_directory varchar 255 √ null
description varchar 1000 √ null
dbtype varchar 22 √ null
type varchar 10 null
target_directory varchar 255 √ null
sqlstatement varchar 4000 √ null
releaseno varchar 20 √ null
processing bpchar 1 null
processed bpchar 1 √ null
name2 varchar 60 √ null
line numeric 0 √ null
ad_workbench_id numeric 10 √ null
ad_workbench.ad_workbench_id adworkbench_adpackageexpdetail R
ad_table_id numeric 10 √ null
ad_table.ad_table_id adtable_adpackageexpdetail R
ad_reportview_id numeric 10 √ null
ad_reportview.ad_reportview_id adreportview_adpackageexpdetai R
ad_package_exp_id numeric 10 null
ad_package_exp.ad_package_exp_id adpackageexp_adpackageexpdetai R
ad_package_code_new varchar 2000 √ null
ad_package_code_old varchar 2000 √ null
ad_val_rule_id numeric 10 √ null
ad_val_rule.ad_val_rule_id advalrule_adpackageexpdetail R
ad_message_id numeric 10 √ null
ad_message.ad_message_id admessage_adpackageexpdetail R
ad_printformat_id numeric 10 √ null
ad_printformat.ad_printformat_id adprintformat_adpackageexpdeta R
ad_reference_id numeric 10 √ null
ad_reference.ad_reference_id adreference_adpackageexpdetail R
ad_modelvalidator_id numeric 10 √ NULL::numeric
ad_modelvalidator.ad_modelvalidator_id admodval_adpackageexpdetail R
ad_entitytype_id numeric 10 √ NULL::numeric
ad_entitytype.ad_entitytype_id adentitytype_adpackageexpdetai R
ad_package_exp_detail_uu varchar 36 √ NULL::character varying
ad_infowindow_id numeric 10 √ NULL::numeric
ad_infowindow.ad_infowindow_id adinfowindow_adpackageexpdetai R
execcode text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
ad_package_exp_detail_pkey Primary key Asc ad_package_exp_detail_id
ad_package_exp_detail_uu_idx Must be unique Asc ad_package_exp_detail_uu

Relationships

Close relationships within degrees of separation