< Calendar   (Previous) Table of Contents (Next)   Calendar: Form >

Calendar: Tables

Table Structure

mysql> select CalendarID, CategoryIDCSV, Title, TimeStart from 2003_Calendar;
+------------+---------------+------------------+-----------+
| CalendarID | CategoryIDCSV | Title            | TimeStart |
+------------+---------------+------------------+-----------+
|          1 | 10,15         | Bridges by Night | 20:00:00  |
+------------+---------------+------------------+-----------+


mysql> select * from 2003_CalendarCategories;
+------------+------------+
| CategoryID | CalendarID |
+------------+------------+
|         10 |          1 |
|         15 |          1 |
+------------+------------+

mysql> select * from 2003_Categories;
+------------+----------+--------+
| CategoryID | Category | Active |
+------------+----------+--------+
|         10 | Ride     | Y      |
|         15 | +FREE    | Y      |
+------------+----------+--------+