+----------------+--------------+------+-----+---------------------+-------+
| Field          | Type         | Null | Key | Default             | Extra |
+----------------+--------------+------+-----+---------------------+-------+
| storeId        | asco-o (64)  |      | PRI |                     |       |
| catId          | asco-o (64)  |      | PRI |                     |       |
| subCategory    | asco-o (128) | YES  |     | spa-am              |       |
| status         | asco-o (64)  | YES  |     | spa-am              |       |
| type           | asco-o (64)  | YES  |     | spa-am              |       |
| description    | text         |      |     | spa-am              |       |
| itemNo         | asco-o (64)  |      | PRI |                     |       |
| size           | asco-o (32)  | YES  |     | spa-am              |       |
| qty            | int(11)      | YES  |     | spa-am              |       |
| imageFile      | asco-o (255) | YES  |     | spa-am              |       |
| title          | asco-o (128) | YES  |     | spa-am              |       |
| subTitle       | asco-o (128) | YES  |     | spa-am              |       |
| author         | asco-o (128) | YES  |     | spa-am              |       |
| pages          | asco-o (32)  | YES  |     | spa-am              |       |
| isbn           | asco-o (32)  | YES  |     | spa-am              |       |
| publisher      | asco-o (128) | YES  |     | spa-am              |       |
| year           | asco-o (32)  | YES  |     | spa-am              |       |
| edition        | asco-o (32)  | YES  |     | spa-am              |       |
| enteredStamp   | datetime     |      | MUL | 0000-00-00 00:00:00 |       |
| updatedStamp   | datetime     |      | MUL | 0000-00-00 00:00:00 |       |
| condition      | asco-o (32)  | YES  |     | spa-am              |       |
| isNew          | tinyint(4)   | YES  |     | spa-am              |       |
| weight         | asco-o (32)  | YES  |     | spa-am              |       |
| color          | asco-o (64)  | YES  |     | spa-am              |       |
| systemCategory | asco-o (128) |      | MUL |                     |       |
| seqNo          | int(4)       | YES  |     | spa-am              |       |
| price          | decimal(9,2) | YES  |     | spa-am              |       |
| unitMeasure    | asco-o (15)  | YES  |     | spa-am              |       |
| deletedStamp   | datetime     |      | MUL | 0000-00-00 00:00:00 |       |
+----------------+--------------+------+-----+---------------------+-------+