Description
noneTable properties
| name | value |
|---|
| name | zzz_object_comments
|
| created | 3/22/2010 11:43:07 PM
|
| modified |
|
| row count | 1
|
| Size of data | 16 kb
|
| Size of indexes | 0 kb |
| average row size | 16,384 b
|
| engine | InnoDB
|
| version | 10
|
| row format | Compact
|
| max data length | 0 kb
|
| data free | 5242880
|
| auto increment |
|
| table collation | latin1_swedish_ci
|
| create options |
|
Columns
| column | datatype | length | bytes | precision | scale | default | nulls | PK | FK | UQ | extra | privileges | comment |
|---|
| LevelZeroName
| varchar(100)
| 100
| 100
|
|
|
| YES
|
|
|
|
| select,insert,update,references
|
|
| LevelZeroType
| varchar(100)
| 100
| 100
|
|
|
| YES
|
|
|
|
| select,insert,update,references
|
|
| LevelOneName
| varchar(100)
| 100
| 100
|
|
|
| YES
|
|
|
|
| select,insert,update,references
|
|
| LevelOneType
| varchar(100)
| 100
| 100
|
|
|
| YES
|
|
|
|
| select,insert,update,references
|
|
| LevelTwoName
| varchar(100)
| 100
| 100
|
|
|
| YES
|
|
|
|
| select,insert,update,references
|
|
| LevelTwoType
| varchar(100)
| 100
| 100
|
|
|
| YES
|
|
|
|
| select,insert,update,references
|
|
| PropName
| varchar(100)
| 100
| 100
|
|
|
| NO
|
|
|
|
| select,insert,update,references
|
|
| PropVal
| varchar(2048)
| 2048
| 2048
|
|
|
| NO
|
|
|
|
| select,insert,update,references
|
|
Sample rows
| LevelZeroName | LevelZeroType | LevelOneName | LevelOneType | LevelTwoName | LevelTwoType | PropName | PropVal |
|---|
|
|
| actor
| TABLE
|
|
| MS_Description
| this has all the actors
|
Code
CREATE TABLE `zzz_object_comments` (
`LevelZeroName` varchar(100) DEFAULT NULL,
`LevelZeroType` varchar(100) DEFAULT NULL,
`LevelOneName` varchar(100) DEFAULT NULL,
`LevelOneType` varchar(100) DEFAULT NULL,
`LevelTwoName` varchar(100) DEFAULT NULL,
`LevelTwoType` varchar(100) DEFAULT NULL,
`PropName` varchar(100) NOT NULL,
`PropVal` varchar(2048) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1