Table: nornix_system.classattrcoll

Structure
NameTypeNullKeyDefaultExtraComment
Noint(10) unsignedNOPRIauto_increment
ClassAttributeNoint(10) unsignedNO0
SubAttrvarchar(48)YESMUL
AttrTypeNoint(10) unsignedNO0
LabelNoint(10) unsignedYES
DescNoint(10) unsignedYES
Multipletinyint(1) unsignedNO0
Defaultvarchar(255)YES
Indexes
Non-uniqueKeySeqColumnCollationCardinalitySub partPackedNullTypeComment
0ClassAttrSubattr2ClassAttributeNoABTREE
Information
EngineRow formatTable collationCreate options
MyISAMDynamicutf8_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