Air tbl
From UG
(Difference between revisions)
(→= Fields) |
|||
(5 intermediate revisions not shown) | |||
Line 204: | Line 204: | ||
`ImportEstimatedDeliveryDate` date DEFAULT NULL, | `ImportEstimatedDeliveryDate` date DEFAULT NULL, | ||
`ImportActualDeliveryDate` date DEFAULT NULL, | `ImportActualDeliveryDate` date DEFAULT NULL, | ||
- | + | ||
+ | === DeliveryComments === | ||
+ | ` varchar(100) DEFAULT NULL, | ||
+ | |||
+ | |||
`TruckerDeliveryInstructions` varchar(1500) DEFAULT NULL, | `TruckerDeliveryInstructions` varchar(1500) DEFAULT NULL, | ||
`PaymentFreightChargesRequired` int(1) DEFAULT '0', | `PaymentFreightChargesRequired` int(1) DEFAULT '0', | ||
Line 215: | Line 219: | ||
`ExportCustomsId` int(10) DEFAULT NULL, | `ExportCustomsId` int(10) 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 tblAirShipment; +-------------------------------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------------------+---------------+------+-----+---------+----------------+ | AirShipmentId | 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 | | | AirlineId | int(10) | YES | MUL | NULL | | | CoLoaderAirId | int(10) | YES | MUL | NULL | | | Hawb | varchar(30) | YES | | NULL | | | MasterBillA | varchar(3) | NO | | | | | MasterBillB | varchar(4) | NO | | | | | MasterBillC | varchar(4) | NO | | | | | HouseBillOfLanding | varchar(30) | YES | | NULL | | | FlightOne | varchar(30) | YES | | NULL | | | FlightTwo | varchar(30) | YES | | NULL | | | AirportOfDepartureId | int(10) | YES | MUL | NULL | | | AirportOfDepartureETD | date | YES | | NULL | | | AirportOfDepartureATD | date | YES | | NULL | | | TransShipmentAirportId | int(10) | YES | MUL | NULL | | | TransShipmentAirportETA | date | YES | | NULL | | | TransShipmentAirportATA | date | YES | | NULL | | | AirportOfDestinationId | int(10) | YES | MUL | NULL | | | AirportOfDestinationETA | date | YES | | NULL | | | AirportOfDestinationATA | date | YES | | NULL | | | DestinationReceivingAgentId | int(10) | YES | MUL | NULL | | | HouseAirwayBillComments | 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 | | | CargoLocationId | int(10) | YES | MUL | NULL | | | CargoLocationDescription | varchar(1500) | YES | | NULL | | | LastFreeDay | date | YES | | NULL | | | ArrivalNoticeComments | varchar(1500) | YES | | NULL | | | DeliveryAddressId | int(10) | YES | MUL | NULL | | | DeliveryAddressDescription | varchar(1500) | YES | | NULL | | | DeliveryTruckerId | int(10) | YES | MUL | NULL | | | ImportEstimatedDeliveryDate | date | YES | | NULL | | | ImportActualDeliveryDate | date | YES | | NULL | | | DeliveryComments | varchar(100) | YES | | NULL | | | TruckerDeliveryInstructions | varchar(1500) | YES | | NULL | | | 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 | | | DeliveryDateTypeId | int(10) | YES | | NULL | | | ExportCustoms | varchar(30) | YES | | NULL | | | ExportCustomsId | int(10) | YES | MUL | NULL | | | ActualDeliveryDateEnabled | tinyint(1) | YES | | 0 | | +-------------------------------+---------------+------+-----+---------+----------------+ 52 rows in set CREATE TABLE `tblairshipment` ( `AirShipmentId` 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', `AirlineId` int(10) DEFAULT NULL, `CoLoaderAirId` int(10) DEFAULT NULL, `Hawb` varchar(30) DEFAULT NULL, `MasterBillA` varchar(3) NOT NULL DEFAULT '', `MasterBillB` varchar(4) NOT NULL DEFAULT '', `MasterBillC` varchar(4) NOT NULL DEFAULT '', `HouseBillOfLanding` varchar(30) DEFAULT NULL, `FlightOne` varchar(30) DEFAULT NULL, `FlightTwo` varchar(30) DEFAULT NULL, `AirportOfDepartureId` int(10) DEFAULT NULL, `AirportOfDepartureETD` date DEFAULT NULL, `AirportOfDepartureATD` date DEFAULT NULL, `TransShipmentAirportId` int(10) DEFAULT NULL, `TransShipmentAirportETA` date DEFAULT NULL, `TransShipmentAirportATA` date DEFAULT NULL, `AirportOfDestinationId` int(10) DEFAULT NULL, `AirportOfDestinationETA` date DEFAULT NULL, `AirportOfDestinationATA` date DEFAULT NULL, `DestinationReceivingAgentId` int(10) DEFAULT NULL, `HouseAirwayBillComments` 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, `CargoLocationId` int(10) DEFAULT NULL, `CargoLocationDescription` varchar(1500) DEFAULT NULL, `LastFreeDay` date DEFAULT NULL, `ArrivalNoticeComments` varchar(1500) DEFAULT NULL, `DeliveryAddressId` int(10) DEFAULT NULL, `DeliveryAddressDescription` varchar(1500) DEFAULT NULL, `DeliveryTruckerId` int(10) DEFAULT NULL, `ImportEstimatedDeliveryDate` date DEFAULT NULL, `ImportActualDeliveryDate` date DEFAULT NULL, `DeliveryComments` varchar(100) DEFAULT NULL, `TruckerDeliveryInstructions` varchar(1500) DEFAULT NULL, `PaymentFreightChargesRequired` int(1) DEFAULT '0', `CustomsStatusId` int(10) DEFAULT NULL, `CustomsStatusDate` date DEFAULT NULL, `FDAStatusId` int(10) DEFAULT NULL, `FDAStatusDate` date DEFAULT NULL, `DeliveryDateTypeId` int(10) DEFAULT NULL, `ExportCustoms` varchar(30) DEFAULT NULL, `ExportCustomsId` int(10) DEFAULT NULL, `ActualDeliveryDateEnabled` tinyint(1) DEFAULT '0', PRIMARY KEY (`AirShipmentId`), KEY `OceanShipment_GenericShipmentId` (`GenericShipmentId`), KEY `AirShipment_AirlineId` (`AirlineId`), KEY `AirShipment_CoLoaderAirId` (`CoLoaderAirId`), KEY `AirShipment_AirportOfDepartureId` (`AirportOfDepartureId`), KEY `AirShipment_TransShipmentAirportId` (`TransShipmentAirportId`), KEY `AirShipment_AirportOfDestinationId` (`AirportOfDestinationId`), KEY `AirShipment_DestinationReceivingAgentId` (`DestinationReceivingAgentId`), KEY `AirShipment_CustomsBrokerId` (`CustomsBrokerId`), KEY `AirShipment_CargoLocationId` (`CargoLocationId`), KEY `AirShipment_DeliveryAddressId` (`DeliveryAddressId`), KEY `AirShipment_DeliveryTruckerId` (`DeliveryTruckerId`), KEY `AirShipment_CustomsStatusId` (`CustomsStatusId`), KEY `AirShipment_FDAStatusId` (`FDAStatusId`), KEY `tblAirShipment_ibfk_14` (`ExportCustomsId`), CONSTRAINT `tblAirShipment_ibfk_1` FOREIGN KEY (`GenericShipmentId`) REFERENCES `tblgenericshipment` (`Id`) ON DELETE CASCADE, CONSTRAINT `tblAirShipment_ibfk_10` FOREIGN KEY (`DeliveryAddressId`) REFERENCES `tbladdresstransportation` (`Id`), CONSTRAINT `tblAirShipment_ibfk_11` FOREIGN KEY (`DeliveryTruckerId`) REFERENCES `tbladdressjaguarvendor` (`Id`), CONSTRAINT `tblAirShipment_ibfk_12` FOREIGN KEY (`CustomsStatusId`) REFERENCES `tblcustomsstatus` (`Id`), CONSTRAINT `tblAirShipment_ibfk_13` FOREIGN KEY (`FDAStatusId`) REFERENCES `tblfdastatus` (`Id`), CONSTRAINT `tblAirShipment_ibfk_14` FOREIGN KEY (`ExportCustomsId`) REFERENCES `tblexportcustoms` (`Id`), CONSTRAINT `tblAirShipment_ibfk_2` FOREIGN KEY (`AirlineId`) REFERENCES `tblairline` (`Id`), CONSTRAINT `tblAirShipment_ibfk_3` FOREIGN KEY (`CoLoaderAirId`) REFERENCES `tbladdressjaguarvendor` (`Id`), CONSTRAINT `tblAirShipment_ibfk_4` FOREIGN KEY (`AirportOfDepartureId`) REFERENCES `tblairport` (`Id`), CONSTRAINT `tblAirShipment_ibfk_5` FOREIGN KEY (`TransShipmentAirportId`) REFERENCES `tblairport` (`Id`), CONSTRAINT `tblAirShipment_ibfk_6` FOREIGN KEY (`AirportOfDestinationId`) REFERENCES `tblairport` (`Id`), CONSTRAINT `tblAirShipment_ibfk_7` FOREIGN KEY (`DestinationReceivingAgentId`) REFERENCES `tbladdresstransportation` (`Id`), CONSTRAINT `tblAirShipment_ibfk_8` FOREIGN KEY (`CustomsBrokerId`) REFERENCES `tbladdressjaguarvendor` (`Id`), CONSTRAINT `tblAirShipment_ibfk_9` FOREIGN KEY (`CargoLocationId`) REFERENCES `tbladdresstransportation` (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=312 DEFAULT CHARSET=latin1;
[edit] Fields
[edit] AirShipmentId
` int(10) NOT NULL AUTO_INCREMENT,
[edit] GenericShipmentId
` int(10) NOT NULL,
[edit] Hazardous
` tinyint(1) NOT NULL DEFAULT '0',
`HazardousNote` varchar(1500) DEFAULT NULL, `Freight` int(1) DEFAULT '0', `AirlineId` int(10) DEFAULT NULL, `CoLoaderAirId` int(10) DEFAULT NULL, `Hawb` varchar(30) DEFAULT NULL, `MasterBillA` varchar(3) NOT NULL DEFAULT , `MasterBillB` varchar(4) NOT NULL DEFAULT , `MasterBillC` varchar(4) NOT NULL DEFAULT , `HouseBillOfLanding` varchar(30) DEFAULT NULL, `FlightOne` varchar(30) DEFAULT NULL, `FlightTwo` varchar(30) DEFAULT NULL, `AirportOfDepartureId` int(10) DEFAULT NULL, `AirportOfDepartureETD` date DEFAULT NULL, `AirportOfDepartureATD` date DEFAULT NULL, `TransShipmentAirportId` int(10) DEFAULT NULL, `TransShipmentAirportETA` date DEFAULT NULL, `TransShipmentAirportATA` date DEFAULT NULL, `AirportOfDestinationId` int(10) DEFAULT NULL, `AirportOfDestinationETA` date DEFAULT NULL, `AirportOfDestinationATA` date DEFAULT NULL, `DestinationReceivingAgentId` int(10) DEFAULT NULL, `HouseAirwayBillComments` 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, `CargoLocationId` int(10) DEFAULT NULL, `CargoLocationDescription` varchar(1500) DEFAULT NULL, `LastFreeDay` date DEFAULT NULL, `ArrivalNoticeComments` varchar(1500) DEFAULT NULL, `DeliveryAddressId` int(10) DEFAULT NULL, `DeliveryAddressDescription` varchar(1500) DEFAULT NULL, `DeliveryTruckerId` int(10) DEFAULT NULL, `ImportEstimatedDeliveryDate` date DEFAULT NULL, `ImportActualDeliveryDate` date DEFAULT NULL,
[edit] DeliveryComments
` varchar(100) DEFAULT NULL,
`TruckerDeliveryInstructions` varchar(1500) DEFAULT NULL, `PaymentFreightChargesRequired` int(1) DEFAULT '0', `CustomsStatusId` int(10) DEFAULT NULL, `CustomsStatusDate` date DEFAULT NULL, `FDAStatusId` int(10) DEFAULT NULL, `FDAStatusDate` date DEFAULT NULL, `DeliveryDateTypeId` int(10) DEFAULT NULL, `ExportCustoms` varchar(30) DEFAULT NULL, `ExportCustomsId` int(10) DEFAULT NULL, `ActualDeliveryDateEnabled` tinyint(1) DEFAULT '0',
[edit] DeliveryInstructions
varchar(1500) DEFAULT NULL