| 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 |