Table idempiere9.adempiere.ad_package_exp_detail
Package Exp. Detail

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_package_exp_detail_id numeric 10 Package Exp. Detail
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 0 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 0 User who updated this records
ad_form_id numeric 10  √  null
ad_form.ad_form_id adform_adpackageexpdetail R
Special Form
ad_impformat_id numeric 10  √  null
ad_impformat.ad_impformat_id adimpformat_adpackageexpdetail R
Import Format
ad_menu_id numeric 10  √  null
ad_menu.ad_menu_id admenu_adpackageexpdetail R
Identifies a Menu
ad_process_id numeric 10  √  null
ad_process.ad_process_id adprocess_adpackageexpdetail R
Process or Report
ad_role_id numeric 10  √  null
ad_role.ad_role_id adrole_adpackageexpdetail R
Responsibility Role
ad_window_id numeric 10  √  null
ad_window.ad_window_id adwindow_adpackageexpdetail R
Data entry or display window
ad_workflow_id numeric 10  √  null
ad_workflow.ad_workflow_id adworkflow_adpackageexpdetail R
Workflow or combination of tasks
file_directory varchar 255  √  null File_Directory
filename varchar 255  √  null Name of the local file or URL
destination_filename varchar 255  √  null Destination_FileName
destination_directory varchar 255  √  null Destination_Directory
description varchar 1000  √  null Optional short description of the record
dbtype varchar 22  √  null DBType
type varchar 10 Type of Validation (SQL, Java Script, Java Language)
target_directory varchar 255  √  null Target_Directory
sqlstatement varchar 4000  √  null SQL Expression/Statement
releaseno varchar 20  √  null Internal Release Number
processing bpchar 1 Process Now
processed bpchar 1  √  null The document has been processed
name2 varchar 60  √  null Additional Name
line numeric 0  √  null Unique line for this document
ad_workbench_id numeric 10  √  null
ad_workbench.ad_workbench_id adworkbench_adpackageexpdetail R
Collection of windows, reports
ad_table_id numeric 10  √  null
ad_table.ad_table_id adtable_adpackageexpdetail R
Database Table information
ad_reportview_id numeric 10  √  null
ad_reportview.ad_reportview_id adreportview_adpackageexpdetai R
View used to generate this report
ad_package_exp_id numeric 10
ad_package_exp.ad_package_exp_id adpackageexp_adpackageexpdetai R
Package Exp.
ad_package_code_new varchar 2000  √  null New Package Code
ad_package_code_old varchar 2000  √  null Old Package Code
ad_val_rule_id numeric 10  √  null
ad_val_rule.ad_val_rule_id advalrule_adpackageexpdetail R
Dynamic Validation Rule
ad_message_id numeric 10  √  null
ad_message.ad_message_id admessage_adpackageexpdetail R
System Message
ad_printformat_id numeric 10  √  null
ad_printformat.ad_printformat_id adprintformat_adpackageexpdeta R
Data Print Format
ad_reference_id numeric 10  √  null
ad_reference.ad_reference_id adreference_adpackageexpdetail R
System Reference and Validation
ad_modelvalidator_id numeric 10  √  NULL::numeric
ad_modelvalidator.ad_modelvalidator_id admodval_adpackageexpdetail R
Model Validator
ad_entitytype_id numeric 10  √  NULL::numeric
ad_entitytype.ad_entitytype_id adentitytype_adpackageexpdetai R
System Entity Type
ad_package_exp_detail_uu varchar 36  √  NULL::character varying AD_Package_Exp_Detail_UU
ad_infowindow_id numeric 10  √  NULL::numeric
ad_infowindow.ad_infowindow_id adinfowindow_adpackageexpdetai R
Info and search/select Window
execcode text 2147483647  √  null Execution Code

Table contained 0 rows at 2021-12-25 14:43 +0100

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


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.