Documemtation

TABLE reference_vessel_clav
TABLE COMMENT
ROWS 48061
COLUMN
COMMENT
TYPE
LENGTH
COLUMN KEY
POSITION
IS NULL
VRMFID int(11) PRI 1 NO
Source varchar(20) 20 2 YES
DateUpdated datetime 3 YES
VesselID varchar(30) 30 MUL 4 YES
TUVI int(11) 5 YES
VesselName varchar(80) 80 MUL 6 YES
FlagCode char(3) 3 7 YES
ParentVesselTypeCode varchar(3) 3 8 YES
ParentVesselType varchar(255) 255 9 YES
VesselTypeCode varchar(3) 3 10 YES
VesselType varchar(255) 255 11 YES
GearTypeCode varchar(3) 3 12 YES
GearType varchar(255) 255 13 YES
Length decimal(11,4) 14 YES
LengthTypeCode varchar(5) 5 15 YES
IRCS char(35) 35 MUL 16 YES
NRN varchar(100) 100 17 YES
IMO int(11) MUL 18 YES
Tonnage decimal(11,4) 19 YES
TonnageTypeCode varchar(255) 255 20 YES
PreviousName varchar(255) 255 21 YES
PreviousNameDate datetime 22 YES
PreviousFlagCode varchar(3) 3 23 YES
PreviousFlagCodeDate date 24 YES
AutStatus varchar(255) 255 25 YES
DateAutStart datetime 26 YES
DateAutEnd datetime 27 YES
DateAutTerm datetime 28 YES
AutTermCode int(11) 29 YES
AutTermDescription varchar(255) 255 30 YES
AutTermReason varchar(255) 255 31 YES
URLID int(11) 32 YES