DROP TABLE IF EXISTS `sales_paying_history`;
CREATE TABLE `sales_paying_history` (
                                        `id` int NOT NULL AUTO_INCREMENT,
                                        `sales_id` int DEFAULT NULL,
                                        `user_id` int DEFAULT NULL,
                                        `paying_status_id` int DEFAULT NULL,
                                        `payment_code` varchar(20) DEFAULT NULL,
                                        `payment_name` varchar(50) DEFAULT NULL,
                                        `note` text,
                                        `pending_date` date DEFAULT NULL,
                                        `complate_date` date DEFAULT NULL,
                                        `date_added` datetime DEFAULT NULL,
                                        PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;