Lists - netnutmike/subracetracker GitHub Wiki

Description

This table holds the names and ids of the lists that can be used in the sub tracker application

Field Descriptions

uid

The unique record ID. This id is used to tie the list items to this list.

ListName

The Name of the list in this record.

SortBy

This is the field to sort the list by. IT goes by the field order in the ListItems table. So 0 (default) is ListItem or the text of the item, 1 is IntValue, 2 is CharValue.

SortOrder

This select the sort order of the list based on the SortBy. 0 which is default is ascending and 1 is descending.

Table Layout

+-----------+-------------+------+-----+---------+----------------+
| Field     | Type        | Null | Key | Default | Extra          |
+-----------+-------------+------+-----+---------+----------------+
| uid       | int(11)     | NO   | PRI | NULL    | auto_increment |
| ListName  | varchar(25) | YES  |     | NULL    |                |
| SortBy    | int(11)     | YES  |     | NULL    |                |
| Sortorder | int(11)     | YES  |     | NULL    |                |
+-----------+-------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

Creation Script

create table Lists (uid int auto_increment, ListName varchar(25), SortBy int, Sortorder int, primary key(uid));

Latest Dataset

+-----+--------------------+--------+-----------+
| uid | ListName           | SortBy | Sortorder |
+-----+--------------------+--------+-----------+
|   1 | Team Status        |      1 |         1 |
|   2 | Participant Status |      1 |         1 |
|   3 | Race Status        |      1 |         1 |
|   4 | History Action     |      1 |         1 |
|   5 | Race Class         |      1 |         1 |
|   6 | Team Class         |      1 |         1 |
+-----+--------------------+--------+-----------+
6 rows in set (0.00 sec)