Table: nornix_system.classattribute
Structure Name | Type | Null | Key | Default | Extra | Comment |
---|
No | int(10) unsigned | NO | PRI | | auto_increment | |
---|
ClassNo | int(10) unsigned | NO | MUL | 0 | | |
---|
Attribute | varchar(48) | NO | | | | |
---|
IndexesNon-unique | Key | Seq | Column | Collation | Cardinality | Sub part | Packed | Null | Type | Comment |
---|
0 | ClassAttribute | 2 | Attribute | A | 0 | | | | BTREE | |
InformationEngine | Row format | Table collation | Create options |
---|
MyISAM | Dynamic | utf8_general_ci | |
CREATE TABLE `classattribute` (
`No` int(10) unsigned NOT NULL auto_increment,
`ClassNo` int(10) unsigned NOT NULL default '',
`Attribute` varchar(48) NOT NULL,
PRIMARY KEY (`No`),
UNIQUE KEY `ClassAttribute` (`ClassNo`,`Attribute`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8