IntentSQL Data Model
Database Schema
The tables and relationships available to IntentSQL when answering natural-language business questions.
How IntentSQL uses the schema
IntentSQL uses the available tables, columns, and relationships to understand which data is relevant to a business question and generate the appropriate SQL query.
categories
Table
Id
PK
Name
products
Table
Id
PK
Name
CategoryId
FK
Price
CostPrice
customers
Table
Id
PK
Name
Email
City
Country
orders
Table
Id
PK
CustomerId
FK
OrderDate
Status
order_items
Table
Id
PK
OrderId
FK
ProductId
FK
Quantity
UnitPrice
Schema Relationships
products.CategoryId
→
categories.Id
orders.CustomerId
→
customers.Id
order_items.OrderId
→
orders.Id
order_items.ProductId
→
products.Id
Ready to explore the data?
Ask IntentSQL a question or inspect the underlying records using the Data Explorer.