Point of Sale ER Diagram
SQL DDL Scripts
Purchase Point of Sale Data Model Pack
Help Docs

Legend:  TopTop  Open specification Open Entity specification

Jump to:

FK_Region_Country:Relationship FK_City_Region:Relationship FK_City_Time_Zone:Relationship FK_Store_City:Relationship FK_Holiday_Store:Relationship FK_Holiday_Holiday_Reason:Relationship FK_Store_Language:Relationship FK_Store_Currency:Relationship FK_Setting_Store:Relationship FK_Holiday_Start_Hour:Relationship FK_Holiday_End_Hour:Relationship FK_Employee_Store:Relationship FK_Media_Employee:Relationship FK_Employee_Role_Role_Type:Relationship FK_Employee_Role_Employee:Relationship FK_Role_Function_Role_Type:Relationship FK_Role_Function_Function_Type:Relationship FK_Employee_Login_Employee:Relationship FK_Employee_Login_Employee_Role:Relationship FK_Customer_City:Relationship FK_Order_Customer:Relationship FK_Order_Store:Relationship FK_Order_Status_History_Order:Relationship FK_Order_Sales_Channel:Relationship FK_Order_Delivery_Type:Relationship FK_Payment_Term_Sales_Channel:Relationship FK_Payment_Term_Delivery_Type:Relationship FK_Payment_Term_Payment_Method:Relationship FK_Order_Review_Customer:Relationship FK_Order_Review_Order:Relationship FK_Payment_Invoice:Relationship FK_Invoice_Order:Relationship FK_Order_Created_Emp_Login:Relationship FK_Order_Managed_Emp_Login:Relationship FK_Customer_Created_Emp_Login:Relationship FK_Payment_Term_Payment_Time:Relationship FK_Shipment_City:Relationship FK_Shipment_Order:Relationship FK_Price_Item:Relationship FK_Discount_Discount_Type:Relationship FK_Discount_Item:Relationship FK_Order_Line_Order:Relationship FK_Order_Line_Item:Relationship FK_Invoice_Line_Invoice:Relationship FK_Invoice_Line_Order_Line:Relationship FK_Item_Hour_End_Hour:Relationship FK_Item_Hour_Start_Hour:Relationship FK_Item_Hour_Week_Day:Relationship FK_Discount_Hour_Discount_Type:Relationship FK_Media_Created_Emp_Login:Relationship FK_Loyalty_Card_Customer:Relationship FK_Bar_Code_Item:Relationship FK_Item_Unit_Of_Measure:Relationship FK_Item_Supplier:Relationship FK_Item_Tax_Type_Item:Relationship FK_Item_Tax_Type_Tax_Type:Relationship FK_Media_Item:Relationship FK_Document_Document_Type:Relationship FK_Document_Employee_Login:Relationship FK_Order_Line_Discount_Discount:Relationship FK_Order_Line_Discount_Order_Line:Relationship FK_Order_Discount_Discount:Relationship FK_Order_Discount_Order:Relationship FK_Document_Type_Document_Category:Relationship FK_Document_Purchase:Relationship FK_Purchase_Supplier:Relationship FK_Stock_History_Item:Relationship FK_Stock_Return_Supplier:Relationship FK_Document_Stock_Return:Relationship FK_Inventory_Count_Item_Item:Relationship FK_Inventory_Count_Item_Inventory_Count:Relationship FK_Document_Inventory_Count:Relationship FK_Order_Loyalty_Card:Relationship FK_Discount_Type_Loyalty_Card_Type:Relationship FK_Payment_Payment_Method:Relationship FK_Sale_Return_Order:Relationship FK_Setting_Payment_Method:Relationship FK_Tax_Type_Store:Relationship FK_Setting_Tax_Type:Relationship FK_Media_Media_Type:Relationship FK_Price_Employee_Login:Relationship FK_Customer_Store:Relationship FK_Store_Admin_User:Relationship FK_Media_Store:Relationship FK_Employee_Role_Store:Relationship FK_Supplier_City:Relationship FK_Supplier_Store:Relationship FK_Supplier_Created_Emp_Login:Relationship FK_Item_Category_Item_Category:Relationship FK_Item_Item_Category:Relationship FK_Item_Store:Relationship FK_Price_Store:Relationship FK_Discount_Type_Store:Relationship FK_Discount_Item_Category:Relationship FK_Inventory_Count_Store:Relationship FK_Purchase_Store:Relationship FK_Stock_Return_Store:Relationship FK_Document_Loss_And_Damage:Relationship FK_Loss_And_Damage_Store:Relationship FK_Stock_History_Store:Relationship FK_Stock_History_Document:Relationship FK_Order_Status_History_Order_Status:Relationship FK_Order_Created_Customer:Relationship FK_Order_Approved_Emp_Login:Relationship FK_Order_Line_Store:Relationship FK_Shipment_Store:Relationship FK_Shipment_Emp_Login:Relationship FK_Sale_Return_Store:Relationship FK_Supplier_Tax_Type_Supplier:Relationship FK_Supplier_Item_Tax_Type_Item:Relationship FK_Supplier_Item_Tax_Type_Supplier_Tax_Type:Relationship FK_Document_Order:Relationship FK_Document_Store:Relationship FK_Loyalty_Card_Loyalty_Card_Type:Relationship FK_Loss_And_Damage_Item_Loss_And_Damage:Relationship FK_Loss_And_Damage_Item_Item:Relationship FK_Purchase_Item_Purchase:Relationship FK_Purchase_Item_Item:Relationship FK_Stock_Return_Item_Stock_Return:Relationship FK_Stock_Return_Item_Item:Relationship FK_Sale_Return_Item_Item:Relationship Sale_Return_Item_Order_Line:Relationship FK_Stock_Return_Purchase:Relationship FK_Sale_Return_Item_Sale_Return:Relationship FK_Document_Sale_Return:Relationship FK_Refund_Sale_Return:Relationship FK_Refund_Payment_Method:Relationship FK_Order_Payment_Time:Relationship FK_Order_Payment_Method:Relationship FK_Order_Review_Emp_Reply:Relationship Refund:Entity Sale_Return_Item:Entity Stock_Return_Item:Entity Purchase_Item:Entity Loss_And_Damage_Item:Entity Supplier_Item_Tax_Type:Entity Supplier_Tax_Type:Entity Loss_And_Damage:Entity Admin_User:Entity Sale_Return:Entity Loyalty_Card_Type:Entity Inventory_Count_Item:Entity Inventory_Count:Entity Stock_Return:Entity Purchase:Entity Document_Category:Entity Order_Discount:Entity Order_Line_Discount:Entity Document_Type:Entity Document:Entity Stock_History:Entity Item_Tax_Type:Entity Unit_Of_Measure:Entity Bar_Code:Entity Loyalty_Card:Entity Supplier:Entity Tax_Type:Entity Discount_Hour:Entity Week_Day:Entity Invoice_Line:Entity Order_Line:Entity Discount:Entity Discount_Type:Entity Price:Entity Item:Entity Item_Category:Entity Shipment:Entity Payment_Time:Entity Invoice:Entity Payment:Entity Payment_Term:Entity Payment_Method:Entity Delivery_Type:Entity Sales_Channel:Entity Order_Status_History:Entity Order_Status:Entity Order_Header:Entity Customer:Entity Employee_Login:Entity Role_Function:Entity Function_Type:Entity Employee_Role:Entity Role_Type:Entity Media:Entity Media_Type:Entity Order_Review:Entity Employee:Entity Hour:Entity Setting:Entity Currency:Entity Language:Entity Holiday:Entity Holiday_Reason:Entity Store:Entity Time_Zone:Entity City:Entity Region:Entity Country:Entity

Open in browser →

Help Docs →

SQL DDL Scripts →

All data models →

Point of Sale Data Model →

Point of Sale database schema design

Entities and Attributes

Navigate to each subject area of the Point of Sale database diagram to get powerful insights into entities and attributes — tables and columns.

Subject Areas Entities
CUSTOMER → 7 entities
STORE → 10 entities
ITEM → 8 entities
INVENTORY AND STOCK → 4 entities
PRICE AND DISCOUNT → 5 entities
ORDER → 13 entities
DOCUMENT → 16 entities
PAYMENT AND INVOICE → 4 entities
EMPLOYEE AND ROLE → 7 entities

Point of Sale database Help Docs

Understand your database schema and learn how the use cases are mapped to database tables and columns.

From our detailed documentation, you can learn about the features and technical design of Point of Sale database schema.

Read the Help Docs →

ER Diagram for Point of Sale | Point of Sale Entity Relationship Diagram | Point of Sale ER Diagram | Point of Sale database schema diagram | Point of Sale database diagram

Purchase the full version of the SQL scripts to create 100% of the database schema and benefit from priority customer support →

Accelerate every database schema design with powerful data models

We have already designed the data model and prepared the SQL scripts for creating the database schema objects.

Try Data Model Pack Free

Data Model Pack

Product

Resources

Support

© 2026 Data Model Pack · Terms of Use · Privacy

Back to top Top