Field | Type | Null | Key | Default | Extra |
---|---|---|---|---|---|
Id | int(11) | NO | PRI | auto_increment | |
ClassId | int(11) | YES | |||
Name | tinytext | YES | |||
Type | enum('bool','s8','u8','s16','u16','s32','u32','float','double','date','time','string','enum') | YES | |||
Format | enum('dec','hex','oct') | YES | |||
IsMultiValue | enum('YES','NO') | YES | |||
IsNoNull | enum('YES','NO') | YES | |||
Range | tinytext | YES | |||
InitValue | tinytext | YES | |||
Description | text | YES |
Know more about the database in Database dictionary!