Documemtation

TABLE reference_entity_type
TABLE COMMENT A reference list of entities / assets that should be monitored by fisheries agencies
ROWS 9
COLUMN
COMMENT
TYPE
LENGTH
COLUMN KEY
POSITION
IS NULL
id Unique ID used to identify entity entry int(11) unsigned PRI 1 NO
entity_type distinct and independent objects varchar(120) 120 2 NO
entity_class A list of the different types of entity that need to be tracked in a system enum('ASSET','ENTITY') 6 3 YES