Example: Grouping in Document

The "Orders" table serves as the core entity for recording order-related information. It includes columns such as registration number (Reg Number) for uniquely identifying each order, the number of related items, total amounts for food and drinks, grand total, and standard fields like ID and timestamps for tracking ownership and modifications. This table essentially captures the summary and financial aspects of each order placed within the system.

The "Items" table details the individual products or items included in each order recorded in the Orders table. It includes columns for product name, type, price, unit, quantity, amount, and references to the order registration number. Additional columns such as ID, record ownership, and timestamps are also present to maintain data integrity and track changes. This table enables the database to maintain a comprehensive list of all items associated with each order, facilitating detailed analysis and reporting.

The "Products" table stores master data related to the products available for ordering. It includes columns for product name, type, unit of measurement, price, and standard fields for tracking ownership and modifications. This table serves as a centralized repository for product information, ensuring consistency and accuracy across different orders and items.

The purpose of this database setup is to streamline the management of document-related data, specifically focusing on orders and their constituent items. By structuring data into these tables, the system enables efficient tracking, reporting, and analysis of orders placed, items included, and product details. It supports businesses and organizations in managing their inventory, tracking financial transactions, and providing insights into ordering patterns and preferences. This structured approach enhances operational efficiency and supports informed decision-making processes related to document handling within the context of orders and products.