CATEGORIES

CATEGORY_ID

int(11)

Yes

NULL

Integer ID for category - used as a key

CATEGORY_ABBRV

char(1)

Yes

NULL

Abbreviated name of category

CATEGORY_TEXT

varchar(50)

Yes

NULL

Full description of category