DROP TABLE IF EXISTS `sale_sending_order`;
CREATE TABLE `sale_sending_order` (
                                      `id` int NOT NULL AUTO_INCREMENT,
                                      `user_id` int NOT NULL,
                                      `sales_id` int DEFAULT NULL,
                                      `staff_id` int DEFAULT NULL,
                                      `control_staff_id` int DEFAULT NULL,
                                      `user_code` varchar(50) DEFAULT NULL,
                                      `user_name` varchar(150) DEFAULT NULL,
                                      `zone` varchar(75) DEFAULT NULL,
                                      `district` varchar(75) DEFAULT NULL,
                                      `item_count` int DEFAULT NULL,
                                      `item_total` int DEFAULT NULL,
                                      `status` tinyint(1) NOT NULL DEFAULT '0',
                                      `insert_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
                                      `shop_id` int DEFAULT NULL,
                                      `start_date` datetime DEFAULT NULL,
                                      `finished_date` datetime DEFAULT NULL,
                                      `control_start_date` datetime DEFAULT NULL,
                                      `control_finished_date` datetime DEFAULT NULL,
                                      PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;