CREATE TABLE `TLN_TIPS_0024_JYUCYU` (
  `JYUCYU_NO` varchar(12) NOT NULL DEFAULT '',
  `ITEM_CODE` varchar(30) DEFAULT NULL,
  `SMPL_CUST_CODE` varchar(2) DEFAULT NULL,
  `NOKI_DATE` datetime DEFAULT NULL,
  `SHIP_DATE` datetime DEFAULT NULL,
  `JYUCYU_SU` int(6) NOT NULL,
  `SMPL_J_STATUS` varchar(2) DEFAULT NULL,
  `TANKA` decimal(8,2) NOT NULL,
  `SMPL_TANKA_KBN` varchar(2) NOT NULL,
  `KINGAKU` int(8) NOT NULL,
  `NOTE` varchar(600) DEFAULT NULL,
  `PRINT_DATE` datetime 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 (`JYUCYU_NO`)
) 
;

CREATE TABLE `TLN_TIPS_0024_MST_ITEM` (
  `ITEM_CODE` varchar(30) NOT NULL DEFAULT '',
  `ITEM_NM` varchar(100) DEFAULT NULL,
  `SMPL_ITEM_KBN` varchar(20) DEFAULT NULL,
  `ITEM_SIZE` decimal(10,2) DEFAULT NULL,
  `SMPL_SIZE_KBN` varchar(2) DEFAULT NULL,
  `END_FLG` varchar(2) 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,
  `FILE_IMAGE` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`ITEM_CODE`)
) 
;
