| SchemaSpy Analysis of idempiere11.adempierePOS | Generated by Quality Systems & Solutions |
| Generated on 2024-01-03 13:53 +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_printcolor | 2 | 12 | 23 | Color used for printing and display | |
| ad_user | 5 | 3 | 69 | 9 | User within the system - Internal or Business Partner Contact |
| c_bpartner | 4 | 4 | 74 | 18 | Identifies a Business Partner |
| c_doctype | 6 | 4 | 42 | 52 | Document type or rules |
| c_payment | 2 | 4 | 102 | 2 | Payment identifier |
| c_pos | 8 | 26 | 1 | Point of Sales Terminal | |
| c_poskey | 4 | 22 | 163 | POS Function Key | |
| c_poskeylayout | 5 | 1 | 16 | 5 | POS Function Key Layout |
| m_pricelist | 4 | 1 | 20 | 4 | Unique identifier of a Price List |
| m_product | 1 | 1 | 72 | 55 | Product Service Item |
| m_warehouse | 2 | 1 | 19 | 11 | Storage Warehouse and Service Point |
| 11 Tables | 474 | 343 | |||
| 0 Views | 0 |