example-schema.ini

; Example Shop / Marketplace Database
; Auto-connect test schema
; No explicit > links included

[customer]
customer_id[Customer ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
customer_email[Email address] = TEXT NOT_NULL UNIQUE
customer_username[Username] = TEXT UNIQUE
customer_first_name[First name] = TEXT
customer_last_name[Last name] = TEXT
customer_created_at[Created timestamp] = TEXT
customer_is_active[Active flag] = INTEGER DEFAULT:1

[customer_address]
customer_address_id[Customer address ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
customer_id[Linked customer] = INTEGER NOT_NULL [N]
address_type[Address type] = TEXT
address_name[Address name] = TEXT
street[Street] = TEXT NOT_NULL
postal_code[Postal code] = TEXT
city[City] = TEXT
country_code[Country code] = TEXT
is_default_shipping[Default shipping flag] = INTEGER DEFAULT:0
is_default_billing[Default billing flag] = INTEGER DEFAULT:0

[seller]
seller_id[Seller ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
seller_name[Seller name] = TEXT NOT_NULL
seller_slug[Seller slug] = TEXT UNIQUE
seller_email[Seller email] = TEXT
seller_rating[Seller rating] = REAL DEFAULT:0
seller_is_active[Active seller flag] = INTEGER DEFAULT:1

[brand]
brand_id[Brand ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
brand_name[Brand name] = TEXT NOT_NULL UNIQUE
brand_slug[Brand slug] = TEXT UNIQUE
brand_description[Brand description] = TEXT

[product]
product_id[Product ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
seller_id[Linked seller] = INTEGER NOT_NULL [N]
brand_id[Linked brand] = INTEGER [N]
product_sku[Product SKU] = TEXT UNIQUE
product_name[Product name] = TEXT NOT_NULL
product_slug[Product slug] = TEXT UNIQUE
product_description[Product description] = TEXT
product_price[Product price] = REAL NOT_NULL
product_currency[Currency code] = TEXT
product_is_active[Active product flag] = INTEGER DEFAULT:1
product_created_at[Created timestamp] = TEXT

[product_image]
product_image_id[Product image ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
product_id[Linked product] = INTEGER NOT_NULL [N]
image_filename[Image filename] = TEXT NOT_NULL
image_alt_text[Image alt text] = TEXT
image_sort_order[Sort order] = INTEGER DEFAULT:0
image_is_main[Main image flag] = INTEGER DEFAULT:0

[category]
category_id[Category ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
parent_category_id[Parent category] = INTEGER [N]
category_name[Category name] = TEXT NOT_NULL
category_slug[Category slug] = TEXT UNIQUE
category_sort_order[Sort order] = INTEGER DEFAULT:0
category_is_active[Active category flag] = INTEGER DEFAULT:1

[link_product_category]
product_id[Linked product] = INTEGER NOT_NULL [N]
category_id[Linked category] = INTEGER NOT_NULL [N]
sort_order[Sort order] = INTEGER DEFAULT:0

[tag]
tag_id[Tag ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
tag_name[Tag name] = TEXT NOT_NULL UNIQUE
tag_label[Tag label] = TEXT
tag_group[Tag group] = TEXT

[link_product_tag]
product_id[Linked product] = INTEGER NOT_NULL [N]
tag_id[Linked tag] = INTEGER NOT_NULL [N]

[warehouse]
warehouse_id[Warehouse ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
warehouse_name[Warehouse name] = TEXT NOT_NULL
warehouse_code[Warehouse code] = TEXT UNIQUE
warehouse_city[Warehouse city] = TEXT
warehouse_country_code[Warehouse country code] = TEXT

[inventory]
inventory_id[Inventory ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
product_id[Linked product] = INTEGER NOT_NULL [N]
warehouse_id[Linked warehouse] = INTEGER NOT_NULL [N]
stock_quantity[Stock quantity] = INTEGER DEFAULT:0
reserved_quantity[Reserved quantity] = INTEGER DEFAULT:0
reorder_level[Reorder level] = INTEGER DEFAULT:0

[cart]
cart_id[Cart ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
customer_id[Linked customer] = INTEGER [N]
cart_session_token[Session token] = TEXT UNIQUE
cart_created_at[Created timestamp] = TEXT
cart_updated_at[Updated timestamp] = TEXT

[cart_item]
cart_item_id[Cart item ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
cart_id[Linked cart] = INTEGER NOT_NULL [N]
product_id[Linked product] = INTEGER NOT_NULL [N]
quantity[Quantity] = INTEGER NOT_NULL DEFAULT:1
unit_price[Unit price at cart time] = REAL NOT_NULL

[order_status]
order_status_id[Order status ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
order_status_name[Machine order status] = TEXT NOT_NULL UNIQUE
order_status_label[Readable order status] = TEXT NOT_NULL

[shop_order]
order_id[Order ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
customer_id[Linked customer] = INTEGER NOT_NULL [N]
order_status_id[Linked order status] = INTEGER NOT_NULL [N]
billing_address_id[Billing address reference, intentionally ambiguous] = INTEGER
shipping_address_id[Shipping address reference, intentionally ambiguous] = INTEGER
order_number[Order number] = TEXT NOT_NULL UNIQUE
order_created_at[Created timestamp] = TEXT
order_total[Order total] = REAL NOT_NULL
order_currency[Currency code] = TEXT

[order_item]
order_item_id[Order item ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
order_id[Linked order] = INTEGER NOT_NULL [N]
product_id[Linked product] = INTEGER NOT_NULL [N]
seller_id[Linked seller snapshot] = INTEGER [N]
quantity[Quantity] = INTEGER NOT_NULL
unit_price[Unit price] = REAL NOT_NULL
line_total[Line total] = REAL NOT_NULL

[payment_method]
payment_method_id[Payment method ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
payment_method_name[Machine payment method] = TEXT NOT_NULL UNIQUE
payment_method_label[Readable payment method] = TEXT NOT_NULL
payment_method_is_active[Active payment method flag] = INTEGER DEFAULT:1

[payment_status]
payment_status_id[Payment status ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
payment_status_name[Machine payment status] = TEXT NOT_NULL UNIQUE
payment_status_label[Readable payment status] = TEXT NOT_NULL

[payment]
payment_id[Payment ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
order_id[Linked order] = INTEGER NOT_NULL [N]
payment_method_id[Linked payment method] = INTEGER NOT_NULL [N]
payment_status_id[Linked payment status] = INTEGER NOT_NULL [N]
payment_provider_reference[Provider reference] = TEXT
payment_amount[Payment amount] = REAL NOT_NULL
payment_currency[Currency code] = TEXT
payment_created_at[Created timestamp] = TEXT

[shipping_method]
shipping_method_id[Shipping method ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
shipping_method_name[Machine shipping method] = TEXT NOT_NULL UNIQUE
shipping_method_label[Readable shipping method] = TEXT NOT_NULL
shipping_base_price[Base price] = REAL DEFAULT:0

[shipment_status]
shipment_status_id[Shipment status ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
shipment_status_name[Machine shipment status] = TEXT NOT_NULL UNIQUE
shipment_status_label[Readable shipment status] = TEXT NOT_NULL

[shipment]
shipment_id[Shipment ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
order_id[Linked order] = INTEGER NOT_NULL [N]
shipping_method_id[Linked shipping method] = INTEGER [N]
shipment_status_id[Linked shipment status] = INTEGER NOT_NULL [N]
tracking_number[Tracking number] = TEXT
shipment_created_at[Created timestamp] = TEXT
shipment_sent_at[Sent timestamp] = TEXT

[shipment_item]
shipment_item_id[Shipment item ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
shipment_id[Linked shipment] = INTEGER NOT_NULL [N]
order_item_id[Linked order item] = INTEGER NOT_NULL [N]
quantity[Quantity] = INTEGER NOT_NULL

[coupon]
coupon_id[Coupon ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
coupon_code[Coupon code] = TEXT NOT_NULL UNIQUE
coupon_label[Coupon label] = TEXT
discount_type[Discount type] = TEXT
discount_value[Discount value] = REAL DEFAULT:0
coupon_is_active[Active coupon flag] = INTEGER DEFAULT:1

[link_order_coupon]
order_id[Linked order] = INTEGER NOT_NULL [N]
coupon_id[Linked coupon] = INTEGER NOT_NULL [N]
discount_amount[Applied discount amount] = REAL DEFAULT:0

[review]
review_id[Review ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
customer_id[Linked customer] = INTEGER NOT_NULL [N]
product_id[Linked product] = INTEGER NOT_NULL [N]
order_item_id[Linked order item] = INTEGER [N]
review_rating[Review rating] = INTEGER NOT_NULL
review_title[Review title] = TEXT
review_text[Review text] = TEXT
review_created_at[Created timestamp] = TEXT
review_is_public[Public review flag] = INTEGER DEFAULT:1

[supplier]
supplier_id[Supplier ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
supplier_name[Supplier name] = TEXT NOT_NULL
supplier_email[Supplier email] = TEXT
supplier_country_code[Supplier country code] = TEXT

[link_supplier_product]
supplier_id[Linked supplier] = INTEGER NOT_NULL [N]
product_id[Linked product] = INTEGER NOT_NULL [N]
supplier_sku[Supplier SKU] = TEXT
supplier_price[Supplier price] = REAL

[audit_log]
audit_log_id[Audit log ID] = INTEGER PRIMARY_KEY AUTOINCREMENT [1]
actor_customer_id[Actor customer reference, intentionally not auto-clear] = INTEGER
entity_id[Generic entity ID, intentionally ambiguous] = INTEGER
entity_type[Generic entity type] = TEXT
event_name[Event name] = TEXT NOT_NULL
event_created_at[Created timestamp] = TEXT
event_payload[Payload JSON] = TEXT