Shop Project - Documentation
Logical Data Model (Text Version)
The Shop LDM (Logical Data Model) describes the system's modular database architecture. The database is divided into 8 color-coded sections, each representing a specific functional area. Each module is independent but connected through foreign keys and shared entities (e.g., user, article, category).
This keeps the system flexible, extensible, and multilingual. I try to keep the database lean yet solidly structured for a fully functional shop.
Measurement Units: Grams (g) & Millimeters (mm)
Database Modules in Detail
Select a specific module to view its detailed table structure, field descriptions, and relational connections:
- Basics & Global Functions – Fundamentals of the table architecture
- Module: Labels – Translations and localization texts
- Module: Users – User accounts, authentication, and master data
- User Views & Procs – Database-side user evaluations
- Module: Products – Article master data, stock, and variants
- Module: Trading – Marketplace logic and merchant interactions
- Product-Category Views – Complex queries for the catalog
- Module: Pages – CMS content and static pages
- Module: Purchases (Orders) – Carts, orders, and transactions
- Module: Shipping – Logistics providers, shipping costs, and delivery status
- Module: Tracking – Shipment tracking and log entries