mysql> show columns from metadata;
+---------------------+-------------------------------------+------+-----+---------+----------------
+
| Field | Type | Null | Key | Default | Extra
|
+---------------------+-------------------------------------+------+-----+---------+----------------
+
| serial_num | int(11) | | PRI | NULL | auto_increment
|
| instrument | varchar(20) | YES | | NULL |
|
| calib_type | varchar(40) | YES | | NULL |
|
| calib_type_num | int(11) | YES | | NULL |
|
| data_format | varchar(20) | | | |
|
| format_version | varchar(20) | YES | | NULL |
|
| data_id | varchar(40) | YES | | NULL |
|
| data_size | int(11) | YES | | NULL |
|
| validity_start_time | datetime | YES | | NULL |
|
| validity_end_time | datetime | YES | | NULL |
|
| proc_time | datetime | YES | | NULL |
|
| proc_level | enum('TEST','DEVELOPMENT', | YES | | NULL |
| | 'PRODUCTION','SUPERSEDED') |
|
| calib_status | enum('OK','INCOMPLETE','ABORTED') | YES | | NULL |
|
| creator | varchar(40) | YES | | NULL |
|
| input_desc | varchar(255) | YES | | NULL |
|
| calib_file_name | varchar(255) | | | |
|
| comments | varchar(255) | YES | | NULL |
|
+---------------------+-------------------------------------+------+-----+---------+----------------
+
17 rows in set (0.00 sec)