DROP TABLE IF EXISTS `BusinessCust`;
CREATE TABLE `BusinessCust` (
id int(11) NOT NULL,
BusinessID int(11) DEFAULT NULL,
CustID varchar(50) DEFAULT NULL,
Code varchar(15) DEFAULT NULL,
Name varchar(31) DEFAULT NULL,
DataType int(11) DEFAULT NULL,
Price int(11) DEFAULT NULL,
ShopID int(11) DEFAULT NULL,
BirthDay datetime DEFAULT NULL,
LastStoreDay datetime DEFAULT NULL,
TermDay datetime DEFAULT NULL,
Point int(11) DEFAULT NULL,
ComingStore int(11) DEFAULT NULL,
SalesMoney int(11) DEFAULT NULL,
Memo varchar(50) DEFAULT NULL,) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
ALTER TABLE `BusinessCust` ADD PRIMARY KEY (`id`);