#18 Codex GPT-5.6 Luna (Multi-Agent v2 Team Mode)

Schema

2026-08-20-codex-gpt-5-6-luna · 0.147.0

Database Schema (ER Diagram)

58 domain tables - SQLite (multi-tenant, store_id-scoped).

100%
Core / AuthApps / AnalyticsProducts & InventoryCustomers & CartsOrders & PaymentsShipping / ContentSystemorganizations🔑 idPK· namevarchar· slugvarchar· billing_emailvarchar· statusvarcharusers🔑 idPK· namevarchar· emailvarchar· statusvarchar· is_platform_adminboolstore_users→ store_idFK→ user_idFK· rolevarcharstore_settings🔑 store_idPK/FK· settings_jsontextstore_domains🔑 idPK→ store_idFK· hostnamevarchar· typevarchar· is_primarybool· tls_modevarcharsessions🔑 idPK→ user_idFK· ip_addressvarchar· last_activityintpassword_reset_tokens🔑 emailPK· tokenvarchar· created_attimestamppersonal_access_tokens🔑 idPK· tokenable_typevarchar· tokenable_idint· namevarchar· tokenvarcharstores🔑 idPK→ organization_idFK· namevarchar· handlevarchar· statusvarchar· default_currencyvarchar· timezonevarcharapps🔑 idPK· namevarchar· slugvarcharapp_installations🔑 idPK→ app_idFK→ store_idFKwebhook_subscriptions🔑 idPK→ store_idFK→ app_installation_idFK· eventvarchar· target_urltextwebhook_deliveries🔑 idPK→ webhook_subscription_idFK· eventvarchar· response_statusintoauth_clients🔑 idPK→ store_idFK· namevarchar· client_idvarcharoauth_tokens🔑 idPK→ oauth_client_idFK→ user_idFK· token_hashvarcharstore_invitations🔑 idPK→ store_idFK· emailvarchar· rolevarcharanalytics_daily🔑 store_idPK/FK· datedate· orders_countint· revenue_amountintanalytics_events🔑 idPK→ store_idFK· typevarchar· session_idvarcharsearch_queries🔑 idPK→ store_idFK· queryvarchar· results_countintsearch_settings🔑 store_idPK/FK· synonyms_jsontextproducts🔑 idPK→ store_idFK· titlevarchar· handlevarchar· statusvarchar· vendorvarcharproduct_variants🔑 idPK→ product_idFK· skuvarchar· price_amountint· compare_at_amountint· statusvarcharproduct_options🔑 idPK→ product_idFK· namevarcharproduct_option_values🔑 idPK→ product_option_idFK· valuevarcharvariant_option_values→ variant_idFK→ product_option_value_idFKproduct_media🔑 idPK→ product_idFK· typevarchar· storage_keyvarcharinventory_items🔑 idPK→ store_idFK→ variant_idFK· quantity_on_handint· policyvarcharcollections🔑 idPK→ store_idFK· titlevarchar· typevarcharcollection_products→ collection_idFK→ product_idFK· positionintcustomers🔑 idPK→ store_idFK· emailvarchar· first_namevarchar· last_namevarcharcustomer_addresses🔑 idPK→ customer_idFK· address_jsontext· is_defaultboolcustomer_password_reset_tokens→ store_idFK🔑 emailPK· tokenvarchar· created_attimestampcarts🔑 idPK→ store_idFK→ customer_idFK· currencyvarchar· statusvarcharcart_lines🔑 idPK→ cart_idFK→ variant_idFK· quantityintcheckouts🔑 idPK→ store_idFK→ cart_idFK· statusvarchar· emailvarchar→ shipping_rate_idFKdiscounts🔑 idPK→ store_idFK· codevarchar· typevarchar· value_typevarchar· value_amountintorders🔑 idPK→ store_idFK→ customer_idFK→ checkout_idFK· order_numbervarchar· statusvarchar· financial_statusvarchar· fulfillment_statusvarcharorder_lines🔑 idPK→ order_idFK→ product_idFK→ variant_idFK· quantityint· total_amountintpayments🔑 idPK→ order_idFK· providervarchar· methodvarchar· statusvarchar· amountintrefunds🔑 idPK→ order_idFK→ payment_idFK· amountintfulfillments🔑 idPK→ order_idFK· statusvarchar· tracking_numbervarcharfulfillment_lines🔑 idPK→ fulfillment_idFK→ order_line_idFKorder_exports🔑 idPK→ store_idFK· formatvarchar· statusvarcharshipping_zones🔑 idPK→ store_idFK· namevarchar· countries_jsontextshipping_rates🔑 idPK→ shipping_zone_idFK· namevarchar· price_amountinttax_settings🔑 store_idPK/FK· modevarchar· default_rate_basis_pointsint· prices_include_taxboolthemes🔑 idPK→ store_idFK· namevarchar· statusvarchartheme_files🔑 idPK→ theme_idFK· pathvarchartheme_settings🔑 theme_idPK/FK· settings_jsontextpages🔑 idPK→ store_idFK· titlevarchar· handlevarcharnavigation_menus🔑 idPK→ store_idFK· handlevarcharnavigation_items🔑 idPK→ navigation_menu_idFK· labelvarchar· urlvarcharmigrations🔑 idPK· migrationvarchar· batchintjobs🔑 idPK· queuevarchar· payloadtext· attemptsintfailed_jobs🔑 idPK· uuidvarchar· connectiontext· exceptiontextjob_batches🔑 idPK· namevarchar· total_jobsint· pending_jobsintcache🔑 keyPK· valuetext· expirationintcache_locks🔑 keyPK· ownervarchar· expirationintcoreproductsorderscustomersshippingcontentanalyticsappssystem