FluentCart Database Schema

FluentCart uses custom database tables to store all the e-commerce data. Here are the list of database tables and their schema to understand overall database design and related data attributes of each model.

Core Entity Relationships

🔍 Interactive ER Diagram

Click on the diagram below to zoom in for better readability. The diagram shows the relationships between all FluentCart database tables.

Schema Overview

The FluentCart database schema is built around these core concepts:

• Orders & Transactions: Complete order lifecycle management with payment tracking
• Customers & Addresses: Customer relationship management with multiple address support
• Products & Variations: Flexible product catalog with inventory management
• Subscriptions: Recurring billing and subscription lifecycle management
• Coupons & Discounts: Advanced discount system with conditions and stacking
• Shipping & Tax: Configurable shipping zones and tax rate management
• Activity & Logging: Comprehensive audit trail for all operations
• Email Notifications: Automated email templates and delivery system
• Background Jobs: Scheduled actions for automated processing
• Cart Management: Shopping cart persistence and checkout flow
• Attributes & Labels: Flexible product attributes and object tagging system
• Webhooks: External integration logging and delivery tracking
• Licensing (Pro): Software license management with activation tracking
• Promotions (Pro): Order promotion tracking and statistics

Key Design Principles

1. Currency Precision: All monetary values stored as BIGINT in cents to avoid floating-point precision issues
2. Flexible Configuration: JSON columns used for extensible configuration data
3. Audit Trail: Comprehensive activity logging for all important operations
4. Referential Integrity: Enforced in model code and application services. The migrations declare no SQL FOREIGN KEY constraints, so cascades and orphan cleanup are handled by FluentCart, not the database
5. Performance Optimization: Strategic indexing on frequently queried columns
6. Multi-tenancy Ready: UUID-based public identifiers for external integrations

Database Tables

fct_customers Table

This table stores customer information and purchase history

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
user_id	BIGINT UNSIGNED NULL	WordPress user ID
contact_id	BIGINT UNSIGNED NOT NULL DEFAULT '0'	Contact ID
email	VARCHAR(192) NOT NULL DEFAULT ''	Customer email
first_name	VARCHAR(192) NOT NULL DEFAULT ''	First name
last_name	VARCHAR(192) NOT NULL DEFAULT ''	Last name
status	VARCHAR(45) NULL DEFAULT 'active'	active, inactive, archived
purchase_value	JSON NULL	Purchase value data
purchase_count	BIGINT UNSIGNED NOT NULL DEFAULT '0'	Total number of purchases
ltv	BIGINT NOT NULL DEFAULT '0'	Lifetime value in cents
first_purchase_date	DATETIME NULL	First purchase date
last_purchase_date	DATETIME NULL	Last purchase date
aov	DECIMAL(18,2) NULL	Average order value
notes	LONGTEXT NOT NULL	Customer notes
uuid	VARCHAR(100) NULL DEFAULT ''	Unique identifier
country	VARCHAR(45) NULL	Country
city	VARCHAR(45) NULL	City
state	VARCHAR(45) NULL	State
postcode	VARCHAR(45) NULL	Postal code
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• email
• user_id

fct_orders Table

This table stores the basic information of an order

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
status	VARCHAR(20) NOT NULL DEFAULT 'draft'	draft / pending / on-hold / processing / completed / failed / refunded / partial-refund
parent_id	BIGINT UNSIGNED NULL	Parent order
receipt_number	BIGINT UNSIGNED NULL
invoice_no	VARCHAR(192) NULL DEFAULT ''
fulfillment_type	VARCHAR(20) NULL DEFAULT 'physical'	physical, digital, service, mixed
type	VARCHAR(20) NOT NULL DEFAULT 'payment'	payment, renewal, refund
mode	ENUM('live', 'test') NOT NULL DEFAULT 'live'	live / test
shipping_status	VARCHAR(20) NOT NULL DEFAULT ''	unshipped / shipped / delivered / unshippable
customer_id	BIGINT UNSIGNED NULL
payment_method	VARCHAR(100) NOT NULL
payment_status	VARCHAR(20) NOT NULL DEFAULT ''
payment_method_title	VARCHAR(100) NOT NULL
currency	VARCHAR(10) NOT NULL
subtotal	BIGINT NOT NULL DEFAULT '0'	Amount in cents
discount_tax	BIGINT NOT NULL DEFAULT '0'	Amount in cents
manual_discount_total	BIGINT NOT NULL DEFAULT '0'	Amount in cents
coupon_discount_total	BIGINT NOT NULL DEFAULT '0'	Amount in cents
shipping_tax	BIGINT NOT NULL DEFAULT '0'	Amount in cents
shipping_total	BIGINT NOT NULL DEFAULT '0'	Amount in cents
fee_total	BIGINT NOT NULL DEFAULT '0'	Amount in cents
tax_total	BIGINT NOT NULL DEFAULT '0'	Amount in cents
total_amount	BIGINT NOT NULL DEFAULT '0'	Amount in cents
total_paid	BIGINT NOT NULL DEFAULT '0'	Amount in cents
total_refund	BIGINT NOT NULL DEFAULT '0'	Amount in cents
rate	DECIMAL(24,12) NOT NULL DEFAULT '1.000000000000'	Base to presentment exchange rate, frozen at order time
tax_behavior	TINYINT(1) NOT NULL DEFAULT 0	0 => no_tax, 1 => exclusive, 2 => inclusive
note	TEXT NOT NULL DEFAULT ''
ip_address	TEXT NOT NULL DEFAULT ''
completed_at	DATETIME NULL DEFAULT NULL
refunded_at	DATETIME NULL DEFAULT NULL
uuid	VARCHAR(100) NOT NULL
config	JSON DEFAULT NULL
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• invoice_no (191)
• type
• customer_id
• created_at, completed_at

fct_coupons Table

This table stores coupon definitions and rules

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
title	VARCHAR(200) NOT NULL	Coupon title
code	VARCHAR(50) NOT NULL UNIQUE	Coupon code (unique)
priority	INT DEFAULT NULL	Coupon priority
type	VARCHAR(20) NOT NULL	Coupon type
conditions	JSON NULL	Coupon conditions
amount	double NOT NULL	Discount amount
use_count	INT DEFAULT 0	Usage count
status	VARCHAR(20) NOT NULL	Coupon status
notes	LONGTEXT NOT NULL	Coupon notes
stackable	VARCHAR(3) NOT NULL DEFAULT 'no'	Stackable flag (yes/no)
show_on_checkout	VARCHAR(3) NOT NULL DEFAULT 'yes'	Show on checkout (yes/no)
start_date	TIMESTAMP NULL	Start date
end_date	TIMESTAMP NULL	End date
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• code
• status

fct_order_items Table

This table stores individual items within orders

Column	Type	Comment
id	BIGINT(20) UNSIGNED Auto Increment	Primary key
order_id	BIGINT UNSIGNED NOT NULL DEFAULT '0'	Reference to order
post_id	BIGINT UNSIGNED NOT NULL DEFAULT '0'	WordPress post ID (product)
fulfillment_type	VARCHAR(20) NOT NULL DEFAULT 'physical'	physical, digital, service
payment_type	VARCHAR(20) NOT NULL DEFAULT 'onetime'	onetime, subscription, signup_fee
post_title	TEXT NOT NULL	Product title
title	TEXT NOT NULL	Item title (variation)
object_id	BIGINT UNSIGNED NULL DEFAULT NULL	Variation ID
cart_index	BIGINT UNSIGNED NOT NULL DEFAULT '0'	Position in cart
quantity	INT NOT NULL DEFAULT '1'	Item quantity
unit_price	BIGINT NOT NULL DEFAULT '0'	Price per unit in cents
cost	BIGINT NOT NULL DEFAULT '0'	Cost in cents
subtotal	BIGINT NOT NULL DEFAULT '0'	Line subtotal
tax_amount	BIGINT NOT NULL DEFAULT '0'	Tax amount for this line
shipping_charge	BIGINT NOT NULL DEFAULT '0'	Shipping charge
discount_total	BIGINT NOT NULL DEFAULT '0'	Discount amount
line_total	BIGINT NOT NULL DEFAULT '0'	Total line amount
refund_total	BIGINT NOT NULL DEFAULT '0'	Refunded amount
rate	BIGINT NOT NULL DEFAULT '1'	Exchange rate
other_info	JSON NULL	Additional item data
line_meta	JSON NULL	Line-specific metadata
fulfilled_quantity	INT NOT NULL DEFAULT '0'	Quantity fulfilled
referrer	TEXT NULL	Referral information
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• order_id, object_id
• post_id

fct_subscriptions Table

This table stores subscription information and billing cycles

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
uuid	VARCHAR(100) NOT NULL	Unique identifier
customer_id	BIGINT(20) UNSIGNED NOT NULL	Reference to customer
parent_order_id	BIGINT(20) UNSIGNED NOT NULL	Initial order ID
product_id	BIGINT(20) UNSIGNED NOT NULL	WordPress post ID
item_name	TEXT NOT NULL	Subscription item name
quantity	INT NOT NULL DEFAULT '1'	Subscription quantity
variation_id	BIGINT(20) UNSIGNED NOT NULL	Product variation ID
billing_interval	VARCHAR(45) NULL	Billing interval (day, week, month, year)
signup_fee	BIGINT UNSIGNED NOT NULL DEFAULT 0	Signup fee in cents
initial_tax_total	BIGINT UNSIGNED NOT NULL DEFAULT 0	Initial tax in cents
recurring_amount	BIGINT UNSIGNED NOT NULL DEFAULT 0	Recurring amount in cents
recurring_tax_total	BIGINT UNSIGNED NOT NULL DEFAULT 0	Recurring tax in cents
recurring_total	BIGINT UNSIGNED NOT NULL DEFAULT 0	Total recurring in cents
bill_times	BIGINT(20) UNSIGNED NOT NULL DEFAULT 0	Total billing cycles
bill_count	INT UNSIGNED NOT NULL DEFAULT 0	Current billing count
expire_at	DATETIME NULL	Expiration date
trial_ends_at	DATETIME NULL	Trial end date
canceled_at	DATETIME NULL	Cancellation date
restored_at	DATETIME NULL	Restoration date
collection_method	ENUM('automatic', 'manual', 'system') NOT NULL DEFAULT 'automatic'	Payment collection method
next_billing_date	DATETIME NULL	Next billing date
trial_days	INT(10) UNSIGNED NOT NULL DEFAULT 0	Trial period in days
vendor_customer_id	VARCHAR(45) NULL	Payment gateway customer ID
vendor_plan_id	VARCHAR(45) NULL	Payment gateway plan ID
vendor_subscription_id	VARCHAR(45) NULL	Payment gateway subscription ID
status	VARCHAR(45) NULL	active, canceled, expired, pending, trialing
original_plan	LONGTEXT NULL	Original plan data
vendor_response	LONGTEXT NULL	Payment gateway response
current_payment_method	VARCHAR(45) NULL	Current payment method
config	JSON DEFAULT NULL	Subscription configuration
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• parent_order_id

fct_order_transactions Table

This table stores payment transactions for orders

Column	Type	Comment
id	BIGINT(20) UNSIGNED Auto Increment	Primary key
order_id	BIGINT UNSIGNED NOT NULL DEFAULT '0'	Reference to order
order_type	VARCHAR(100) NOT NULL DEFAULT ''
transaction_type	VARCHAR(192) DEFAULT 'charge'	charge, refund, etc.
subscription_id	INT(11) NULL	Reference to subscription
card_last_4	VARCHAR(4) NULL	Last 4 digits of card
card_brand	VARCHAR(100)	Card brand
vendor_charge_id	VARCHAR(192) NOT NULL DEFAULT ''	Payment gateway transaction ID
payment_method	VARCHAR(100) NOT NULL DEFAULT ''
payment_mode	VARCHAR(100) NOT NULL DEFAULT ''	live, test
payment_method_type	VARCHAR(100) NOT NULL DEFAULT ''	card, bank, etc.
status	VARCHAR(20) NOT NULL DEFAULT ''	Transaction status
currency	VARCHAR(10) NOT NULL DEFAULT ''	Transaction currency
total	BIGINT NOT NULL DEFAULT '0'	Transaction amount in cents
rate	DECIMAL(24,12)	Exchange rate
uuid	VARCHAR(100) NULL DEFAULT ''
meta	JSON DEFAULT NULL	Transaction metadata
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• vendor_charge_id (64)
• payment_method
• status
• order_id

fct_order_addresses Table

This table stores order shipping and billing addresses

Column	Type	Comment
id	BIGINT(20) UNSIGNED Auto Increment	Primary key
order_id	BIGINT UNSIGNED NOT NULL	Reference to order
type	VARCHAR(20) NOT NULL DEFAULT 'billing'	billing, shipping
name	VARCHAR(192) NULL	Address name
address_1	VARCHAR(192) NULL	Address line 1
address_2	VARCHAR(192) NULL	Address line 2
city	VARCHAR(192) NULL	City
state	VARCHAR(192) NULL	State
postcode	VARCHAR(50) NULL	Postal code
country	VARCHAR(100) NULL	Country
meta	JSON NULL	VAT number, legal registration ID and other extras
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• (order_id, type)

fct_order_operations Table

This table stores order operation logs and analytics

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
order_id	BIGINT(20) UNSIGNED NOT NULL	Reference to order
created_via	VARCHAR(45) NULL	How the order was created
emails_sent	TINYINT(1) NULL DEFAULT 0	Emails sent flag
sales_recorded	TINYINT(1) NULL DEFAULT 0	Sales recorded flag
utm_campaign	VARCHAR(192) NULL DEFAULT ''	UTM campaign tracking
utm_term	VARCHAR(192) NULL DEFAULT ''	UTM term tracking
utm_source	VARCHAR(192) NULL DEFAULT ''	UTM source tracking
utm_medium	VARCHAR(192) NULL DEFAULT ''	UTM medium tracking
utm_content	VARCHAR(192) NULL DEFAULT ''	UTM content tracking
utm_id	VARCHAR(192) NULL DEFAULT ''	UTM ID tracking
cart_hash	VARCHAR(192) NULL DEFAULT ''	Cart hash identifier
refer_url	VARCHAR(192) NULL DEFAULT ''	Referral URL
meta	JSON DEFAULT NULL	Additional operation metadata
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• order_id

fct_order_download_permissions Table

This table stores download permissions for orders

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
order_id	BIGINT(20) UNSIGNED NOT NULL	Reference to order
variation_id	BIGINT(20) UNSIGNED NOT NULL	Reference to product variation
download_id	BIGINT(20) UNSIGNED NOT NULL	Reference to download
download_count	INT(11) NULL	Number of downloads
download_limit	INT(11) NULL	Download limit
access_expires	DATETIME NULL	Access expiration date
customer_id	BIGINT(20) UNSIGNED NOT NULL	Reference to customer
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• order_id
• download_id
• variation_id

fct_product_variations Table

This table stores product variations with pricing and inventory

Column	Type	Comment
id	BIGINT(20) UNSIGNED Auto Increment	Primary key
post_id	BIGINT(20) UNSIGNED NOT NULL	WordPress post ID
media_id	BIGINT(20) UNSIGNED NULL	Media attachment ID
serial_index	INT(5) NULL	Variation order
sold_individually	TINYINT(1) UNSIGNED NULL DEFAULT 0	Sold individually flag
variation_title	VARCHAR(192) NOT NULL	Variation title
variation_identifier	VARCHAR(100) NULL	Legacy identifier
sku	VARCHAR(30) NULL	Stock keeping unit, unique across variations
manage_stock	TINYINT(1) NULL DEFAULT 0	Stock management enabled
payment_type	VARCHAR(50) NULL	onetime, subscription
stock_status	VARCHAR(30) NULL DEFAULT 'out-of-stock'	in-stock, out-of-stock, backorder
backorders	TINYINT(1) UNSIGNED NULL DEFAULT 0	Backorders allowed
total_stock	INT(11) NULL DEFAULT 0	Total stock quantity
on_hold	INT(11) NULL DEFAULT 0	Stock on hold
committed	INT(11) NULL DEFAULT 0	Committed stock
available	INT(11) NULL DEFAULT 0	Available stock
fulfillment_type	VARCHAR(100) NULL DEFAULT 'physical'	physical, digital, service, mixed
item_status	VARCHAR(30) NULL DEFAULT 'active'	active, inactive
manage_cost	VARCHAR(30) NULL DEFAULT 'false'	Cost management enabled
item_price	double DEFAULT 0 NOT NULL	Variation price
item_cost	double DEFAULT 0 NOT NULL	Variation cost
compare_price	double DEFAULT 0 NULL	Compare at price
shipping_class	BIGINT(20) NULL	Shipping class ID
other_info	longtext NULL	Additional variation data
downloadable	VARCHAR(30) NULL DEFAULT 'false'	Downloadable flag
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• post_id
• stock_status

fct_product_details Table

This table stores product configuration and settings

Column	Type	Comment
id	BIGINT(20) UNSIGNED Auto Increment	Primary key
post_id	BIGINT(20) UNSIGNED NOT NULL	WordPress post ID
fulfillment_type	VARCHAR(100) NULL DEFAULT 'physical'	physical, digital, service, mixed
min_price	double DEFAULT 0 NOT NULL	Minimum price
max_price	double DEFAULT 0 NOT NULL	Maximum price
default_variation_id	BIGINT(20) UNSIGNED NULL	Default variation ID
default_media	JSON NULL	Default media data
manage_stock	TINYINT(1) NULL DEFAULT 0	Stock management enabled
stock_availability	VARCHAR(100) NULL DEFAULT 'in-stock'	in-stock, out-of-stock, backorder
variation_type	VARCHAR(30) NULL DEFAULT 'simple'	simple, simple_variation, advance_variation
manage_downloadable	TINYINT(1) NULL DEFAULT 0	Downloadable management enabled
other_info	JSON NULL	Additional product data
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• post_id
• stock_availability

fct_product_meta Table

This table stores product metadata

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
object_id	BIGINT UNSIGNED NOT NULL	Reference to product
object_type	VARCHAR(192) NULL	Object type
meta_key	VARCHAR(192) NOT NULL	Meta key
meta_value	LONGTEXT NULL DEFAULT NULL	Meta value
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• meta_key

fct_applied_coupons Table

This table stores applied coupons to orders

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
order_id	BIGINT UNSIGNED NOT NULL	Reference to order
coupon_id	BIGINT UNSIGNED NULL	Reference to coupon
code	VARCHAR(100) NOT NULL	Coupon code
amount	double NOT NULL	Discount amount
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• code
• (coupon_id, order_id) — per-customer usage counting joins through these

fct_customer_addresses Table

This table stores customer shipping and billing addresses

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
customer_id	BIGINT UNSIGNED NOT NULL	Reference to customer
is_primary	TINYINT(1) NOT NULL DEFAULT 0	Primary address flag
type	VARCHAR(20) NOT NULL DEFAULT 'billing'	billing, shipping
status	VARCHAR(20) NOT NULL DEFAULT 'active'	active, inactive
label	VARCHAR(50) NOT NULL DEFAULT ''	Address label
name	VARCHAR(192) NULL	Address name
address_1	VARCHAR(192) NULL	Address line 1
address_2	VARCHAR(192) NULL	Address line 2
city	VARCHAR(192) NULL	City
state	VARCHAR(192) NULL	State
phone	VARCHAR(192) NULL	Phone number
email	VARCHAR(192) NULL	Email address
postcode	VARCHAR(32) NULL	Postal code
country	VARCHAR(100) NULL	Country
meta	JSON NULL	VAT number, legal registration ID and other extras
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• customer_id, is_primary
• type
• status

fct_customer_meta Table

This table stores customer metadata

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
customer_id	BIGINT UNSIGNED NULL DEFAULT NULL	Reference to customer
meta_key	VARCHAR(192) NULL DEFAULT NULL	Meta key
meta_value	LONGTEXT NULL DEFAULT NULL	Meta value
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• meta_key
• customer_id

fct_carts Table

This table stores shopping cart data

Column	Type	Comment
customer_id	BIGINT(20) UNSIGNED NULL	Reference to customer
user_id	BIGINT(20) UNSIGNED NULL	Reference to WordPress user
order_id	BIGINT(20) UNSIGNED NULL	Reference to order
cart_hash	VARCHAR(192) NOT NULL UNIQUE	Unique cart identifier
checkout_data	LONGTEXT NULL	Checkout form data
cart_data	LONGTEXT NULL	Cart contents
utm_data	LONGTEXT NULL	UTM tracking data
coupons	LONGTEXT NULL	Applied coupons
first_name	VARCHAR(192) NULL	Customer first name
last_name	VARCHAR(192) NULL	Customer last name
email	VARCHAR(192) NULL	Customer email
stage	VARCHAR(30) NULL DEFAULT 'draft'	draft, pending, in-complete, completed
cart_group	VARCHAR(30) NULL DEFAULT 'global'	Cart group
user_agent	VARCHAR(192) NULL	User agent string
ip_address	VARCHAR(50) NULL	IP address
completed_at	TIMESTAMP NULL	Completion timestamp
created_at	DATETIME NULL
updated_at	DATETIME NULL
deleted_at	TIMESTAMP NULL	Soft delete timestamp

fct_product_downloads Table

This table stores downloadable product files

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
post_id	BIGINT(20) UNSIGNED NOT NULL	WordPress post ID
product_variation_id	longtext NOT NULL	Product variation ID
download_identifier	VARCHAR(100) NOT NULL UNIQUE	Unique download identifier
title	VARCHAR(192) NULL	Download title
type	VARCHAR(100) NULL	Download type
driver	VARCHAR(100) NULL DEFAULT 'local'	Storage driver
file_name	VARCHAR(192) NULL	File name
file_path	TEXT NULL	File path
file_url	TEXT NULL	File URL
file_size	TEXT NULL	File size
settings	TEXT NULL	Download settings
serial	INT NULL	Serial number
created_at	DATETIME NULL
updated_at	DATETIME NULL

fct_subscription_meta Table

This table stores subscription metadata

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
subscription_id	BIGINT UNSIGNED NULL DEFAULT NULL	Reference to subscription
meta_key	VARCHAR(192) NULL DEFAULT NULL	Meta key
meta_value	LONGTEXT NULL DEFAULT NULL	Meta value
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• subscription_id
• meta_key

fct_activity Table

This table stores system activity and audit logs

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
status	VARCHAR(20) NOT NULL DEFAULT 'info'	success / warning / failed / info
log_type	VARCHAR(20) NOT NULL DEFAULT 'activity'	activity, api
module_type	VARCHAR(100) NOT NULL DEFAULT 'order'	Full model path
module_id	BIGINT NULL	Related record ID
module_name	VARCHAR(192) NOT NULL DEFAULT 'order'	order, product, user, coupon, subscription, payment, refund, shipment, activity
user_id	BIGINT UNSIGNED NULL	User who performed action
title	VARCHAR(192) NULL	Activity title
content	LONGTEXT NULL	Activity description
read_status	VARCHAR(20) NOT NULL DEFAULT 'unread'	read, unread
created_by	VARCHAR(100) NOT NULL DEFAULT 'FCT-BOT'	Creator identifier
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• module_id

fct_shipping_zones Table

This table stores shipping zones configuration

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
shipping_class_id	BIGINT UNSIGNED NULL	Scopes the zone to one shipping class; NULL means it applies to class-less items
name	VARCHAR(192) NOT NULL	Zone name
region	VARCHAR(192) NOT NULL	A country code, all (Whole World) or selection
meta	JSON NULL	For selection zones: countries and selection_type (included / excluded)
order	INT UNSIGNED NOT NULL DEFAULT 0	Display order
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• order
• shipping_class_id

fct_shipping_methods Table

This table stores shipping methods within zones

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
zone_id	BIGINT UNSIGNED NOT NULL	Reference to shipping zone
title	VARCHAR(192) NOT NULL	Method title
type	VARCHAR(50) NOT NULL	Method type
settings	LONGTEXT NULL	Method settings: configure_rate, class_aggregation, weight_tiers
is_enabled	TINYINT(1) NOT NULL DEFAULT 1	Enabled flag
states	JSON NULL	Restricts the method to these states within the zone
amount	DECIMAL(10,2) NULL DEFAULT 0.00	Base rate in base-currency major units, not cents (a percentage when configure_rate is per_price)
order	INT UNSIGNED NOT NULL DEFAULT 0	Display order
meta	JSON NULL
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• zone_id
• order

fct_shipping_classes Table

This table stores shipping classes

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
name	VARCHAR(192) NOT NULL	Class name
description	VARCHAR(500) NULL	Class description
cost	DECIMAL(10,2) NOT NULL DEFAULT 0.00	Surcharge in base-currency major units, not cents
per_item	TINYINT(1) NOT NULL DEFAULT 0	Per item flag
type	VARCHAR(20) NOT NULL DEFAULT 'fixed'	Class type
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• name

fct_tax_classes Table

This table stores tax class definitions

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
title	VARCHAR(192) NULL	Tax class title
slug	VARCHAR(100) NULL	Tax class slug
description	LONGTEXT NULL	Tax class description
meta	JSON DEFAULT NULL	Tax class metadata
created_at	DATETIME NULL
updated_at	DATETIME NULL

fct_tax_rates Table

This table stores tax rate configurations

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
class_id	BIGINT UNSIGNED NOT NULL	Tax class ID
country	VARCHAR(45) NULL	Country code
state	VARCHAR(45) NULL	State code
postcode	TEXT NULL	Postal code (supports ranges)
city	VARCHAR(45) NULL	City
rate	VARCHAR(45) NULL	Tax rate
name	VARCHAR(45) NULL	Tax name
group	VARCHAR(45) NULL	Tax group
priority	INT UNSIGNED NULL DEFAULT 1	Priority
is_compound	TINYINT UNSIGNED NULL DEFAULT 0	Compound tax flag
for_shipping	DECIMAL(10,2) NULL DEFAULT NULL	Shipping-tax rate override percentage (NULL = inherit base rate; 0 = no shipping tax)
for_order	TINYINT UNSIGNED NULL DEFAULT 0	Apply to order

Indexes:

• class_id
• priority

fct_meta Table

This table stores generic metadata for various objects

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
object_type	VARCHAR(50) NOT NULL	Object type
object_id	BIGINT NULL	Object ID
meta_key	VARCHAR(192) NOT NULL	Meta key
meta_value	LONGTEXT NULL	Meta value
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• object_type
• object_id

fct_label Table

This table stores labels for tagging objects

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
value	VARCHAR(192) NOT NULL UNIQUE	Label value (unique)
created_at	DATETIME NULL
updated_at	DATETIME NULL

fct_order_meta Table

This table stores order metadata

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
order_id	BIGINT(20) NULL	Reference to order
meta_key	VARCHAR(192) NOT NULL	Meta key
meta_value	LONGTEXT NULL	Meta value
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• order_id

fct_order_tax_rate Table

This table stores order tax rate information

Column	Type	Comment
id	BIGINT(20) UNSIGNED Auto Increment	Primary key
order_id	BIGINT(20) UNSIGNED NOT NULL	Reference to order
tax_rate_id	BIGINT(20) NOT NULL	Reference to tax rate (signed; virtual EU VAT rates use negative IDs)
shipping_tax	BIGINT NULL	Shipping tax amount
order_tax	BIGINT NULL	Order tax amount
total_tax	BIGINT NULL	Total tax amount
meta	JSON DEFAULT NULL	Tax meta data
filed_at	DATETIME NULL	Filed at
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• (order_id, tax_rate_id) (unique)

fct_webhook_logger Table

This table stores webhook delivery logs and status

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
source	VARCHAR(20) NOT NULL	Webhook source
event_type	VARCHAR(100) NOT NULL	Event type
payload	LONGTEXT NULL	Webhook payload
status	VARCHAR(20) NOT NULL DEFAULT 'pending'	pending, sent, failed
created_at	DATETIME NULL
updated_at	DATETIME NULL

fct_scheduled_actions Table

This table stores background job scheduling and execution

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
scheduled_at	DATETIME NULL	When to run the action
action	VARCHAR(192) NULL	Action to perform
status	VARCHAR(20) NULL	pending, processing, completed, failed
group	VARCHAR(100) NULL	order, subscription
object_id	BIGINT UNSIGNED NULL DEFAULT NULL	Related object ID
object_type	VARCHAR(100) NULL DEFAULT NULL	Object type
completed_at	TIMESTAMP NULL	When action was completed
retry_count	INT UNSIGNED DEFAULT 0	Number of retries
data	JSON NULL	Action data
created_at	DATETIME NULL
updated_at	DATETIME NULL
response_note	LONGTEXT NULL	Response or error message

Indexes:

• scheduled_at
• status

fct_atts_groups Table

This table stores attribute groups for product attributes

Column	Type	Comment
id	BIGINT(20) UNSIGNED Auto Increment	Primary key
title	VARCHAR(192) NOT NULL	Group title
slug	VARCHAR(192) NOT NULL UNIQUE	Group slug
description	LONGTEXT NULL	Group description
settings	LONGTEXT NULL	Group settings
serial	INT(11) UNSIGNED NOT NULL DEFAULT 0	Manual drag-order of groups in the admin
is_system	TINYINT(1) NOT NULL DEFAULT 0	Marks a group FluentCart created itself
created_at	DATETIME NULL
updated_at	DATETIME NULL

fct_atts_terms Table

This table stores attribute terms within groups

Column	Type	Comment
id	BIGINT(20) UNSIGNED Auto Increment	Primary key
group_id	BIGINT(20) UNSIGNED	Reference to attribute group
serial	INT(11) UNSIGNED	Term order
title	VARCHAR(192) NOT NULL	Term title
slug	VARCHAR(192) NOT NULL	Term slug
description	LONGTEXT NULL	Term description
settings	LONGTEXT NULL	Term settings
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• group_id

fct_atts_relations Table

This table stores relationships between attributes and objects

Column	Type	Comment
id	BIGINT(20) UNSIGNED Auto Increment	Primary key
group_id	BIGINT(20) UNSIGNED NOT NULL	Reference to attribute group
term_id	BIGINT(20) UNSIGNED NOT NULL	Reference to attribute term
object_id	BIGINT(20) UNSIGNED NOT NULL	Related object ID
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• group_id
• term_id
• object_id

fct_label_relationships Table

This table stores polymorphic relationships between labels and objects

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment	Primary key
label_id	BIGINT(20) NOT NULL	Reference to label
labelable_id	BIGINT(20) NOT NULL	Related object ID
labelable_type	VARCHAR(192) NOT NULL	Object type
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• label_id
• labelable_id

Pro Plugin Tables

fct_licenses Table

Software licences issued for a purchase (Pro).

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment
status	VARCHAR(45) NULL DEFAULT 'active'	active, inactive, expired, disabled
limit	BIGINT(20) UNSIGNED NOT NULL DEFAULT 0	Activation limit
activation_count	BIGINT(20) UNSIGNED NOT NULL DEFAULT 0	Current activations
license_key	VARCHAR(192) NULL	Licence key
product_id	BIGINT(20) UNSIGNED NOT NULL	WordPress post ID of the product
variation_id	BIGINT(20) UNSIGNED NOT NULL	Variation the licence was issued for
order_id	BIGINT(20) UNSIGNED NOT NULL	Order the licence came from
parent_id	BIGINT(20) UNSIGNED NULL	Parent licence, for upgrades and renewals
customer_id	BIGINT(20) UNSIGNED NOT NULL	Licence owner
expiration_date	DATETIME NULL	NULL means lifetime
last_reminder_sent	DATETIME NULL	When the last expiry reminder went out
last_reminder_type	VARCHAR(50) NULL	Which reminder stage was sent
subscription_id	BIGINT(20) UNSIGNED NOT NULL DEFAULT 0	Linked subscription, 0 when none
config	json NULL	Extra licence configuration
created_at	TIMESTAMP NULL
updated_at	TIMESTAMP NULL

Indexes:

• order_id
• license_key
• product_id
• customer_id (idx_licenses_customer_recovery)

fct_license_activations Table

One row per site a licence is activated on (Pro). This table carries both license_id and site_id, so it is the join between licences and sites.

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment
site_id	BIGINT(20) UNSIGNED NOT NULL	Reference to fct_license_sites
license_id	BIGINT(20) UNSIGNED NOT NULL	Reference to fct_licenses
status	VARCHAR(45) NULL DEFAULT 'active'	Activation status
is_local	TINYINT NULL DEFAULT 0	Local or staging install
product_id	BIGINT(20) UNSIGNED NOT NULL	Product
variation_id	BIGINT(20) UNSIGNED NOT NULL	Variation
activation_method	VARCHAR(45) NULL DEFAULT 'key_based'	How the site activated
activation_hash	VARCHAR(99) NULL	Activation hash
last_update_version	VARCHAR(45) NULL	Version at the last update check
last_update_date	DATETIME NULL	Last update check
created_at	TIMESTAMP NULL
updated_at	TIMESTAMP NULL

Indexes:

• license_id
• site_id

fct_license_sites Table

The sites themselves (Pro). Join through fct_license_activations to reach a licence's sites.

Column	Type	Comment
id	BIGINT UNSIGNED Auto Increment
site_url	VARCHAR(192) NULL	Site URL
server_version	VARCHAR(50) NULL	Server software version
platform_version	VARCHAR(50) NULL	WordPress version
other	JSON NULL	Additional site data
created_at	TIMESTAMP NULL
updated_at	TIMESTAMP NULL

Indexes:

• site_url

fct_license_meta Table

This table stores license metadata (Pro feature)

Column	Type	Comment
id	BIGINT UNSIGNED AUTO_INCREMENT, PRIMARY KEY
object_id	BIGINT UNSIGNED NULL DEFAULT NULL	Reference to object (license/activation/site)
object_type	VARCHAR(100) NULL DEFAULT NULL	Can be: license / activation / site
meta_key	VARCHAR(255) NULL DEFAULT NULL	Meta key
meta_value	LONGTEXT NULL DEFAULT NULL	Meta value (JSON or string)
created_at	TIMESTAMP NULL
updated_at	TIMESTAMP NULL

Indexes:

• meta_key
• object_type
• object_id

fct_order_promotions Table

This table stores order promotion data (Pro feature)

Column	Type	Comment
id	BIGINT(20) UNSIGNED AUTO_INCREMENT, PRIMARY KEY
hash	VARCHAR(100) NOT NULL
parent_id	BIGINT(20) UNSIGNED NULL
type	VARCHAR(50) NOT NULL
status	VARCHAR(50) NOT NULL DEFAULT 'draft'
src_object_id	BIGINT(20) UNSIGNED NULL
src_object_type	VARCHAR(50) DEFAULT NULL
title	VARCHAR(194) DEFAULT NULL
description	TEXT DEFAULT NULL
conditions	JSON DEFAULT NULL
config	JSON DEFAULT NULL
priority	INT NOT NULL DEFAULT 1
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• (type, status, src_object_id, src_object_type)

fct_order_promotion_stats Table

This table stores promotion statistics (Pro feature)

Column	Type	Comment
id	BIGINT(20) UNSIGNED AUTO_INCREMENT, PRIMARY KEY
promotion_id	BIGINT(20) UNSIGNED NOT NULL
order_id	BIGINT(20) UNSIGNED NOT NULL
object_id	BIGINT(20) UNSIGNED NOT NULL
amount	BIGINT NOT NULL DEFAULT '0'
status	VARCHAR(50) NOT NULL DEFAULT 'offered'
created_at	DATETIME NULL
updated_at	DATETIME NULL

Indexes:

• (promotion_id, object_id, order_id)

---