CREATE TABLE `db_ValidParam` (
`entityType` varchar(20) NOT NULL,
`name` varchar(30) NOT NULL,
`displayStr` varchar(50) NOT NULL,
`displaySeqNo` int(11) default NULL,
`paramType` varchar(20) NOT NULL,
`uniqueYN` char(1) NOT NULL,
`optionalYN` char(1) NOT NULL,
`multipleYN` char(1) NOT NULL,
`readOnlyYN` char(1) default NULL,
`formatStr` varchar(50) default NULL,
`standardVv` varchar(30) default NULL,
`historyPeriod` int(11) default NULL,
`collapseGroup` char(30) default NULL,
UNIQUE KEY `type_pk` (`entityType`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |