#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