Documemtation

TABLE reference_doc_type
TABLE COMMENT A reference list of fisheries documentation types
ROWS 8
COLUMN
COMMENT
TYPE
LENGTH
COLUMN KEY
POSITION
IS NULL
id Unique ID used to identify entry int(11) PRI 1 NO
doc_type_code 3-Letter code used to identify document type char(3) 3 2 YES
doc_type The type of document being issued by the system varchar(180) 180 3 YES
doc_description A short description of the document varchar(255) 255 4 YES