Description:
Linking table that relates different document categories and subcategories to particular sub-agencies within DOT
Structure:
|
Field |
Type |
Null |
Default |
Comments |
|
AGENCY |
varchar(5) |
No |
|
Writing an incredibly long comment here to make sure the table handles it correctly. |
|
CATEGORY_ID |
int(11) |
No |
0 |
|
|
SUBCATEGORY_ID |
int(11) |
No |
0 |
|
Notes:
At first glance it's a little hard to tell how this is used. It relates particular document type/subtype combinations to particular agencies. It's obviously meant to be prescriptive -- which may mean that subagencies had control over which descriptive pairings could be used with "their" documents.
See also:
..