| Field            | Type                 | Null | Key | Default             | Extra          |
+------------------+----------------------+------+-----+---------------------+----------------+
| ID               | int(8) unsigned      |      | PRI | NULL                | auto_increment |
| START_DATE       | datetime             |      | PRI | 0000-00-00 00:00:00 |                |
| END_DATE         | datetime             |      | PRI | 0000-00-00 00:00:00 |                |
| IS_RECURRING     | smallint(1) unsigned |      |     | 0                   |                |
| Mo               | smallint(1)          |      |     | 0                   |                |
| Tu               | smallint(1) unsigned |      |     | 0                   |                |
| We               | smallint(1) unsigned |      |     | 0                   |                |
| Th               | smallint(1) unsigned |      |     | 0                   |                |
| Fr               | smallint(1) unsigned |      |     | 0                   |                |
| Sa               | smallint(1) unsigned |      |     | 0                   |                |
| Su               | smallint(1) unsigned |      |     | 0                   |                |
| DRESS_CODE       | varchar(255)         |      |     | 0                   |                |
| SERVICE_CATEGORY | varchar(255)         | YES  |     | 0                   |                |
| SERVICE_TYPE     | int(8)               |      | PRI | 0                   |                |
| TITLE            | varchar(255)         |      |     |                     |                |
| LOCATION         | int(8)               |      | PRI | 0                   |                |
| LINKID           | varchar(50)          |      | PRI |                     |                |
| PARTICIPATORS    | text                 | YES  |     | NULL                |                |
| COMMENTS         | text                 | YES  |     | NULL                |                |
| DATE             | datetime             | YES  |     | NULL                |                |
| CREATEDBY        | int(8)               |      | PRI | 0                   |                |
| FULL             | int(2)               |      |     | 0                   |                |
| NTERPS           | int(3)               |      |     | 0                   |                |
| AUDIENCE_SIZE    | varchar(50)          |      |     | 0                   |                |
| ATTACHMENTS      | varchar(255)         | YES  |     | NULL                |                |
| JOBID            | varchar(255)         | YES  |     | NULL                |                |
| INVOICEID        | int(11)              |      |     | 0                   |                |
| INVOICEDATE      | datetime             | YES  |     | NULL                |                |
| PRAC_NEEDED      | int(2)               |      |     | 2                   |                |
| FLAG             | int(2)               |      |     | 0                   |                |
| DIFFERENTIAL     | varchar(6)           |      |     | 0.00                |                |
| MODIFIED         | int(11)              | YES  |     | NULL                |                |
| MODIFIEDBY       | int(11)              |      | PRI | 0                   |                |
| F_MILEAGE        | varchar(6)           |      |     | 0.00                |                |
| F_PARKING        | varchar(6)           |      |     | 0.00                |                |
| F_AIRFARE        | varchar(6)           |      |     | 0.00                |                |
| F_DIFFERENTIAL   | varchar(6)           |      |     | 0.00                |                |
| F_MISC           | varchar(6)           |      |     | 0.00                |                |
| C_MILEAGE        | tinyint(1)           |      |     | 0                   |                |
| C_AIRFARE        | tinyint(1)           |      |     | 0                   |                |
| C_PARKING        | tinyint(1)           |      |     | 0                   |                |
| C_MISC           | tinyint(1)           |      |     | 0                   |                |
| MILEAGE_RATE     | varchar(255)         |      |     | .3650               |                |
+------------------+----------------------+------+-----+---------------------+----------------+
43 rows in set (0.00 sec)