Ocean tbl

From UG

(Difference between revisions)
Jump to: navigation, search
(→Related Business Object and Its Fields)
Line 174: Line 174:
</pre>
</pre>
-
== Related Business Object and Its Fields ==
+
== Fields ==
-
This table corresponds to '''Air Shipment''' business object.
+
=== <example> ===
-
 
+
* ''properties:''
-
See its fields (attributes) below.
+
-
 
+
-
=== OceanShipmentId ===
+
-
* ''meaning:'' PRI key
+
-
 
+
-
=== GenericShipmentId ===
+
-
* ''meaning:'' FRN key, see [[tbl Generic Shipment#Id]]; also visible number of shipment
+
-
* ''type/format:''  [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
+
-
* ''examples:'' 669, 200539
+
-
 
+
-
=== Hazardous ===
+
-
* ''meaning:'' hazardous indication in [[Commodity Table]]
+
-
* ''type/format:''  [[Datatypes#positive integer]]; exactly 1 digit
+
-
* ''examples:'' 0, 1
+
-
 
+
-
=== HazardousNote ===
+
-
* ''meaning:'' hazardous note
+
-
* ''type/format:'' [[Datatypes#alphanumeric]]; max = 1500 chars
+
-
* ''examples:''
+
-
 
+
-
=== Freight ===
+
-
* ''meaning:''
+
-
* ''type/format:''  [[Datatypes#positive integer]]; exactly 1 digit
+
-
* ''examples:'' 0, 1
+
-
 
+
-
=== MoveTypeId ===
+
-
* ''meaning:'' FRN key, see [[tbl Move Type#Id]]
+
-
* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
+
-
* ''examples:''
+
-
 
+
-
=== OriginalHouseBill ===
+
-
* ''meaning:''
+
-
* ''type/format:''  [[Datatypes#positive integer]]; exactly 1 digit
+
-
* ''examples:'' 0, 1
+
-
 
+
-
=== SteamshiplineId ===
+
-
* ''meaning:'' FRN key, see [[tbl Steamshipline#Id]]
+
-
* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
+
-
* ''examples:''
+
-
 
+
-
=== CoLoaderOceanId ===
+
-
* ''meaning:'' FRN key, see [[tbl Address Jaguar Vendor#Id]]
+
-
* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
+
-
* ''examples:''
+
-
 
+
-
=== Booking ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#]];
+
-
* ''examples:''
+
-
 
+
-
=== MasterBill ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#]];
+
-
* ''examples:''
+
-
 
+
-
=== AMSSubmissionDate ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#CT2 date]];
+
-
* ''examples:'' 02-Feb-2010
+
-
 
+
-
=== VesselName ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#]];
+
-
* ''examples:''
+
-
 
+
-
=== Voyage1 ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#]];
+
-
* ''examples:''
+
-
 
+
-
=== FeederVesselname ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#]];
+
-
* ''examples:''
+
-
 
+
-
=== Voyage2 ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#]];
+
-
* ''examples:''
+
-
 
+
-
=== OriginalTerminalId ===
+
-
* ''meaning:'' FRN key, see [[tbl Seaport#Id]]
+
-
* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
+
-
* ''examples:''
+
-
 
+
-
=== OriginalTerminalETD ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#CT2 date]];
+
-
* ''examples:'' 02-Feb-2010
+
-
 
+
-
=== OriginalTerminalATD ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#CT2 date]];
+
-
* ''examples:'' 02-Feb-2010
+
-
 
+
-
=== PortOfLoadingId ===
+
-
* ''meaning:'' FRN key, see [[tbl Seaport#Id]]
+
-
* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
+
-
* ''examples:''
+
-
 
+
-
=== PortOfLoadingETD ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#CT2 date]];
+
-
* ''examples:'' 02-Feb-2010
+
-
 
+
-
=== PortOfLoadingATD ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#CT2 date]];
+
-
* ''examples:'' 02-Feb-2010
+
-
 
+
-
=== PortOfTransShipmentId ===
+
-
* ''meaning:'' FRN key, see [[tbl Seaport#Id]]
+
-
* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
+
-
* ''examples:''
+
-
 
+
-
=== PortOfTransShipmentETA ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#CT2 date]];
+
-
* ''examples:'' 02-Feb-2010
+
-
 
+
-
=== PortOfTransShipmentATA ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#CT2 date]];
+
-
* ''examples:'' 02-Feb-2010
+
-
 
+
-
=== PortOfDischargeId ===
+
-
* ''meaning:'' FRN key, see [[tbl Seaport#Id]]
+
-
* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
+
-
* ''examples:''
+
-
 
+
-
=== PortOfDischargeETA ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#CT2 date]];
+
-
* ''examples:'' 02-Feb-2010
+
-
 
+
-
=== PortOfDischargeATA ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#CT2 date]];
+
-
* ''examples:'' 02-Feb-2010
+
-
 
+
-
=== DestinationalTerminalId ===
+
-
* ''meaning:'' FRN key, see [[tbl Seaport#Id]]
+
-
* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
+
-
* ''examples:''
+
-
 
+
-
=== DestinationalTerminalETA ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#CT2 date]];
+
-
* ''examples:'' 02-Feb-2010
+
-
 
+
-
=== DestinationalTerminalATA ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#CT2 date]];
+
-
* ''examples:'' 02-Feb-2010
+
-
 
+
-
=== DestinationReceivingAgentId ===
+
-
* ''meaning:'' FRN key, see [[tbl Address Transportation#Id]]
+
-
* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
+
-
* ''examples:''
+
-
 
+
-
=== HouseBillComments ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#alphanumeric]]; max = 1500 chars
+
-
* ''examples:''
+
-
 
+
-
=== EnabledArrivalToWH ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#]];
+
-
* ''examples:''
+
-
 
+
-
=== ArrivalToWarehouseDate ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#]];
+
-
* ''examples:''
+
-
 
+
-
=== ItNumber ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#]];
+
-
* ''examples:''
+
-
 
+
-
=== ItDate ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#]];
+
-
* ''examples:''
+
-
 
+
-
=== ItLocation ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#]];
+
-
* ''examples:''
+
-
 
+
-
=== CustomsBrokerID ===
+
-
* ''meaning:'' FRN key, see [[tbl Address Jaguar Vendor#Id]]
+
-
* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
+
-
* ''examples:''
+
-
 
+
-
=== CustomsBrokerDescription ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#alphanumeric]]; max = 1500 chars
+
-
* ''examples:''
+
-
 
+
-
=== DeliveryAddressId ===
+
-
* ''meaning:'' FRN key, see [[tbl Address Transportation#Id]]
+
-
* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
+
-
* ''examples:''
+
-
 
+
-
=== DeliveryAddressDescription ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#alphanumeric]]; max = 1500 chars
+
-
* ''examples:''
+
-
 
+
-
=== DeliveryComments ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#alphanumeric]]; max = 1500 chars
+
-
* ''examples:''
+
-
 
+
-
=== LastFreeDay ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#CT2 date]];
+
-
* ''examples:'' 02-Feb-2010
+
-
 
+
-
=== CargoLocationId ===
+
-
* ''meaning:'' FRN key, see [[tbl Address Jaguar Vendor#Id]]
+
-
* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
+
-
* ''examples:''
+
-
 
+
-
=== CargoLocationDescription ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#alphanumeric]]; max = 1500 chars
+
-
* ''examples:''
+
-
 
+
-
=== DeliveryTruckerId ===
+
-
* ''meaning:'' FRN key, see [[tbl Address Jaguar Vendor#Id]]
+
-
* ''type/format:'' [[Datatypes#positive integer]]; min = 1 digit; max = 10 digits
+
-
* ''examples:''
+
-
 
+
-
=== ImportEstimatedDeliveryDate ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#CT2 date]];
+
-
* ''examples:'' 02-Feb-2010
+
-
 
+
-
=== ActualDeliveryDate ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#CT2 date]];
+
-
* ''examples:'' 02-Feb-2010
+
-
 
+
-
=== ArrivalNoticeComments ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#alphanumeric]]; max = 1500 chars
+
-
* ''examples:''
+
-
 
+
-
=== OriginalBillLandingRequired ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#]];
+
-
* ''examples:''
+
-
 
+
-
=== PaymentFreightChargesRequired ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#]];
+
-
* ''examples:''
+
-
 
+
-
=== CustomsStatusId ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#]];
+
-
* ''examples:''
+
-
 
+
-
=== CustomsStatusDate ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#CT2 date]];
+
-
* ''examples:'' 02-Feb-2010
+
-
 
+
-
=== FDAStatusId ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#]];
+
-
* ''examples:''
+
-
 
+
-
=== FDAStatusDate ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#]];
+
-
* ''examples:''
+
-
 
+
-
=== HouseBill ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#]];
+
-
* ''examples:''
+
-
 
+
-
=== DeliveryDateTypeId ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#]];
+
-
* ''examples:''
+
-
 
+
-
=== JaguarDelivery ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#]];
+
-
* ''examples:''
+
-
 
+
-
=== ExportCustoms ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#]];
+
-
* ''examples:''
+
-
 
+
-
=== ActualDeliveryDateEnabled ===
+
-
* ''meaning:''
+
-
* ''type/format:'' [[Datatypes#]];
+
-
* ''examples:''
+

Revision as of 19:39, 3 February 2010


Contents

Related bo wiki

CT bo

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;

Fields

<example>

  • properties:
Retrieved from "https://wiki.jaguarfreight.com/Ocean_tbl"
Personal tools