DOTDMS table documentation

These are the tables found in the DOTDMS database. Tables with links have had documentation pages built (though those are not necessarily complete):

• Primary data tables
  • DDMS_DOCKETS: Dockets
  • DDMS_DOCUMENTS: Documents found in dockets
  • USER_INFORMATION: Comment submitters and others
• Linking tables
  • AGENCY_CAT_SUBCAT: Allowable document categories and subcategories, by agency.
  • AGENCY_DOCTYPE_XREF
  • CFR_XREF
  • DOCKET_DOCUMENT_XREF
  • SUBMITTER_XREF
  • SUBMITTERSREP_XREF
• Lookup tables
  • AGENCIES: Sub-agencies within DOT [values]
  • CATEGORIES: Document classes [values]
  • CFR: Sections of CFR affecting different documents [values]
  • DOCUMENT_SUBTYPES: [values]
  • DOCUMENT_TYPES: [values]
  • FILE_TYPES: [values]
  • SUBCATEGORIES: [values]

..