SchemaSpy Analysis of idempiere9.adempiereApplication Dictionary Generated by
Quality Systems & Solutions
Generated on 2021-12-25 14:45 +0100
Database Type: PostgreSQL - 9.6.24

XML Representation
Insertion Order Deletion Order

Table Children Parents Columns Rows Comments
ad_attribute 1 4 32 0 System Attribute
ad_attribute_value 1 6 0 AD_Attribute_Value
ad_column 9 7 56 25,432 Column in the table
ad_element 4 20 5,783 System Element enables the central maintenance of column description and help.
ad_field 1 10 57 20,329 Field on a database table
ad_fieldgroup 4 13 72 Logical grouping of fields
ad_indexcolumn 2 14 1,355 Index definition for column
ad_infocolumn 4 6 37 134 Info Column
ad_infoprocess 3 17 4 define process for info window
ad_inforelated 1 4 19 0 InfoRelated
ad_infowindow 6 2 30 11 Info Window
ad_language 3 22 109 Language ID
ad_message 2 14 1,886 System Message
ad_modelvalidator 15 3 Global Model Validator
ad_process 8 34 454 Process or Report
ad_process_para 1 6 38 1,145 Process Parameter
ad_ref_list 1 16 1,439 Reference List based on Table
ad_ref_table 6 18 223 Reference Table Definitions
ad_reference 20 1 17 553 System Reference (Pick List)
ad_relationtype 2 18 6 Defines the sets of record pairs (and the conditions a given pair must fulfill to be part of one)
ad_role 3 54 5 Responsibility Role
ad_rule 1 18 4 Rule
ad_searchdefinition 4 21 2 Search Definition
ad_statusline 1 1 13 4 Status Line
ad_statuslineusedin 4 16 13 AD_StatusLineUsedIn
ad_style 7 12 1 CSS style for field and label
ad_styleline 1 15 1 Style Line
ad_sysconfig 14 149 System Configurator
ad_tab 7 8 45 1,103 Tab within a Window
ad_tab_customization 1 15 0 Grid user customization
ad_table 12 3 32 1,029 Table for the Fields
ad_table_scriptvalidator 2 13 0 Script model validator for tables
ad_tableindex 1 2 20 1,072 Index definition for table
ad_toolbarbutton 2 26 74 ToolBar Button
ad_userdef_field 9 44 0 User defined Field
ad_userdef_info 2 3 19 0 User defined Info Window
ad_userdef_info_column 6 31 0 User defined Info Column
ad_userdef_info_related 2 16 0 User defined Info Related
ad_userdef_proc 1 3 17 0 Primary Key : User defined Process
ad_userdef_proc_parameter 6 32 0 Primary Key : User defined Process Parameter
ad_userdef_tab 1 3 25 0 User defined Tab
ad_userdef_win 1 3 19 0 User defined Window
ad_val_rule 12 14 308 Dynamic Validation Rule
ad_viewcolumn 1 17 17,283 Database View Column
ad_viewcomponent 1 2 20 215 Database View Component
ad_window 9 24 432 Data entry or display window
ad_zoomcondition 2 17 6 Zoom condition
           
47 Tables     1,102 80,639  
0 Views     0