myTable

+---------------+--------------+------+-----+---------+-------+
| Field         | Type         | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| ORGID         | varchar(10)  | NO   | PRI |         |       |
| OBJTYPE       | varchar(4)   | NO   | PRI |         |       |
| SCNRTYPE      | varchar(4)   | NO   | PRI |         |       |
| FIELDNAME     | varchar(30)  | NO   | PRI |         |       |
| FIELDLABEL    | varchar(50)  | YES  |     | NULL    |       |
| DISPLAYTYPE   | varchar(4)   | YES  | MUL | NULL    |       |
| HIDDEN        | varchar(4)   | YES  | MUL | NULL    |       |
| MANDATORY     | varchar(4)   | YES  | MUL | NULL    |       |
| COLOR         | varchar(4)   | YES  | MUL | NULL    |       |
| ICONFILE      | varchar(255) | YES  |     | NULL    |       |
| CREATEDBY     | varchar(12)  | YES  | MUL | NULL    |       |
| CREATEDON     | date         | YES  |     | NULL    |       |
| UPDATEDBY     | varchar(12)  | YES  | MUL | NULL    |       |
| UPDATEDON     | date         | YES  |     | NULL    |       |
| dataType      | char(8)      | YES  |     | NULL    |       |
| PARAMETER     | varchar(30)  | YES  |     | NULL    |       |
+---------------+--------------+------+-----+---------+-------+