Data Model

Table Inventory

AweCommerce stores commerce records in dedicated tables:

awc_products
awc_prices
awc_price_tiers
awc_customers
awc_addresses
awc_orders
awc_order_items
awc_subscriptions
awc_subscription_items
awc_transactions
awc_refunds
awc_dunning_attempts
awc_entitlement_grants
awc_user_access_index
awc_acl_rules
awc_role_grants
awc_capability_grants
awc_invoices
awc_invoice_items
awc_coupons
awc_coupon_redemptions
awc_tax_rates
awc_download_files
awc_webhook_events
awc_queue
awc_event_log
awc_audit_log
awc_email_log
awc_notifications
awc_api_keys
awc_customer_notes
awc_magic_links
awc_payment_methods
awc_membership_access
awc_customer_agreements
awc_licenses
awc_license_products
awc_license_sites
awc_license_installations
awc_software_releases
awc_package_tokens
awc_license_events
awc_license_request_nonces
awc_migrations

Product Tables

awc_products mirrors commerce product state from awc_product posts.

awc_prices stores purchasable price options.

awc_price_tiers supports tiered price rows.

Customer Tables

awc_customers stores customer identity and linked WordPress user.

awc_addresses stores billing and shipping addresses.

awc_customer_notes stores support notes.

awc_payment_methods stores gateway payment method metadata.

awc_customer_agreements stores accepted checkout agreement snapshots.

Billing Tables

awc_orders stores order headers.

awc_order_items stores order lines.

awc_transactions stores charges, refunds, disputes, adjustments, and reversals.

awc_refunds stores refund records.

awc_invoices and awc_invoice_items store invoice data.

Subscription Tables

awc_subscriptions stores subscription state.

awc_subscription_items stores recurring items.

awc_dunning_attempts stores retry schedule and outcomes.

Access Tables

awc_entitlement_grants, awc_role_grants, and awc_capability_grants store source-aware access grants.

awc_user_access_index stores fast lookup state.

awc_acl_rules stores access control rules.

awc_membership_access stores membership lifecycle rows.

Licensing Tables

awc_licenses stores license records.

awc_license_products stores product coverage rows.

awc_license_sites stores activated sites.

awc_license_installations stores product installations under sites.

awc_software_releases stores release metadata.

awc_package_tokens stores package download tokens.

awc_license_events stores audit events.

awc_license_request_nonces prevents signed request replay.

Direct Query Example

Prefer repositories and services for writes. For read-only reporting:

global $wpdb;

$orders_table = $wpdb->prefix . 'awc_orders';

$orders = $wpdb->get_results(
    $wpdb->prepare(
        "SELECT id, order_number, status, total, currency
         FROM {$orders_table}
         WHERE customer_id = %d
         ORDER BY id DESC
         LIMIT 20",
        42
    )
);

Migration Rule

Use explicit migrations for schema changes. Do not change production tables ad hoc from page render callbacks or request handlers.