| SchemaSpy Analysis of idempiere11.adempiereApplication Dictionary | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:46 +0100 | |
| Database Type: PostgreSQL - 15.5 (Ubuntu 15.5-1.pgdg22.04+1) |
|
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 | 11 | 9 | 63 | 25.928 | Column in the table |
| ad_element | 4 | 20 | 5.905 | System Element enables the central maintenance of column description and help. | |
| ad_field | 1 | 10 | 59 | 20.889 | Field on a database table |
| ad_fieldgroup | 4 | 13 | 77 | Logical grouping of fields | |
| ad_indexcolumn | 2 | 14 | 1.503 | Index definition for column | |
| ad_infocolumn | 4 | 6 | 41 | 189 | Info Column |
| ad_infoprocess | 3 | 17 | 11 | define process for info window | |
| ad_inforelated | 1 | 4 | 19 | 0 | Info Related |
| ad_infowindow | 8 | 4 | 32 | 16 | Info Window |
| ad_language | 4 | 22 | 109 | Language ID | |
| ad_message | 3 | 14 | 2.012 | System Message | |
| ad_modelgeneratortemplate | 15 | 0 | Model Generator Template | ||
| ad_modelvalidator | 15 | 3 | Global Model Validator | ||
| ad_process | 9 | 35 | 469 | Process or Report | |
| ad_process_drillrule | 2 | 3 | 18 | 0 | Drill Rule |
| ad_process_drillrule_para | 2 | 13 | 0 | Drill Rule Parameter | |
| ad_process_drillrule_trl | 2 | 13 | 0 | Drill Rule Trl | |
| ad_process_para | 3 | 6 | 40 | 1.186 | Process Parameter |
| ad_ref_list | 1 | 16 | 1.495 | Reference List based on Table | |
| ad_ref_table | 6 | 18 | 232 | Reference Table Definitions | |
| ad_reference | 20 | 1 | 18 | 582 | 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 | 56 | 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 | 5 | 17 | 13 | AD_StatusLineUsedIn | |
| ad_style | 7 | 13 | 1 | CSS style for field and label | |
| ad_styleline | 1 | 15 | 1 | Style Line | |
| ad_sysconfig | 14 | 181 | System Configurator | ||
| ad_tab | 7 | 8 | 47 | 1.133 | Tab within a Window |
| ad_tab_customization | 1 | 15 | 0 | Grid user customization | |
| ad_table | 15 | 3 | 35 | 1.052 | Table for the Fields |
| ad_table_scriptvalidator | 2 | 13 | 0 | Script model validator for tables | |
| ad_tableindex | 1 | 2 | 20 | 1.173 | Index definition for table |
| ad_tablepartition | 2 | 13 | 0 | Table Partition | |
| ad_toolbarbutton | 2 | 28 | 85 | ToolBar Button | |
| ad_userdef_field | 9 | 46 | 0 | User defined Field | |
| ad_userdef_info | 2 | 5 | 21 | 0 | User defined Info Window |
| ad_userdef_info_column | 6 | 32 | 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 | 27 | 0 | User defined Tab |
| ad_userdef_win | 1 | 3 | 19 | 0 | User defined Window |
| ad_val_rule | 12 | 14 | 329 | Dynamic Validation Rule | |
| ad_verifymigration | 2 | 21 | 0 | Verify Migration Helper | |
| ad_viewcolumn | 1 | 17 | 17.632 | Database View Column | |
| ad_viewcomponent | 1 | 2 | 21 | 229 | Database View Component |
| ad_window | 13 | 24 | 444 | Data entry or display window | |
| ad_zoomcondition | 2 | 17 | 7 | Zoom condition | |
| 53 Tables | 1.233 | 82.907 | |||
| 0 Views | 0 |