agentic-engineers.dev
#03 Codex with Sub-Agents
Build Detail
Quality
Features
Schema
Schema
#03 Codex with Sub-Agents
Schema
codex · v0.99.0
Database Schema (ER Diagram)
48 domain 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
· name
varchar
· marketing_opt_in
bool
customer_addresses
🔑 id
PK
→ customer_id
FK
· label
varchar
· address_json
text
· 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_method_id
FK
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
· 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
· status
varchar
app_installations
🔑 id
PK
→ app_id
FK
→ store_id
FK
· status
varchar
webhook_subscriptions
🔑 id
PK
→ store_id
FK
· event_type
varchar
· target_url
varchar
webhook_deliveries
🔑 id
PK
→ subscription_id
FK
· event_id
varchar
· status
varchar
analytics_daily
→ store_id
FK
· date
date
· orders_count
int
· revenue_amount
int
analytics_events
🔑 id
PK
→ store_id
FK
· type
varchar
→ customer_id
FK
search_queries
🔑 id
PK
→ store_id
FK
· query
varchar
· results_count
int
search_settings
🔑 store_id
PK/FK
· synonyms_json
text
core
products
orders
customers
shipping
content
analytics
apps