Table: nornix_site.property

Structure
Name	Type	Null	Key	Default
DocumentNo	int(10) unsigned	NO	PRI
Class	varchar(32)	NO	PRI
Attribute	varchar(48)	NO	PRI
Cascade	tinyint(1)	NO
Multiple	tinyint(1)	NO
SortOrder	int(10) unsigned	NO	PRI	0
Value	varchar(255)	NO

Indexes
Non-unique	Key	Seq	Column	Collation	Cardinality	Sub part	Packed	Null	Type	Comment
0	DocClassAttrSort	4	SortOrder	A	2				BTREE

Information
Engine	Row format	Table collation	Create options
MyISAM	Dynamic	utf8_general_ci

CREATE TABLE `property` (
  `DocumentNo` int(10) unsigned NOT NULL,
  `Class` varchar(32) NOT NULL,
  `Attribute` varchar(48) NOT NULL,
  `Cascade` tinyint(1) NOT NULL,
  `Multiple` tinyint(1) NOT NULL,
  `SortOrder` int(10) unsigned NOT NULL default '',
  `Value` varchar(255) NOT NULL,
  UNIQUE KEY `DocClassAttrSort` (`DocumentNo`,`Class`,`Attribute`,`SortOrder`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8