CREATE TABLE `SCREEN_SAMPLE_0906_DATA` (
  `ITEM` varchar(50) NOT NULL,
  `COLOR` varchar(50) NOT NULL,
  `SIZE` varchar(50) NOT NULL,
  `ZAIKO_SU` decimal(10,0) DEFAULT NULL,
  `CREATED_DATE` datetime DEFAULT NULL,
  `CREATED_BY` varchar(50) DEFAULT NULL,
  `CREATED_PRG_NM` varchar(50) DEFAULT NULL,
  `UPDATED_DATE` datetime DEFAULT NULL,
  `UPDATED_BY` varchar(50) DEFAULT NULL,
  `UPDATED_PRG_NM` varchar(50) DEFAULT NULL,
  `MODIFY_COUNT` int(10) DEFAULT NULL,
  PRIMARY KEY (`ITEM`,`COLOR`,`SIZE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `SCREEN_SAMPLE_0906_WORK` (
  `ITEM` varchar(50) NOT NULL,
  `COLOR` varchar(50) NOT NULL,
  `SIZE_S_ZAIKO_SU` decimal(10,0) DEFAULT NULL,
  `SIZE_M_ZAIKO_SU` decimal(10,0) DEFAULT NULL,
  `SIZE_L_ZAIKO_SU` decimal(10,0) DEFAULT NULL,
  `SORT_NO` decimal(5,0) DEFAULT NULL,
  PRIMARY KEY (`ITEM`,`COLOR`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

