Ocean tbl
From UG
(Difference between revisions)
(3 intermediate revisions not shown) | |||
Line 226: | Line 226: | ||
=== Voyage1 === | === Voyage1 === | ||
+ | |||
+ | varchar(30) DEFAULT NULL, | ||
+ | |||
+ | === FeederVesselname === | ||
` varchar(30) DEFAULT NULL, | ` varchar(30) DEFAULT NULL, | ||
- | + | ||
- | + | ||
- | + | === Voyage2 === | |
+ | |||
` varchar(30) DEFAULT NULL, | ` varchar(30) DEFAULT NULL, | ||
Line 280: | Line 285: | ||
`ExportCustoms` varchar(30) DEFAULT NULL, | `ExportCustoms` varchar(30) DEFAULT NULL, | ||
`ActualDeliveryDateEnabled` tinyint(1) DEFAULT '0', | `ActualDeliveryDateEnabled` tinyint(1) DEFAULT '0', | ||
+ | |||
+ | === DeliveryInstructions === | ||
+ | |||
+ | varchar(1500) DEFAULT NULL |
Current revision as of 19:48, 22 February 2010
Contents |
[edit] Related bo wiki
[edit] MySQL Table Definitions
on 02-Feb-2010
mysql> describe tblOceanShipment; +-------------------------------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------------------+---------------+------+-----+---------+----------------+ | OceanShipmentId | int(10) | NO | PRI | NULL | auto_increment | | GenericShipmentId | int(10) | NO | MUL | NULL | | | Hazardous | tinyint(1) | NO | | 0 | | | HazardousNote | varchar(1500) | YES | | NULL | | | Freight | int(1) | YES | | 0 | | | MoveTypeId | int(10) | YES | MUL | NULL | | | OriginalHouseBill | int(1) | YES | | 0 | | | SteamshiplineId | int(10) | YES | MUL | NULL | | | CoLoaderOceanId | int(10) | YES | MUL | NULL | | | Booking | varchar(30) | YES | | NULL | | | MasterBill | varchar(30) | YES | | NULL | | | AMSSubmissionDate | date | YES | | NULL | | | VesselName | varchar(30) | YES | | NULL | | | Voyage1 | varchar(30) | YES | | NULL | | | FeederVesselname | varchar(30) | YES | | NULL | | | Voyage2 | varchar(30) | YES | | NULL | | | OriginalTerminalId | int(10) | YES | MUL | NULL | | | OriginalTerminalETD | date | YES | | NULL | | | OriginalTerminalATD | date | YES | | NULL | | | PortOfLoadingId | int(10) | YES | MUL | NULL | | | PortOfLoadingETD | date | YES | | NULL | | | PortOfLoadingATD | date | YES | | NULL | | | PortOfTransShipmentId | int(10) | YES | MUL | NULL | | | PortOfTransShipmentETA | date | YES | | NULL | | | PortOfTransShipmentATA | date | YES | | NULL | | | PortOfDischargeId | int(10) | YES | MUL | NULL | | | PortOfDischargeETA | date | YES | | NULL | | | PortOfDischargeATA | date | YES | | NULL | | | DestinationalTerminalId | int(10) | YES | MUL | NULL | | | DestinationalTerminalETA | date | YES | | NULL | | | DestinationalTerminalATA | date | YES | | NULL | | | DestinationReceivingAgentId | int(10) | YES | MUL | NULL | | | HouseBillComments | varchar(1500) | YES | | NULL | | | EnabledArrivalToWH | tinyint(1) | YES | | 1 | | | ArrivalToWarehouseDate | date | YES | | NULL | | | ItNumber | varchar(17) | YES | | NULL | | | ItDate | date | YES | | NULL | | | ItLocation | varchar(20) | YES | | NULL | | | CustomsBrokerID | int(10) | YES | MUL | NULL | | | CustomsBrokerDescription | varchar(1500) | YES | | NULL | | | DeliveryAddressId | int(10) | YES | MUL | NULL | | | DeliveryAddressDescription | varchar(1500) | YES | | NULL | | | DeliveryComments | varchar(1500) | YES | | NULL | | | LastFreeDay | date | YES | | NULL | | | CargoLocationId | int(10) | YES | MUL | NULL | | | CargoLocationDescription | varchar(1500) | YES | | NULL | | | DeliveryTruckerId | int(10) | YES | MUL | NULL | | | ImportEstimatedDeliveryDate | date | YES | | NULL | | | ActualDeliveryDate | date | YES | | NULL | | | ArrivalNoticeComments | varchar(1500) | YES | | NULL | | | OriginalBillLandingRequired | int(1) | YES | | 0 | | | PaymentFreightChargesRequired | int(1) | YES | | 0 | | | CustomsStatusId | int(10) | YES | MUL | NULL | | | CustomsStatusDate | date | YES | | NULL | | | FDAStatusId | int(10) | YES | MUL | NULL | | | FDAStatusDate | date | YES | | NULL | | | HouseBill | varchar(30) | YES | | NULL | | | DeliveryDateTypeId | int(10) | YES | | NULL | | | JaguarDelivery | tinyint(1) | YES | | 0 | | | ExportCustoms | varchar(30) | YES | | NULL | | | ActualDeliveryDateEnabled | tinyint(1) | YES | | 0 | | +-------------------------------+---------------+------+-----+---------+----------------+ 61 rows in set CREATE TABLE `tbloceanshipment` ( `OceanShipmentId` int(10) NOT NULL AUTO_INCREMENT, `GenericShipmentId` int(10) NOT NULL, `Hazardous` tinyint(1) NOT NULL DEFAULT '0', `HazardousNote` varchar(1500) DEFAULT NULL, `Freight` int(1) DEFAULT '0', `MoveTypeId` int(10) DEFAULT NULL, `OriginalHouseBill` int(1) DEFAULT '0', `SteamshiplineId` int(10) DEFAULT NULL, `CoLoaderOceanId` int(10) DEFAULT NULL, `Booking` varchar(30) DEFAULT NULL, `MasterBill` varchar(30) DEFAULT NULL, `AMSSubmissionDate` date DEFAULT NULL, `VesselName` varchar(30) DEFAULT NULL, `Voyage1` varchar(30) DEFAULT NULL, `FeederVesselname` varchar(30) DEFAULT NULL, `Voyage2` varchar(30) DEFAULT NULL, `OriginalTerminalId` int(10) DEFAULT NULL, `OriginalTerminalETD` date DEFAULT NULL, `OriginalTerminalATD` date DEFAULT NULL, `PortOfLoadingId` int(10) DEFAULT NULL, `PortOfLoadingETD` date DEFAULT NULL, `PortOfLoadingATD` date DEFAULT NULL, `PortOfTransShipmentId` int(10) DEFAULT NULL, `PortOfTransShipmentETA` date DEFAULT NULL, `PortOfTransShipmentATA` date DEFAULT NULL, `PortOfDischargeId` int(10) DEFAULT NULL, `PortOfDischargeETA` date DEFAULT NULL, `PortOfDischargeATA` date DEFAULT NULL, `DestinationalTerminalId` int(10) DEFAULT NULL, `DestinationalTerminalETA` date DEFAULT NULL, `DestinationalTerminalATA` date DEFAULT NULL, `DestinationReceivingAgentId` int(10) DEFAULT NULL, `HouseBillComments` varchar(1500) DEFAULT NULL, `EnabledArrivalToWH` tinyint(1) DEFAULT '1', `ArrivalToWarehouseDate` date DEFAULT NULL, `ItNumber` varchar(17) DEFAULT NULL, `ItDate` date DEFAULT NULL, `ItLocation` varchar(20) DEFAULT NULL, `CustomsBrokerID` int(10) DEFAULT NULL, `CustomsBrokerDescription` varchar(1500) DEFAULT NULL, `DeliveryAddressId` int(10) DEFAULT NULL, `DeliveryAddressDescription` varchar(1500) DEFAULT NULL, `DeliveryComments` varchar(1500) DEFAULT NULL, `LastFreeDay` date DEFAULT NULL, `CargoLocationId` int(10) DEFAULT NULL, `CargoLocationDescription` varchar(1500) DEFAULT NULL, `DeliveryTruckerId` int(10) DEFAULT NULL, `ImportEstimatedDeliveryDate` date DEFAULT NULL, `ActualDeliveryDate` date DEFAULT NULL, `ArrivalNoticeComments` varchar(1500) DEFAULT NULL, `OriginalBillLandingRequired` int(1) DEFAULT '0', `PaymentFreightChargesRequired` int(1) DEFAULT '0', `CustomsStatusId` int(10) DEFAULT NULL, `CustomsStatusDate` date DEFAULT NULL, `FDAStatusId` int(10) DEFAULT NULL, `FDAStatusDate` date DEFAULT NULL, `HouseBill` varchar(30) DEFAULT NULL, `DeliveryDateTypeId` int(10) DEFAULT NULL, `JaguarDelivery` tinyint(1) DEFAULT '0', `ExportCustoms` varchar(30) DEFAULT NULL, `ActualDeliveryDateEnabled` tinyint(1) DEFAULT '0', PRIMARY KEY (`OceanShipmentId`), KEY `OceanShipment_GenericShipmentId` (`GenericShipmentId`), KEY `OceanShipment_MoveTypeId` (`MoveTypeId`), KEY `OceanShipment_SteamshiplineId` (`SteamshiplineId`), KEY `OceanShipment_CoLoaderOceanId` (`CoLoaderOceanId`), KEY `OceanShipment_OriginalTerminalId` (`OriginalTerminalId`), KEY `OceanShipment_PortOfLoadingId` (`PortOfLoadingId`), KEY `OceanShipment_PortOfTransShipmentId` (`PortOfTransShipmentId`), KEY `OceanShipment_PortOfDischargeId` (`PortOfDischargeId`), KEY `OceanShipment_DestinationalTerminalId` (`DestinationalTerminalId`), KEY `OceanShipment_DestinationReceivingAgentId` (`DestinationReceivingAgentId`), KEY `OceanShipment_CustomsBrokerID` (`CustomsBrokerID`), KEY `OceanShipment_DeliveryAddressId` (`DeliveryAddressId`), KEY `OceanShipment_CargoLocationId` (`CargoLocationId`), KEY `OceanShipment_FDAStatusId` (`FDAStatusId`), KEY `OceanShipment_CustomsStatusId` (`CustomsStatusId`), KEY `tblOceanShipment_ibfk_27` (`DeliveryTruckerId`), CONSTRAINT `tblOceanShipment_ibfk_11` FOREIGN KEY (`MoveTypeId`) REFERENCES `tblmovetype` (`Id`), CONSTRAINT `tblOceanShipment_ibfk_12` FOREIGN KEY (`SteamshiplineId`) REFERENCES `tblsteamshipline` (`Id`), CONSTRAINT `tblOceanShipment_ibfk_13` FOREIGN KEY (`CoLoaderOceanId`) REFERENCES `tbladdressjaguarvendor` (`Id`), CONSTRAINT `tblOceanShipment_ibfk_14` FOREIGN KEY (`OriginalTerminalId`) REFERENCES `tblseaport` (`Id`), CONSTRAINT `tblOceanShipment_ibfk_15` FOREIGN KEY (`PortOfLoadingId`) REFERENCES `tblseaport` (`Id`), CONSTRAINT `tblOceanShipment_ibfk_16` FOREIGN KEY (`PortOfTransShipmentId`) REFERENCES `tblseaport` (`Id`), CONSTRAINT `tblOceanShipment_ibfk_17` FOREIGN KEY (`PortOfDischargeId`) REFERENCES `tblseaport` (`Id`), CONSTRAINT `tblOceanShipment_ibfk_18` FOREIGN KEY (`DestinationalTerminalId`) REFERENCES `tblseaport` (`Id`), CONSTRAINT `tblOceanShipment_ibfk_19` FOREIGN KEY (`DestinationReceivingAgentId`) REFERENCES `tbladdresstransportation` (`Id`), CONSTRAINT `tblOceanShipment_ibfk_20` FOREIGN KEY (`CustomsBrokerID`) REFERENCES `tbladdressjaguarvendor` (`Id`), CONSTRAINT `tblOceanShipment_ibfk_21` FOREIGN KEY (`DeliveryAddressId`) REFERENCES `tbladdresstransportation` (`Id`), CONSTRAINT `tblOceanShipment_ibfk_22` FOREIGN KEY (`CargoLocationId`) REFERENCES `tbladdressjaguarvendor` (`Id`), CONSTRAINT `tblOceanShipment_ibfk_23` FOREIGN KEY (`FDAStatusId`) REFERENCES `tblfdastatus` (`Id`), CONSTRAINT `tblOceanShipment_ibfk_24` FOREIGN KEY (`CustomsStatusId`) REFERENCES `tblcustomsstatus` (`Id`), CONSTRAINT `tblOceanShipment_ibfk_26` FOREIGN KEY (`GenericShipmentId`) REFERENCES `tblgenericshipment` (`Id`) ON DELETE CASCADE, CONSTRAINT `tblOceanShipment_ibfk_27` FOREIGN KEY (`DeliveryTruckerId`) REFERENCES `tbladdressjaguarvendor` (`Id`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=433 DEFAULT CHARSET=latin1;
[edit] Fields
[edit] <example>
- properties:
[edit] OceanShipmentId
` int(10) NOT NULL AUTO_INCREMENT,
[edit] GenericShipmentId
` int(10) NOT NULL,
[edit] Hazardous
` tinyint(1) NOT NULL DEFAULT '0',
[edit] HazardousNote
` varchar(1500) DEFAULT NULL,
[edit] Freight
` int(1) DEFAULT '0',
[edit] MoveTypeId
` int(10) DEFAULT NULL,
[edit] OriginalHouseBill
` int(1) DEFAULT '0',
=== SteamshiplineId` int(10) DEFAULT NULL,
[edit] CoLoaderOceanId
` int(10) DEFAULT NULL,
[edit] Booking
` varchar(30) DEFAULT NULL,
[edit] MasterBill
` varchar(30) DEFAULT NULL,
[edit] AMSSubmissionDate
` date DEFAULT NULL,
[edit] VesselName
` varchar(30) DEFAULT NULL,
[edit] Voyage1
varchar(30) DEFAULT NULL,
[edit] FeederVesselname
` varchar(30) DEFAULT NULL,
[edit] Voyage2
` varchar(30) DEFAULT NULL,
`OriginalTerminalId` int(10) DEFAULT NULL, `OriginalTerminalETD` date DEFAULT NULL, `OriginalTerminalATD` date DEFAULT NULL, `PortOfLoadingId` int(10) DEFAULT NULL, `PortOfLoadingETD` date DEFAULT NULL, `PortOfLoadingATD` date DEFAULT NULL, `PortOfTransShipmentId` int(10) DEFAULT NULL, `PortOfTransShipmentETA` date DEFAULT NULL, `PortOfTransShipmentATA` date DEFAULT NULL, `PortOfDischargeId` int(10) DEFAULT NULL, `PortOfDischargeETA` date DEFAULT NULL, `PortOfDischargeATA` date DEFAULT NULL, `DestinationalTerminalId` int(10) DEFAULT NULL, `DestinationalTerminalETA` date DEFAULT NULL, `DestinationalTerminalATA` date DEFAULT NULL, `DestinationReceivingAgentId` int(10) DEFAULT NULL, `HouseBillComments` varchar(1500) DEFAULT NULL, `EnabledArrivalToWH` tinyint(1) DEFAULT '1', `ArrivalToWarehouseDate` date DEFAULT NULL, `ItNumber` varchar(17) DEFAULT NULL, `ItDate` date DEFAULT NULL, `ItLocation` varchar(20) DEFAULT NULL, `CustomsBrokerID` int(10) DEFAULT NULL, `CustomsBrokerDescription` varchar(1500) DEFAULT NULL, `DeliveryAddressId` int(10) DEFAULT NULL, `DeliveryAddressDescription` varchar(1500) DEFAULT NULL, `DeliveryComments` varchar(1500) DEFAULT NULL, `LastFreeDay` date DEFAULT NULL, `CargoLocationId` int(10) DEFAULT NULL, `CargoLocationDescription` varchar(1500) DEFAULT NULL, `DeliveryTruckerId` int(10) DEFAULT NULL, `ImportEstimatedDeliveryDate` date DEFAULT NULL, `ActualDeliveryDate` date DEFAULT NULL, `ArrivalNoticeComments` varchar(1500) DEFAULT NULL, `OriginalBillLandingRequired` int(1) DEFAULT '0', `PaymentFreightChargesRequired` int(1) DEFAULT '0', `CustomsStatusId` int(10) DEFAULT NULL, `CustomsStatusDate` date DEFAULT NULL, `FDAStatusId` int(10) DEFAULT NULL, `FDAStatusDate` date DEFAULT NULL, `HouseBill` varchar(30) DEFAULT NULL, `DeliveryDateTypeId` int(10) DEFAULT NULL, `JaguarDelivery` tinyint(1) DEFAULT '0', `ExportCustoms` varchar(30) DEFAULT NULL, `ActualDeliveryDateEnabled` tinyint(1) DEFAULT '0',
[edit] DeliveryInstructions
varchar(1500) DEFAULT NULL