Air tbl

From UG

Revision as of 15:38, 2 February 2010 by Andrei (Talk | contribs)
Jump to: navigation, search


Contents

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;

Related Business Object and Its Fields

This table corresponds to Air Shipment business object.

See its fields (attributes) below.

AirShipmentId

  • meaning: PRI key

GenericShipmentId

Hazardous

HazardousNote

Freight

AirlineId

CoLoaderAirId

Hawb

MasterBillA

MasterBillB

MasterBillC

HouseBillOfLanding

FlightOne

FlightTwo

AirportOfDepartureId

AirportOfDepartureETD

AirportOfDepartureATD

TransShipmentAirportId

TransShipmentAirportETA

TransShipmentAirportATA

AirportOfDestinationId

AirportOfDestinationETA

AirportOfDestinationATA

DestinationReceivingAgentId

HouseAirwayBillComments

EnabledArrivalToWH

ArrivalToWarehouseDate

ItNumber

ItDate

ItLocation

CustomsBrokerId

CustomsBrokerDescription

CargoLocationId

CargoLocationDescription

LastFreeDay

ArrivalNoticeComments

DeliveryAddressId

DeliveryAddressDescription

DeliveryTruckerId

ImportEstimatedDeliveryDate

ImportActualDeliveryDate

DeliveryComments

TruckerDeliveryInstructions

PaymentFreightChargesRequired

CustomsStatusId

CustomsStatusDate

FDAStatusId

FDAStatusDate

DeliveryDateTypeId

ExportCustoms

ExportCustomsId

ActualDeliveryDateEnabled

Personal tools