| SchemaSpy Analysis of testdb.public | Generated by SchemaSpy |
| Generated by SchemaSpy on Mon Aug 21 16:18 UTC 2023 | |
| Database Type: PostgreSQL - 12.3 |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| wms_inv_load_unit | 1 | 3 | 18 | 0 | |
| wms_inv_load_unit_log | 1 | 17 | 2 | ||
| wms_inv_load_unit_type | 1 | 19 | 0 | ||
| wms_inv_location | 3 | 27 | 0 | ||
| wms_inv_location_log | 1 | 28 | 0 | ||
| wms_inv_packaging_unit | 3 | 5 | 31 | 0 | |
| wms_inv_packaging_unit_detail | 1 | 3 | 0 | ||
| wms_inv_packaging_unit_detail_log | 1 | 5 | 0 | ||
| wms_inv_packaging_unit_log | 1 | 32 | 3 | ||
| wms_inv_product | 6 | 1 | 26 | 0 | |
| wms_inv_product_detail | 1 | 3 | 0 | ||
| wms_inv_product_log | 1 | 27 | 0 | ||
| wms_inv_product_stacking_rule | 2 | 10 | 0 | ||
| wms_inv_product_unit | 2 | 1 | 17 | 0 | |
| wms_inv_product_unit_detail | 1 | 3 | 0 | ||
| wms_inv_product_unit_detail_log | 1 | 5 | 0 | ||
| wms_inv_product_unit_log | 1 | 18 | 0 | ||
| wms_inv_reservation | 1 | 12 | 0 | ||
| wms_inv_reservation_log | 1 | 13 | 0 | ||
| wms_inv_revision | 8 | 4 | 3 | ||
| wms_inv_transport_unit | 1 | 1 | 21 | 0 | |
| 21 Tables | 339 | 8 | |||
| 0 Views | 0 |