| SchemaSpy Analysis of idempiere11.adempiereAccess and Security | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:45 +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_attachment | 1 | 16 | 1 | Attachment for the document | |
| ad_authorizationaccount | 2 | 22 | 0 | Authorization Account | |
| ad_authorizationcredential | 1 | 1 | 16 | 0 | Authorization Credential |
| ad_authorizationprovider | 2 | 16 | 2 | Authorization Provider | |
| ad_authorizationscopeprov | 1 | 12 | 3 | Authorization Scope Provider | |
| ad_changelog | 3 | 22 | 0 | Log of data changes | |
| ad_column | 3 | 3 | 63 | 25.928 | Column in the table |
| ad_column_access | 3 | 13 | 0 | AD_Column_Access | |
| ad_document_action_access | 1 | 11 | 2.156 | Define access to document type / document action / role combinations. | |
| ad_form | 2 | 19 | 49 | Special Form | |
| ad_form_access | 2 | 11 | 131 | AD_Form_Access | |
| ad_importtemplateaccess | 4 | 14 | 0 | Import Template Access | |
| ad_infowindow_access | 1 | 10 | 51 | Info Window Access | |
| ad_ldapaccess | 1 | 15 | 0 | Ldap Access Log | |
| ad_ldapprocessorlog | 16 | 0 | LDAP Server Log | ||
| ad_org | 20 | 13 | 10 | Organizational entity within client | |
| ad_password_history | 4 | 13 | 0 | Password History ID | |
| ad_passwordrule | 27 | 0 | Password Policies | ||
| ad_private_access | 2 | 11 | 0 | AD_Private_Access | |
| ad_process | 3 | 2 | 35 | 469 | Process or Report |
| ad_process_access | 3 | 11 | 1.290 | Process Access | |
| ad_record_access | 2 | 14 | 0 | AD_Record_Access | |
| ad_role | 17 | 4 | 56 | 5 | Responsibility Role |
| ad_role_included | 2 | 11 | 0 | Included Role | |
| ad_role_orgaccess | 2 | 10 | 18 | AD_Role_OrgAccess | |
| ad_session | 1 | 1 | 17 | 0 | User Session Online or Web |
| ad_table | 9 | 3 | 35 | 1.052 | Table for the Fields |
| ad_table_access | 3 | 15 | 1 | AD_Table_Access | |
| ad_task | 1 | 1 | 17 | 3 | Operation System Task |
| ad_task_access | 3 | 11 | 3 | AD_Task_Access | |
| ad_toolbarbuttonrestrict | 3 | 16 | 0 | ToolBar Button Restrict | |
| ad_tree | 2 | 2 | 20 | 23 | Identifies a Tree |
| ad_user | 19 | 5 | 69 | 9 | User within the system - Internal or Business Partner Contact |
| ad_user_orgaccess | 2 | 10 | 0 | AD_User_OrgAccess | |
| ad_user_roles | 3 | 10 | 11 | AD_User_Roles | |
| ad_window | 4 | 1 | 24 | 444 | Data entry or display window |
| ad_window_access | 3 | 11 | 1.257 | AD_Window_Access | |
| ad_workflow | 1 | 2 | 48 | 57 | Workflow or combination of tasks |
| c_bpartner | 2 | 4 | 74 | 18 | Identifies a Business Partner |
| mfa_method | 2 | 21 | 2 | Multi-factor Authentication Method | |
| mfa_registereddevice | 1 | 13 | 0 | Multi-factor Authentication Registered Device | |
| mfa_registration | 2 | 24 | 0 | Multi-factor Authentication Registration | |
| mfa_rule | 1 | 11 | 2 | Multi-factor Authentication Rule | |
| pa_dashboardcontent_access | 5 | 12 | 2 | PA_DashboardContent_Access_ID | |
| sso_principalconfig | 20 | 0 | SSO Configuration | ||
| 45 Tables | 955 | 32.997 | |||
| 0 Views | 0 |