rendered paste bodymysql> select * from tblAdvertisementTypes;
+---------------------+---------------------------+------------------+-------------------------+
| AdvertisementTypeID | Name | Description | AdvertisementCategoryID |
+---------------------+---------------------------+------------------+-------------------------+
| 1 | Audio Insertion | OrderSpotblocks | 3 |
| 2 | Audio Insertion /w Banner | OrderSpotblocks | 3 |
| 3 | Audio Gateway | OrderImpressions | 2 |
| 4 | Video Gateway | OrderImpressions | 2 |
| 5 | Banner | OrderClickthrus | 1 |
| 6 | Audio Gateway /w Banner | NULL | 2 |
| 7 | Third-Party Banner | OrderClickthrus | 1 |
| 8 | Third-Party Gateway | OrderImpressions | 2 |
| 9 | Video Gateway w/ Banner | NULL | 2 |
+---------------------+---------------------------+------------------+-------------------------+
mysql> select * from tblAdvertisementCategories;
+-------------------------+-----------+
| AdvertisementCategoryID | Name |
+-------------------------+-----------+
| 1 | Banner |
| 2 | Gateway |
| 3 | Insertion |
+-------------------------+-----------+