_gwm_list_values - GolfWithMe/Master GitHub Wiki

Description

This table holds the values for each of the lists.

Field Descriptions

uid

The unique record ID

List ID

This is the id of the list that this entry belongs to

Title

This is the value that displays in a drop down, list, etc.

intValue1

This is the primary value used if the information needed when an item is selected is an integer.

intValue2

This is a secondary value used if the information needed when an item is selected is an integer.

CharValue1

This is the primary value used if the information needed when an item is selected is a char.

CharValue2

This is a secondary value used if the information needed when an item is selected is a char.

Status

This is the status of the entry. 0 = disabled, 1 = enabled

Table Layout

+------------+-------------+------+-----+---------+----------------+
| Field      | Type        | Null | Key | Default | Extra          |
+------------+-------------+------+-----+---------+----------------+
| uid        | int(11)     | NO   | PRI | NULL    | auto_increment |
| ListID     | int(11)     | YES  |     | NULL    |                |
| Title      | varchar(50) | YES  |     | NULL    |                |
| intValue1  | int(11)     | YES  |     | NULL    |                |
| intValue2  | int(11)     | YES  |     | NULL    |                |
| Charvalue1 | varchar(50) | YES  |     | NULL    |                |
| Charvalue2 | varchar(50) | YES  |     | NULL    |                |
| Status     | int(11)     | YES  |     | NULL    |                |
+------------+-------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)

Creation Script

create table _gwm_list_values (uid int auto_increment, ListID int, Title varchar(50), intValue1 int, intValue2 int, Charvalue1 varchar(50), Charvalue2 varchar(50), Status int, primary key(uid));