SchemaSpy Analysis of idempiere9.adempiere - Columns2Pack Generated by
Quality Systems & Solutions
Generated on 2021-12-25 14:57 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere9.adempiere contains 214 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
ad_package_exp_detail createdby numeric 0 User who created this records
ad_package_exp_common line numeric 0  √  null Unique line for this document
ad_package_exp_detail line numeric 0  √  null Unique line for this document
ad_package_exp_detail updatedby numeric 0 User who updated this records
ad_package_imp_proc ad_override_dict bpchar 1  √  null Update System Maintained Application Dictionary
ad_package_exp ad_package_type varchar 1  √  null Package Type
ad_package_exp isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_package_exp_common isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_package_exp_detail isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_package_imp isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_package_imp_backup isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_package_imp_detail isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_package_imp_inst isactive bpchar 1  √  'Y'::bpchar The record is active in the system
ad_package_imp_proc isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_package_uuid_map isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_package_exp isexportdictionaryentity bpchar 1 'N'::bpchar Export Dictionary Entity
ad_package_exp processed bpchar 1  √  null The document has been processed
ad_package_exp_common processed bpchar 1  √  null The document has been processed
ad_package_exp_detail processed bpchar 1  √  null The document has been processed
ad_package_imp processed bpchar 1  √  'N'::bpchar The document has been processed
ad_package_imp_inst processed bpchar 1  √  'N'::bpchar The document has been processed
ad_package_exp processing bpchar 1 Process Now
ad_package_exp_common processing bpchar 1  √  null Process Now
ad_package_exp_detail processing bpchar 1 Process Now
ad_package_imp processing bpchar 1 'N'::bpchar Process Now
ad_package_imp_inst processing bpchar 1  √  'N'::bpchar Process Now
ad_package_imp_proc processing bpchar 1  √  null Process Now
ad_package_imp uninstall bpchar 1  √  null Uninstall
ad_package_imp_backup uninstall bpchar 1  √  null Uninstall
ad_package_imp_detail uninstall bpchar 1  √  null Uninstall
ad_package_imp_inst uninstall bpchar 1  √  null Uninstall
ad_package_imp_detail ad_backup_id numeric 10  √  null Backup
ad_package_exp ad_client_id numeric 10 Client/Tenant for this installation.
ad_package_exp_common ad_client_id numeric 10 Client/Tenant for this installation.
ad_package_exp_detail ad_client_id numeric 10 Client/Tenant for this installation.
ad_package_imp ad_client_id numeric 10 Client/Tenant for this installation.
ad_package_imp_backup ad_client_id numeric 10 Client/Tenant for this installation.
ad_package_imp_detail ad_client_id numeric 10 Client/Tenant for this installation.
ad_package_imp_inst ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_package_imp_proc ad_client_id numeric 10 Client/Tenant for this installation.
ad_package_uuid_map ad_client_id numeric 10 Client/Tenant for this installation.
ad_package_imp_backup ad_column_id numeric 10  √  null Column in the table
ad_package_exp_detail ad_entitytype_id numeric 10  √  NULL::numeric System Entity Type
ad_package_exp_common ad_form_id numeric 10  √  null Special Form
ad_package_exp_detail ad_form_id numeric 10  √  null Special Form
ad_package_exp_common ad_impformat_id numeric 10  √  null Import Format
ad_package_exp_detail ad_impformat_id numeric 10  √  null Import Format
ad_package_exp_detail ad_infowindow_id numeric 10  √  NULL::numeric Info and search/select Window
ad_package_exp_common ad_menu_id numeric 10  √  null Identifies a Menu
ad_package_exp_detail ad_menu_id numeric 10  √  null Identifies a Menu
ad_package_exp_detail ad_message_id numeric 10  √  null System Message
ad_package_exp_detail ad_modelvalidator_id numeric 10  √  NULL::numeric Model Validator
ad_package_exp ad_org_id numeric 10 Organizational entity within client
ad_package_exp_common ad_org_id numeric 10 Organizational entity within client
ad_package_exp_detail ad_org_id numeric 10 Organizational entity within client
ad_package_imp ad_org_id numeric 10 Organizational entity within client
ad_package_imp_backup ad_org_id numeric 10 Organizational entity within client
ad_package_imp_detail ad_org_id numeric 10 Organizational entity within client
ad_package_imp_inst ad_org_id numeric 10  √  null Organizational entity within client
ad_package_imp_proc ad_org_id numeric 10 Organizational entity within client
ad_package_uuid_map ad_org_id numeric 10 Organizational entity within client
ad_package_exp_common ad_package_exp_common_id numeric 10 Common Package Exp.
ad_package_exp_detail ad_package_exp_detail_id numeric 10 Package Exp. Detail
ad_package_exp ad_package_exp_id numeric 10 Package Exp.
ad_package_exp_detail ad_package_exp_id numeric 10 Package Exp.
ad_package_imp_backup ad_package_imp_backup_id numeric 10 Imp. Package Backup
ad_package_imp_backup ad_package_imp_detail_id numeric 10 Imp. Package Detail
ad_package_imp_detail ad_package_imp_detail_id numeric 10 Imp. Package Detail
ad_package_imp ad_package_imp_id numeric 10 Package Imp.
ad_package_imp_backup ad_package_imp_id numeric 10 Package Imp.
ad_package_imp_detail ad_package_imp_id numeric 10 Package Imp.
ad_package_imp_inst ad_package_imp_inst_id numeric 10 Package Imp. Inst.
ad_package_imp ad_package_imp_proc_id numeric 10  √  NULL::numeric Package Imp. Proc.
ad_package_imp_proc ad_package_imp_proc_id numeric 10 Package Imp. Proc.
ad_package_imp_proc ad_package_source_type varchar 10 Type of package source - file, ftp, webservice etc
ad_package_uuid_map ad_package_uuid_map_id numeric 10 UUID Mapping between client
ad_package_exp_detail ad_printformat_id numeric 10  √  null Data Print Format
ad_package_exp_common ad_process_id numeric 10  √  null Process or Report
ad_package_exp_detail ad_process_id numeric 10  √  null Process or Report
ad_package_exp_detail ad_reference_id numeric 10  √  null System Reference and Validation
ad_package_imp_backup ad_reference_id numeric 10  √  null System Reference and Validation
ad_package_exp_common ad_reportview_id numeric 10  √  null View used to generate this report
ad_package_exp_detail ad_reportview_id numeric 10  √  null View used to generate this report
ad_package_exp_common ad_role_id numeric 10  √  null Responsibility Role
ad_package_exp_detail ad_role_id numeric 10  √  null Responsibility Role
ad_package_exp_common ad_table_id numeric 10  √  null Database Table information
ad_package_exp_detail ad_table_id numeric 10  √  null Database Table information
ad_package_imp_backup ad_table_id numeric 10  √  null Database Table information
ad_package_imp_detail ad_table_id numeric 10  √  null Database Table information
ad_package_uuid_map ad_table_id numeric 10 Database Table information
ad_package_exp_detail ad_val_rule_id numeric 10  √  null Dynamic Validation Rule
ad_package_exp_common ad_window_id numeric 10  √  null Data entry or display window
ad_package_exp_detail ad_window_id numeric 10  √  null Data entry or display window
ad_package_exp_common ad_workbench_id numeric 10  √  null Collection of windows, reports
ad_package_exp_detail ad_workbench_id numeric 10  √  null Collection of windows, reports
ad_package_exp_common ad_workflow_id numeric 10  √  null Workflow or combination of tasks
ad_package_exp_detail ad_workflow_id numeric 10  √  null Workflow or combination of tasks
ad_package_exp createdby numeric 10 User who created this records
ad_package_exp_common createdby numeric 10 User who created this records
ad_package_imp createdby numeric 10 User who created this records
ad_package_imp_backup createdby numeric 10 User who created this records
ad_package_imp_detail createdby numeric 10 User who created this records
ad_package_imp_inst createdby numeric 10  √  null User who created this records
ad_package_imp_proc createdby numeric 10 User who created this records
ad_package_uuid_map createdby numeric 10 User who created this records
ad_package_imp_detail record_id numeric 10 Direct internal record ID
ad_package_exp_common type varchar 10  √  null Type of Validation (SQL, Java Script, Java Language)
ad_package_exp_detail type varchar 10 Type of Validation (SQL, Java Script, Java Language)
ad_package_exp updatedby numeric 10 User who updated this records
ad_package_exp_common updatedby numeric 10 User who updated this records
ad_package_imp updatedby numeric 10 User who updated this records
ad_package_imp_backup updatedby numeric 10 User who updated this records
ad_package_imp_detail updatedby numeric 10 User who updated this records
ad_package_imp_inst updatedby numeric 10  √  null User who updated this records
ad_package_imp_proc updatedby numeric 10 User who updated this records
ad_package_uuid_map updatedby numeric 10 User who updated this records
ad_package_imp_detail action varchar 20  √  null Indicates the Action to be performed
ad_package_exp pk_version varchar 20 Package Version
ad_package_imp pk_version varchar 20  √  null Package Version
ad_package_exp releaseno varchar 20  √  null Internal Release Number
ad_package_exp_detail releaseno varchar 20  √  null Internal Release Number
ad_package_imp releaseno varchar 20  √  null Internal Release Number
ad_package_imp_detail success varchar 20  √  null Success
ad_package_exp version varchar 20  √  null Version of the table definition
ad_package_imp version varchar 20  √  null Version of the table definition
ad_package_exp_common dbtype varchar 22  √  null DBType
ad_package_exp_detail dbtype varchar 22  √  null DBType
ad_package_imp pk_status varchar 22  √  null Package Status
ad_package_imp createddate varchar 25  √  null CreatedDate
ad_package_imp updateddate varchar 25  √  null UpdatedDate
ad_package_exp created timestamp 29,6 now() Date this record was created
ad_package_exp_common created timestamp 29,6 now() Date this record was created
ad_package_exp_detail created timestamp 29,6 now() Date this record was created
ad_package_imp created timestamp 29,6 now() Date this record was created
ad_package_imp_backup created timestamp 29,6 now() Date this record was created
ad_package_imp_detail created timestamp 29,6 now() Date this record was created
ad_package_imp_inst created timestamp 29,6 statement_timestamp() Date this record was created
ad_package_imp_proc created timestamp 29,6 now() Date this record was created
ad_package_uuid_map created timestamp 29,6 statement_timestamp() Date this record was created
ad_package_exp datefrom timestamp 29,6  √  null Starting date for a range
ad_package_imp_proc dateprocessed timestamp 29,6  √  null Date Processed
ad_package_exp updated timestamp 29,6 now() Date this record was updated
ad_package_exp_common updated timestamp 29,6 now() Date this record was updated
ad_package_exp_detail updated timestamp 29,6 now() Date this record was updated
ad_package_imp updated timestamp 29,6 now() Date this record was updated
ad_package_imp_backup updated timestamp 29,6 now() Date this record was updated
ad_package_imp_detail updated timestamp 29,6 now() Date this record was updated
ad_package_imp_inst updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_package_imp_proc updated timestamp 29,6 now() Date this record was updated
ad_package_uuid_map updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_package_exp email varchar 30  √  null Electronic Mail Address
ad_package_exp username varchar 30  √  null User Name
ad_package_exp_common ad_package_exp_common_uu varchar 36  √  NULL::character varying AD_Package_Exp_Common_UU
ad_package_exp_detail ad_package_exp_detail_uu varchar 36  √  NULL::character varying AD_Package_Exp_Detail_UU
ad_package_exp ad_package_exp_uu varchar 36  √  NULL::character varying AD_Package_Exp_UU
ad_package_imp_backup ad_package_imp_backup_uu varchar 36  √  NULL::character varying AD_Package_Imp_Backup_UU
ad_package_imp_detail ad_package_imp_detail_uu varchar 36  √  NULL::character varying AD_Package_Imp_Detail_UU
ad_package_imp_inst ad_package_imp_inst_uu varchar 36  √  NULL::character varying AD_Package_Imp_Inst_UU
ad_package_imp_proc ad_package_imp_proc_uu varchar 36  √  NULL::character varying AD_Package_Imp_Proc_UU
ad_package_imp ad_package_imp_uu varchar 36  √  NULL::character varying AD_Package_Imp_UU
ad_package_uuid_map ad_package_uuid_map_uu varchar 36 AD_Package_UUID_Map_UU
ad_package_uuid_map source_uuid varchar 36 UUID from the source client
ad_package_uuid_map target_uuid varchar 36 New UUID created by the pack in client
ad_package_imp_inst pk_version varchar 40  √  null Package Version
ad_package_imp_inst releaseno varchar 40  √  null Internal Release Number
ad_package_imp_inst version varchar 40  √  null Version of the table definition
ad_package_imp_inst pk_status varchar 44  √  null Package Status
ad_package_imp_inst createddate varchar 50  √  null CreatedDate
ad_package_imp_inst updateddate varchar 50  √  null UpdatedDate
ad_package_imp creator varchar 60  √  null Creator
ad_package_imp email varchar 60  √  null Electronic Mail Address
ad_package_exp name varchar 60 Alphanumeric identifier of the entity
ad_package_exp_common name varchar 60  √  null Alphanumeric identifier of the entity
ad_package_imp name varchar 60 Alphanumeric identifier of the entity
ad_package_imp_proc name varchar 60 Alphanumeric identifier of the entity
ad_package_exp_common name2 varchar 60  √  null Additional Name
ad_package_exp_detail name2 varchar 60  √  null Additional Name
ad_package_imp_detail tablename varchar 60  √  null Name of the table in the database
ad_package_imp_detail type varchar 60  √  null Type of Validation (SQL, Java Script, Java Language)
ad_package_imp_inst creator varchar 120  √  null Creator
ad_package_imp_inst email varchar 120  √  null Electronic Mail Address
ad_package_imp_inst name varchar 240  √  null Alphanumeric identifier of the entity
ad_package_imp_proc ad_package_dir varchar 255  √  null Package directory, default to AdempiereHome/packages
ad_package_imp_backup ad_package_imp_bck_dir varchar 255  √  null Package Imp. Bck. Directory
ad_package_imp_backup ad_package_imp_org_dir varchar 255  √  null Package Imp. Org. Dir.
ad_package_imp_proc ad_package_source varchar 255  √  null Fully qualified package source file name
ad_package_imp creatorcontact varchar 255  √  null CreatorContact
ad_package_exp_common destination_directory varchar 255  √  null Destination_Directory
ad_package_exp_detail destination_directory varchar 255  √  null Destination_Directory
ad_package_exp_detail destination_filename varchar 255  √  null Destination_FileName
ad_package_exp file_directory varchar 255  √  null File_Directory
ad_package_exp_common file_directory varchar 255  √  null File_Directory
ad_package_exp_detail file_directory varchar 255  √  null File_Directory
ad_package_exp_common filename varchar 255  √  null Name of the local file or URL
ad_package_exp_detail filename varchar 255  √  null Name of the local file or URL
ad_package_exp_common sqlstatement varchar 255  √  null SQL Expression/Statement
ad_package_exp_common target_directory varchar 255  √  null Target_Directory
ad_package_exp_detail target_directory varchar 255  √  null Target_Directory
ad_package_imp_inst creatorcontact varchar 510  √  null CreatorContact
ad_package_exp description varchar 1000  √  null Optional short description of the record
ad_package_exp_common description varchar 1000  √  null Optional short description of the record
ad_package_exp_detail description varchar 1000  √  null Optional short description of the record
ad_package_imp description varchar 1000  √  null Optional short description of the record
ad_package_exp instructions varchar 1000  √  null Instructions
ad_package_exp_detail ad_package_code_new varchar 2000  √  null New Package Code
ad_package_exp_detail ad_package_code_old varchar 2000  √  null Old Package Code
ad_package_imp_backup colvalue varchar 2000  √  null ColValue
ad_package_imp_inst description varchar 2000  √  null Optional short description of the record
ad_package_imp_detail name varchar 2000  √  null Alphanumeric identifier of the entity
ad_package_imp_proc p_msg varchar 2000  √  NULL::character varying Process Message
ad_package_exp_detail sqlstatement varchar 4000  √  null SQL Expression/Statement
ad_package_exp_detail execcode text 2147483647  √  null Execution Code
ad_package_imp_detail execcode text 2147483647  √  null Execution Code
ad_package_imp_detail result text 2147483647  √  null Result of the action taken