szkoleniauryzaj.pl/.paul/codebase/db_schema.md

Database Schema

Generated by /paul:map-codebase — 2026-04-26 Note: WordPress core not in local repo — schema below is derived from config + plugin inventory.

Connection

• Database: garbary_szkury
• Prefix: wp_
• Host: localhost
• Charset: UTF-8

Standard WordPress Tables

Table	Purpose
wp_posts	All content: pages, posts, WooCommerce products, bbPress topics/replies
wp_postmeta	Post custom fields (includes ACF fields, WooCommerce product data)
wp_users	User accounts
wp_usermeta	User meta (WooCommerce customer data, roles)
wp_options	Site settings, theme mods, plugin config, Divi builder settings
wp_terms	Categories, tags, product categories, bbPress forums
wp_term_taxonomy	Taxonomy definitions
wp_term_relationships	Post ↔ term relationships
wp_comments	Comments
wp_commentmeta	Comment meta

WooCommerce Tables

Table	Purpose
wp_woocommerce_sessions	Customer sessions
wp_woocommerce_api_keys	REST API keys
wp_woocommerce_attribute_taxonomies	Product attribute definitions
wp_woocommerce_downloadable_product_permissions	Digital product access
wp_woocommerce_order_items	Order line items
wp_woocommerce_order_itemmeta	Order item meta
wp_woocommerce_tax_rates	Tax configuration
wp_woocommerce_tax_rate_locations	Tax rate geo rules
wp_woocommerce_shipping_zones	Shipping zones
wp_woocommerce_shipping_zone_locations	Zone locations
wp_woocommerce_shipping_zone_methods	Zone shipping methods
wp_woocommerce_payment_tokens	Saved payment tokens (PayU)
wp_woocommerce_payment_tokenmeta	Payment token meta
wp_wc_product_meta_lookup	Product search/filter cache
wp_wc_tax_rate_classes	Tax classes
wp_wc_webhooks	WooCommerce webhooks

Key Custom Fields (ACF — stored in wp_postmeta)

Field key	Post type	Purpose
end_date_of_the_offer	product	Offer expiry date; read by cron-products.php to auto-unpublish

bbPress Tables

Table	Purpose
Uses wp_posts	Forum, topic, reply post types
Uses wp_postmeta	Forum/topic meta
Uses wp_terms	Forum taxonomy

Notes

• Products (courses) are stored as wp_posts with post_type = 'product'
• Course categories are wp_terms under product_cat taxonomy
• Custom "Rezerwuj miejsce" / stock behavior driven by wp_postmeta stock fields + ACF end_date_of_the_offer
• Divi page builder content stored as serialized shortcodes in wp_posts.post_content
• Divi customizer settings (from divi-children-engine) stored in wp_options as theme_mods_body-relax