mysql> SHOW FIELDS FROM inventar;
+------------------+---------+------+-----+---------+----------------+
| Field            | Type    | Null | Key | Default | Extra          |
+------------------+---------+------+-----+---------+----------------+
| ReferenzNr       | int(11) |      | PRI | NULL    | auto_increment |
| ProdID           | int(11) | YES  |     | NULL    |                |
| Art              | text    | YES  |     | NULL    |                |
| SerienNr         | text    | YES  |     | NULL    |                |
| LiefID           | int(11) | YES  |     | NULL    |                |
| KatID            | int(11) | YES  |     | NULL    |                |
| Rechnungsdatum   | date    | YES  |     | NULL    |                |
| Rechnungsnummer  | int(11) | YES  |     | NULL    |                |
| ZurZeitbei       | text    | YES  |     | NULL    |                |
| Bemerkung        | text    | YES  |     | NULL    |                |
| Anschaffungswert | int(11) | YES  |     | NULL    |                |
| Standort         | text    | YES  |     | NULL    |                |
| abtid            | int(11) | YES  |     | NULL    |                |
| Erfassungsdatum  | date    | YES  |     | NULL    |                |
| servicetag       | text    | YES  |     | NULL    |                |
| exservcode       | text    | YES  |     | NULL    |                |
| cd1pos           | int(11) | YES  | MUL | NULL    |                |
| cd2pos           | int(11) | YES  |     | NULL    |                |
| cdmodul          | text    | YES  |     | NULL    |                |
| cd3pos           | int(11) | YES  |     | NULL    |                |
| cdsprache        | text    | YES  |     | NULL    |                |
+------------------+---------+------+-----+---------+----------------+
21 rows in set (0.05 sec)