#08 Claude Code Team (Adaptive Thinking Off)

Schema

2026-04-12-claude-code-team · v2.1.104

Database Schema (ER Diagram)

54 tables - SQLite

100%
Core / AuthProducts & InventoryCustomersOrders & PaymentsShipping / Contentorganizations🔑 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_primaryboolsessions🔑 idPK→ user_idFK· ip_addressvarchar· last_activityintpassword_reset_tokens🔑 emailPK· tokenvarchar· created_attimestampstores🔑 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· first_namevarchar· last_namevarchar· accepts_marketingboolcustomer_addresses🔑 idPK→ customer_idFK· address1varchar· cityvarchar· country_codevarchar· is_defaultboolcustomer_pw_reset_tokens🔑 emailPK· tokenvarchar· created_attimestampcarts🔑 idPK→ store_idFK· currencyvarchar· statusvarcharcart_lines🔑 idPK→ cart_idFK→ variant_idFK· quantityint· line_total_amountintcheckouts🔑 idPK→ store_idFK→ cart_idFK· statusvarchar· emailvarchar· shipping_amountintdiscounts🔑 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· tax_rate_basis_pointsint· 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· handlevarchar· developer_namevarcharapp_installations🔑 idPK→ app_idFK→ store_idFK· statusvarcharwebhook_subscriptions🔑 idPK→ store_idFK→ app_installation_idFK· topicvarchar· urlvarcharwebhook_deliveries🔑 idPK→ webhook_subscription_idFK· event_typevarchar· response_statusintanalytics_daily🔑 idPK→ store_idFK· datedate· metricvarchar· valueintanalytics_events🔑 idPK→ store_idFK· event_typevarchar· session_idvarcharsearch_queries🔑 idPK→ store_idFK· query_textvarchar· results_countintsearch_settings🔑 store_idPK/FK· synonyms_jsontextmigrations🔑 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