Table: nornix_system.attributetype
Structure | Name | Type | Null | Key | Default | Extra | Comment |
|---|
| No | int(10) unsigned | NO | PRI | | auto_increment | |
|---|
| Name | varchar(48) | NO | UNI | | | |
|---|
| NameNo | int(10) unsigned | YES | | | | |
|---|
| TitleNo | int(10) unsigned | YES | | | | |
|---|
Indexes| Non-unique | Key | Seq | Column | Collation | Cardinality | Sub part | Packed | Null | Type | Comment |
|---|
| 0 | Name | 1 | Name | A | 12 | | | | BTREE | |
Information| Engine | Row format | Table collation | Create options |
|---|
| MyISAM | Dynamic | utf8_general_ci | |
CREATE TABLE `attributetype` (
`No` int(10) unsigned NOT NULL auto_increment,
`Name` varchar(48) NOT NULL,
`NameNo` int(10) unsigned default NULL,
`TitleNo` int(10) unsigned default NULL,
PRIMARY KEY (`No`),
UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8