Table: nornix_system.classattrcoll

Structure
Name	Type	Null	Key	Default	Extra
No	int(10) unsigned	NO	PRI		auto_increment
ClassAttributeNo	int(10) unsigned	NO		0
SubAttr	varchar(48)	YES	MUL
AttrTypeNo	int(10) unsigned	NO		0
LabelNo	int(10) unsigned	YES
DescNo	int(10) unsigned	YES
Multiple	tinyint(1) unsigned	NO		0
Default	varchar(255)	YES

Indexes
Non-unique	Key	Seq	Column	Collation	Cardinality	Sub part	Packed	Null	Type	Comment
0	ClassAttrSubattr	2	ClassAttributeNo	A					BTREE

Information
Engine	Row format	Table collation	Create options
MyISAM	Dynamic	utf8_general_ci

CREATE TABLE `classattrcoll` (
  `No` int(10) unsigned NOT NULL auto_increment,
  `ClassAttributeNo` int(10) unsigned NOT NULL default '',
  `SubAttr` varchar(48) default NULL,
  `AttrTypeNo` int(10) unsigned NOT NULL default '',
  `LabelNo` int(10) unsigned default NULL,
  `DescNo` int(10) unsigned default NULL,
  `Multiple` tinyint(1) unsigned NOT NULL default '',
  `Default` varchar(255) default NULL,
  PRIMARY KEY  (`No`),
  UNIQUE KEY `ClassAttrSubattr` (`SubAttr`,`ClassAttributeNo`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8