Description of a lookup table
Lookup table giving a list of sub-agencies within DOT, using the values here
|
Field |
Type |
Null |
Default |
Comments |
|
AGENCY |
varchar(5) |
No |
Vocabulary used to describe the various subagencies within DOT that appear in the database
AGENCY | DESCRIP |
OST |
|
Field |
Type |
Null |
Default |
Comments |
|---|---|---|---|---|
|
CATEGORY_ID |
int(11) |
Yes |
NULL |
Integer ID for category - used as a key |
CATEGORY_ID | CATEGORY_ABBRV | CATEGORY_TEXT | Comments |
1 | C | Complaint | |
2 | L | License | |
3 | O | Other | |
4 | N | Non-Rulemaking |
