2024 is the year of the connector - vote here

Knowledge base

Data Model Explorer

Our **Data Model Explorer** provides an _Entity Relationship Diagram_ (ERD) of your Lightspeed Retail (R-Series) data, allowing you to see the relationships between your different tables. ### Navigating 1. Drag tables around the workspace, by clicking and dragging anywhere on a table 1. Drag the entire workspace around by clicking and dragging the background 1. Minimize/maximize your workspace to take up your entire browser screen ### Relationships Relationships are depicted by the arrows running between table properties. For a tidier view, you may select the _Relationships Only_ checkbox, which will hide all the other columns which are not part of a relationship ### Endpoints - Category - Contact - Customer - Customer type - Discount - Employee - Inventory count - Inventory count item - Inventory log - Inventory transfer - Inventory transfer item - Item shop - Item price - Item tag - Item custom field value - Item - Item attribute set - Item custom field choice - Item custom field - Item matrix price - Item matrix - Item vendor - Manufacturer - Order - Order custom field - Order custom field choice - Order line - Order shipment item - Order shipment - Quote - Register - Sale - Sale line - Sale payment - Shop - Special order - Tag - Tax category - Vendor - Workorder - Workorder item - Workorder line - Workorder status - Order custom field value