TABLES
26
VIEWS
0
COLUMNS
184
Constraints
34
Anomalies
0
Routines
0
Database Properties
Database Type: MySQL - 5.5.5-10.4.32-MariaDB
Tables
| Table / View | Children | Parents | Columns | Type | Comments |
|---|---|---|---|---|---|
| laundry_addons | 1 | 0 | 7 | Table | |
| laundry_order_addons | 0 | 2 | 6 | Table | |
| daily_reports | 0 | 1 | 7 | Table | |
| delivery_status_history | 0 | 2 | 6 | Table | |
| cart_items | 0 | 2 | 6 | Table | |
| laundry_order_items | 0 | 2 | 6 | Table | |
| orders | 1 | 3 | 11 | Table | |
| laundry_status_history | 0 | 2 | 5 | Table | |
| product_categories | 1 | 0 | 4 | Table | |
| payments | 0 | 0 | 7 | Table | |
| pos_orders | 1 | 1 | 6 | Table | |
| stock_movements | 0 | 2 | 7 | Table | |
| user_devices | 0 | 1 | 4 | Table | |
| pos_order_items | 0 | 2 | 6 | Table | |
| laundry_items | 1 | 1 | 7 | Table | |
| order_items | 0 | 2 | 6 | Table | |
| product_stock | 0 | 2 | 5 | Table | |
| delivery_requests | 1 | 1 | 11 | Table | |
| products | 5 | 1 | 9 | Table | |
| roles | 1 | 0 | 5 | Table | |
| user_addresses | 2 | 1 | 7 | Table | |
| laundry_packages | 2 | 0 | 11 | Table | |
| laundry_orders | 3 | 4 | 15 | Table | |
| users | 14 | 1 | 9 | Table | |
| carts | 1 | 1 | 4 | Table | |
| invoices | 0 | 0 | 7 | Table |