ListItems - netnutmike/subracetracker GitHub Wiki

Description

This table holds the list item details for the lists that are defined in Lists.

Field Descriptions

uid

The unique record ID.

ListID

The uid of the list that this record belongs to.

ListItem

The display value for this list item.

IntValue

The integer value associated with this list item (if any).

CharVal

The char value associated with this list item (if any).

Status

The status of this list item. Normally Enabled or Disabled.

Table Layout

+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| uid      | int(11)     | NO   | PRI | NULL    | auto_increment |
| ListID   | int(11)     | YES  |     | NULL    |                |
| ListItem | varchar(30) | YES  |     | NULL    |                |
| IntValue | int(11)     | YES  |     | NULL    |                |
| CharVal  | varchar(20) | YES  |     | NULL    |                |
| Status   | int(11)     | YES  |     | NULL    |                |
+----------+-------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)

Creation Script

create table ListItems (uid int auto_increment, ListID int, ListItem varchar(30), IntValue int, CharVal varchar(20), Status int, primary key(uid));