21-09-26, 07:22 AM
[*]user_logs — Approx. 288,141 rows — History of events and users
[*]stock_item_logs — Approx. 253,754 rows — Inventory history
[*]user_actions — Approx. 130,982 rows — Individual user actions
[*]accounting_movements — Approx. 119,282 rows — Accounting movements and amounts
[*]stock_movements — Approx. 115,021 rows — Stock movements and valuation
[*]production_movements — Approx. 66,971 rows — Production activity
[*]stock_items — Approx. 43,083 rows — Stock, products, and prices
[*]accounting_registers — Approx. 40,101 rows — Accounting records
[*]orders — Approx. 36,824 rows — Orders and customer data
[*]invoices — Approx. 32,379 rows — Invoices
[*]third_party_users — Approx. 20,037 rows — Relationships between customers/suppliers and users
[*]Credentials — 32 users with username and password stored as a 40-character hexadecimal string, compatible with SHA-1 type hash
[*]Personal data — Names, surnames, phone numbers, emails, addresses, tax IDs (RUC), and employment information
[*]Customers and suppliers — 392 third parties; 289 phone numbers, 287 addresses, 250 tax IDs (RUC), and 62 non-empty emails
[*]Financial information — Accounting movements, invoices, receipts, amounts, withholdings, bank references, and check numbers
[*]Sales and collections — Orders, quotations, payment terms, prices, credit, customers, and deliveries
[*]Access and permissions — Roles, permissions by page/action, associations with plants and warehouses
[*]Audit — Hundreds of thousands of events and actions linked to users and dates
[*]Inventory and production — Stock, costs/prices, recipes, losses, production, warehouses, and transfers
[*]Employees — 189 records with names, positions, and employment dates
[*]Logistics — 567 deliveries with customer, phone, address, driver, and vehicle details; also license plates
[*]stock_item_logs — Approx. 253,754 rows — Inventory history
[*]user_actions — Approx. 130,982 rows — Individual user actions
[*]accounting_movements — Approx. 119,282 rows — Accounting movements and amounts
[*]stock_movements — Approx. 115,021 rows — Stock movements and valuation
[*]production_movements — Approx. 66,971 rows — Production activity
[*]stock_items — Approx. 43,083 rows — Stock, products, and prices
[*]accounting_registers — Approx. 40,101 rows — Accounting records
[*]orders — Approx. 36,824 rows — Orders and customer data
[*]invoices — Approx. 32,379 rows — Invoices
[*]third_party_users — Approx. 20,037 rows — Relationships between customers/suppliers and users
[*]Credentials — 32 users with username and password stored as a 40-character hexadecimal string, compatible with SHA-1 type hash
[*]Personal data — Names, surnames, phone numbers, emails, addresses, tax IDs (RUC), and employment information
[*]Customers and suppliers — 392 third parties; 289 phone numbers, 287 addresses, 250 tax IDs (RUC), and 62 non-empty emails
[*]Financial information — Accounting movements, invoices, receipts, amounts, withholdings, bank references, and check numbers
[*]Sales and collections — Orders, quotations, payment terms, prices, credit, customers, and deliveries
[*]Access and permissions — Roles, permissions by page/action, associations with plants and warehouses
[*]Audit — Hundreds of thousands of events and actions linked to users and dates
[*]Inventory and production — Stock, costs/prices, recipes, losses, production, warehouses, and transfers
[*]Employees — 189 records with names, positions, and employment dates
[*]Logistics — 567 deliveries with customer, phone, address, driver, and vehicle details; also license plates