Note: Cannot modify product prices or inventory quantities
Inventory Management (Full CRUD)
Store ID:
Product ID:
Stock Quantity:
Store Management (Read, Update)
Store ID:
Store Type:
Order Tracking (Read Only)
Order ID:
Track orders to manage inventory requirements
Product Information (Read Only)
View product information for inventory management
View All Data (Read Only Access)
Suitable for analysts, auditors, and reporting personnel
Select Table to View:
Reports & Analytics
Data Export
Note: Cannot make any modifications to data
System Logs
Price History Log
Product ID
Old Price
New Price
Change Date
Admin User
No price changes recorded
Order Status Log
Order ID
Old Status
New Status
Change Date
No status changes recorded
Role Permissions
Admin: Full CRUD permissions on all tables. Can create, modify, and delete database objects. Complete database oversight.
Manager: Read and update permissions on most tables. Can manage inventory, update order statuses, and view reports. Cannot delete critical data.
Sales Staff: Can create and view customer orders, manage customer information. Read access to products and inventory. Cannot modify prices or inventory quantities.
Inventory Manager: Specialized role for inventory and stock control. Can update inventory levels, manage store stock. Read access to orders for inventory tracking.
Read Only: View-only access to all tables for reporting and analysis. Cannot make any changes. Suitable for analysts and auditors.