1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
| CREATE TABLE `messagecro` (
`MessageId` int(11) NOT NULL,
`HeaderVersion` float NOT NULL,
`HeaderTestId` int(11) NOT NULL,
`HeaderLaRefId` int(11) NOT NULL,
`HeaderSentAt` datetime NOT NULL,
`HeaderFrom` varchar(25) NOT NULL,
`HeaderTo` varchar(5) NOT NULL,
`VesselIdentificationCallSign` varchar(10) NOT NULL,
`VesselIdentificationImoNumber` int(11) NOT NULL,
`VesselIdentificationImmatriculation` varchar(15) NOT NULL,
`VesselIdentificationMMSINumber` int(11) NOT NULL,
`VesselIdentificationShipName` varchar(50) NOT NULL,
`VesselIdentificationShipCategory` int(11) NOT NULL,
`VesselIdentificationMerchantType` varchar(30) NOT NULL,
`VesselIdentificationFlag` varchar(5) NOT NULL,
`VoyageInformationPortOfCall` varchar(10) NOT NULL,
`VoyageInformationNextPortOfCall` varchar(10) NOT NULL,
`VoyageInformationETA` datetime NOT NULL,
`VoyageInformationTotalPassenger` int(11) NOT NULL,
`VoyageInformationCrewNumber` int(11) NOT NULL,
`VoyageInformationTotalClandestine` int(11) NOT NULL,
`VoyageInformationReportingDateAndTime` datetime NOT NULL,
`VoyageInformationCOG` int(11) NOT NULL,
`VoyageInformationSOG` int(11) NOT NULL,
`VoyageInformationNavigationStatus` int(11) NOT NULL,
`VoyageInformationDraught` int(11) NOT NULL,
`VoyageInformationLane` varchar(20) NOT NULL,
`VoyageInformationTrakNumber` int(11) NOT NULL,
`VoyageInformationObservations` varchar(70) NOT NULL,
`VoyageInformationTowing` varchar(25) NOT NULL,
`VoyageInformationTowLenght` int(11) NOT NULL,
`VoyageInformationTowCategory` varchar(25) NOT NULL,
`PositionLongitude` int(11) NOT NULL,
`PositionLatitude` int(11) NOT NULL,
`CargoInformationTotalQuantity` int(11) NOT NULL,
`CargoInformationUnitOfMeasurement` varchar(5) NOT NULL,
`CargoInformationBallast` int(11) NOT NULL,
`CargoInformationAnyDG` int(11) NOT NULL,
`DGDetailsIMOClass` int(11) NOT NULL,
`DGDetailsQuantity` float NOT NULL,
`DGDetailsComplement` varchar(35) NOT NULL,
`DGDetailsUnitOfMeasurement` varchar(35) NOT NULL,
`SouteInformationGOCompartment` int(11) NOT NULL,
`SouteInformationFOCompartment` int(11) NOT NULL,
`SouteInformationDOCompartment` int(11) NOT NULL,
`SouteInformationLOCompartment` int(11) NOT NULL,
`SouteInformationFSFOCompartment` int(11) NOT NULL,
`SouteInformationLSFOCompartment` int(11) NOT NULL,
`SouteInformationDOUnitOfMeasurement` int(11) NOT NULL,
`SouteInformationFOUnitOfMeasurement` int(11) NOT NULL,
`SouteInformationGOUnitOfMeasurement` int(11) NOT NULL,
`SouteInformationLOUnitOfMeasurement` int(11) NOT NULL,
`URLDetailsUrl` varchar(35) NOT NULL,
`URLDetailsDocType` varchar(35) NOT NULL,
`ContactDetailLastName` varchar(35) NOT NULL,
`ContactDetailsFirstName` varchar(35) NOT NULL,
`ContactDetailsLocode` varchar(35) NOT NULL,
`ContactDetailsPhone` int(11) NOT NULL,
`ContactDetailsFax` int(11) NOT NULL,
`ContactDetailsEmail` varchar(35) NOT NULL,
`CargoOfInterestCargoOfInterestCategory` varchar(35) NOT NULL,
`CargoOfInterestQuantity` float NOT NULL,
`CargoOfInterestUnitOfMeasurement` varchar(35) NOT NULL,
KEY `MessageId` (`MessageId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
Partager