-- Clora marketplace SQL companion (authoritative structure is in Laravel migrations)
-- Use: database/migrations/2026_03_08_060000_create_clora_marketplace_tables.php

CREATE DATABASE IF NOT EXISTS clora_marketplace;
USE clora_marketplace;

-- Core entity table list
-- users, vendors, vendor_applications, categories, products, product_images, product_variants,
-- coupons, reviews, wishlists, carts, cart_items, orders, order_items, payments, shipments,
-- return_requests, vendor_settlements, analytics_events, video_library_items,
-- teleconsultations, period_entries, clo_conversations

-- Run complete schema using Laravel migration pipeline:
-- php artisan migrate
