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
- Drag tables around the workspace, by clicking and dragging anywhere on a table
- Drag the entire workspace around by clicking and dragging the background
- 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
- Credit account
- 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
- Credit account contact
- Order custom field value
- Sale note