Shop Project - Documentation

language

Shop LDM (Logical Data Model)

The Shop LDM describes the modular database architecture of the system. Each module is independent but connected via foreign keys and shared entities. This keeps the system flexible, extensible, and multilingual.

🗺️ Stage 0 | 📚 Current | 📟 2026 06 15 | 📍 Database

Measurement Units: Grams (g) & Millimeters (mm)

Architectural Philosophy

The primary goal is to keep the database as lean as possible while providing a solid, high-performance foundation for a fully functional marketplace and catalog trading system. Physical segmentation is handled via dedicated SQL scripts within the project folder, building tables, views, and functions step by step.

Physical SQL Structure & Initialization Order

  • sql/00_funktion.sql – Global database functions and helper routines
  • sql/01_labels_tb.sql – Multilingual text labels and i18n control
  • sql/02_users_tb.sql – User accounts, master data, and authentication
  • sql/03_user_v_pr.sql – Views and stored procedures for user-specific data
  • sql/04_products_tb.sql – The central product-oriented collector database (catalog)
  • sql/04.1_trading.sql – The trading system (offers, merchant mappings, and conditions)
  • sql/04.2_pro_cat_set_views.sql – Complex aggregations for product categories and sets
  • sql/05_pages_tb.sql – CMS content, static pages, and dynamic navigation structures
  • sql/06_purchase_tb.sql – Shopping carts, orders, and transaction logs
  • sql/07_shipping_tb.sql – Logistics data, shipping zones, and shipping cost calculations
  • sql/08_tracking_tb.sql – Activity logs, status tracking, and system monitoring

Direct Links to LDM Components