agentic-engineers.dev
#01 Claude Code Team Mode
Build Detail
Quality
Features
Schema
Schema
#01 Claude Code Team Mode
Schema
agent-claude-team · v2.1.39
Database Schema (ER Diagram)
42 tables - SQLite
100%
Full-screen
Core / Auth
Products & Inventory
Customers
Orders & Payments
Shipping / Content / Apps
organizations
🔑 id
PK
· name
varchar
· billing_email
varchar
users
🔑 id
PK
· name
varchar
· email
varchar
· status
varchar
store_users
→ store_id
FK
→ user_id
FK
· role
varchar
store_settings
🔑 store_id
PK/FK
· settings_json
text
store_domains
🔑 id
PK
→ store_id
FK
· hostname
varchar
· type
varchar
· is_primary
bool
stores
🔑 id
PK
→ organization_id
FK
· name
varchar
· handle
varchar
· status
varchar
· default_currency
varchar
· timezone
varchar
products
🔑 id
PK
→ store_id
FK
· title
varchar
· handle
varchar
· status
varchar
· vendor
varchar
· product_type
varchar
product_variants
🔑 id
PK
→ product_id
FK
· sku
varchar
· price_amount
int
· compare_at_amount
int
· is_default
bool
· status
varchar
product_options
🔑 id
PK
→ product_id
FK
· name
varchar
· position
int
product_option_values
🔑 id
PK
→ product_option_id
FK
· value
varchar
· position
int
variant_option_values
→ variant_id
FK
→ product_option_value_id
FK
product_media
🔑 id
PK
→ product_id
FK
· type
varchar
· storage_key
varchar
· alt_text
varchar
inventory_items
🔑 id
PK
→ store_id
FK
→ variant_id
FK
· quantity_on_hand
int
· quantity_reserved
int
· policy
varchar
collections
🔑 id
PK
→ store_id
FK
· title
varchar
· handle
varchar
· type
varchar
collection_products
→ collection_id
FK
→ product_id
FK
· position
int
customers
🔑 id
PK
→ store_id
FK
· email
varchar
· first_name
varchar
· last_name
varchar
· accepts_marketing
bool
customer_addresses
🔑 id
PK
→ customer_id
FK
· address1
varchar
· city
varchar
· country_code
varchar
· is_default
bool
carts
🔑 id
PK
→ store_id
FK
→ customer_id
FK
· currency
varchar
· status
varchar
cart_lines
🔑 id
PK
→ cart_id
FK
→ variant_id
FK
· quantity
int
· line_total_amount
int
checkouts
🔑 id
PK
→ store_id
FK
→ cart_id
FK
→ customer_id
FK
· status
varchar
· email
varchar
· shipping_amount
int
discounts
🔑 id
PK
→ store_id
FK
· code
varchar
· type
varchar
· value_type
varchar
· value_amount
int
· status
varchar
orders
🔑 id
PK
→ store_id
FK
→ customer_id
FK
· order_number
varchar
· status
varchar
· financial_status
varchar
· fulfillment_status
varchar
· total_amount
int
order_lines
🔑 id
PK
→ order_id
FK
→ product_id
FK
→ variant_id
FK
· quantity
int
· total_amount
int
payments
🔑 id
PK
→ order_id
FK
· method
varchar
· status
varchar
· amount
int
refunds
🔑 id
PK
→ order_id
FK
→ payment_id
FK
· amount
int
· status
varchar
fulfillments
🔑 id
PK
→ order_id
FK
· status
varchar
· tracking_number
varchar
· tracking_company
varchar
fulfillment_lines
🔑 id
PK
→ fulfillment_id
FK
→ order_line_id
FK
· quantity
int
shipping_zones
🔑 id
PK
→ store_id
FK
· name
varchar
· countries_json
text
shipping_rates
🔑 id
PK
→ zone_id
FK
· name
varchar
· type
varchar
tax_settings
🔑 store_id
PK/FK
· mode
varchar
· tax_rate_basis_points
int
· prices_include_tax
bool
themes
🔑 id
PK
→ store_id
FK
· name
varchar
· status
varchar
theme_files
🔑 id
PK
→ theme_id
FK
· path
varchar
· sha256
varchar
theme_settings
🔑 theme_id
PK/FK
· settings_json
text
pages
🔑 id
PK
→ store_id
FK
· title
varchar
· handle
varchar
· status
varchar
navigation_menus
🔑 id
PK
→ store_id
FK
· handle
varchar
· title
varchar
navigation_items
🔑 id
PK
→ menu_id
FK
· label
varchar
· url
varchar
apps
🔑 id
PK
· name
varchar
· handle
varchar
· developer_name
varchar
app_installations
🔑 id
PK
→ app_id
FK
→ store_id
FK
· status
varchar
webhook_subscriptions
🔑 id
PK
→ store_id
FK
· topic
varchar
· url
varchar
webhook_deliveries
🔑 id
PK
→ webhook_subscription_id
FK
· event_type
varchar
· response_status
int
analytics_daily
🔑 id
PK
→ store_id
FK
· date
date
· metric
varchar
· value
int
analytics_events
🔑 id
PK
→ store_id
FK
· event_type
varchar
→ customer_id
FK
search_queries
🔑 id
PK
→ store_id
FK
· query_text
varchar
· results_count
int
search_settings
🔑 store_id
PK/FK
· synonyms_json
text
core
products
orders
customers
shipping
content
analytics
apps