#05 Codex Sub-Agents v2 (Quality)

Schema

codex-subagents-2 · v0.101.0

Database Schema (ER Diagram)

50 domain tables - SQLite (includes OAuth tables)

100%
Core / AuthProducts & InventoryCustomersOrders & PaymentsShipping / Content / Appsorganizations🔑 idPK· namevarchar· billing_emailvarcharusers🔑 idPK· namevarchar· emailvarchar· statusvarcharstore_users→ store_idFK→ user_idFK· rolevarcharstore_settings🔑 store_idPK/FK· settings_jsontextstore_domains🔑 idPK→ store_idFK· hostnamevarchar· typevarchar· is_primaryboolstores🔑 idPK→ organization_idFK· namevarchar· handlevarchar· statusvarchar· default_currencyvarchar· timezonevarcharproducts🔑 idPK→ store_idFK· titlevarchar· handlevarchar· statusvarchar· vendorvarchar· product_typevarcharproduct_variants🔑 idPK→ product_idFK· skuvarchar· price_amountint· compare_at_amountint· is_defaultbool· statusvarcharproduct_options🔑 idPK→ product_idFK· namevarchar· positionintproduct_option_values🔑 idPK→ product_option_idFK· valuevarchar· positionintvariant_option_values→ variant_idFK→ product_option_value_idFKproduct_media🔑 idPK→ product_idFK· typevarchar· storage_keyvarchar· alt_textvarcharinventory_items🔑 idPK→ store_idFK→ variant_idFK· quantity_on_handint· quantity_reservedint· policyvarcharcollections🔑 idPK→ store_idFK· titlevarchar· handlevarchar· typevarcharcollection_products→ collection_idFK→ product_idFK· positionintcustomers🔑 idPK→ store_idFK· emailvarchar· namevarchar· marketing_opt_inboolcustomer_addresses🔑 idPK→ customer_idFK· labelvarchar· address_jsontext· is_defaultboolcustomer_password_reset_tokens🔑 emailPK· tokenvarchar· created_attimestampcarts🔑 idPK→ store_idFK→ customer_idFK· currencyvarchar· statusvarcharcart_lines🔑 idPK→ cart_idFK→ variant_idFK· quantityint· line_total_amountintcheckouts🔑 idPK→ store_idFK→ cart_idFK→ customer_idFK· statusvarchar· emailvarchar→ shipping_method_idFKdiscounts🔑 idPK→ store_idFK· codevarchar· typevarchar· value_typevarchar· value_amountint· statusvarcharorders🔑 idPK→ store_idFK→ customer_idFK· order_numbervarchar· statusvarchar· financial_statusvarchar· fulfillment_statusvarchar· total_amountintorder_lines🔑 idPK→ order_idFK→ product_idFK→ variant_idFK· quantityint· total_amountintpayments🔑 idPK→ order_idFK· methodvarchar· statusvarchar· amountintrefunds🔑 idPK→ order_idFK→ payment_idFK· amountint· statusvarcharfulfillments🔑 idPK→ order_idFK· statusvarchar· tracking_numbervarchar· tracking_companyvarcharfulfillment_lines🔑 idPK→ fulfillment_idFK→ order_line_idFK· quantityintshipping_zones🔑 idPK→ store_idFK· namevarchar· countries_jsontextshipping_rates🔑 idPK→ zone_idFK· namevarchar· typevarchartax_settings🔑 store_idPK/FK· modevarchar· prices_include_taxboolthemes🔑 idPK→ store_idFK· namevarchar· statusvarchartheme_files🔑 idPK→ theme_idFK· pathvarchar· sha256varchartheme_settings🔑 theme_idPK/FK· settings_jsontextpages🔑 idPK→ store_idFK· titlevarchar· handlevarchar· statusvarcharnavigation_menus🔑 idPK→ store_idFK· handlevarchar· titlevarcharnavigation_items🔑 idPK→ menu_idFK· labelvarchar· urlvarcharapps🔑 idPK· namevarchar· statusvarcharapp_installations🔑 idPK→ app_idFK→ store_idFK· statusvarcharwebhook_subscriptions🔑 idPK→ store_idFK· event_typevarchar· target_urlvarcharwebhook_deliveries🔑 idPK→ subscription_idFK· event_idvarchar· statusvarcharanalytics_daily→ store_idFK· datedate· orders_countint· revenue_amountintanalytics_events🔑 idPK→ store_idFK· typevarchar→ customer_idFKsearch_queries🔑 idPK→ store_idFK· queryvarchar· results_countintsearch_settings🔑 store_idPK/FK· synonyms_jsontextoauth_clients🔑 idPK→ store_idFK· namevarchar· secretvarchar· redirectvarcharoauth_tokens🔑 idPK→ client_idFK→ user_idFK· scopestext· revokedbool· expires_attimestampcoreproductsorderscustomersshippingcontentanalyticsappsauth