21 lines
1.0 KiB
SQL
21 lines
1.0 KiB
SQL
CREATE TABLE `ecommerce_orders` (
|
|
`order_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'UUID from CSV',
|
|
`customer_id` int NOT NULL,
|
|
`product_id` int NOT NULL,
|
|
`category` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`price` decimal(10,2) NOT NULL,
|
|
`quantity` int NOT NULL,
|
|
`order_date` datetime(6) NOT NULL,
|
|
`shipping_date` datetime(6) NOT NULL,
|
|
`delivery_status` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`payment_method` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`device_type` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`channel` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`shipping_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`billing_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`customer_segment` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
PRIMARY KEY (`order_id`),
|
|
KEY `idx_customer` (`customer_id`),
|
|
KEY `idx_product` (`product_id`),
|
|
KEY `idx_order_date` (`order_date`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |