Trucking tbl

From UG

Current revision as of 19:49, 22 February 2010

[edit] Related bo wiki

CT bo

[edit] MySQL Table Definitions

on 02-Feb-2010

mysql> describe tblTrucking
Shipment;
+-----------------------+-------------+------+-----+---------+----------------+
| Field                 | Type        | Null | Key | Default | Extra          |
+-----------------------+-------------+------+-----+---------+----------------+
| TruckingShipmentId    | int(10)     | NO   | PRI | NULL    | auto_increment |
| GenericShipmentId     | int(10)     | NO   | MUL | NULL    |                |
| EstimatedDeliveryDate | date        | YES  |     | NULL    |                |
| ActualDeliveryDate    | date        | YES  |     | NULL    |                |
| LastFreeDay           | date        | YES  |     | NULL    |                |
| HouseAirwayBill       | varchar(30) | YES  |     | NULL    |                |
| AirlineId             | int(10)     | YES  | MUL | NULL    |                |
| MasterBillOfLoading   | varchar(30) | YES  |     | NULL    |                |
| HouseBillOfLoading    | varchar(30) | YES  |     | NULL    |                |
| SteamshiplineId       | int(10)     | YES  | MUL | NULL    |                |
| MasterBillA           | varchar(3)  | NO   |     |         |                |
| MasterBillB           | varchar(4)  | NO   |     |         |                |
| MasterBillC           | varchar(4)  | NO   |     |         |                |
+-----------------------+-------------+------+-----+---------+----------------+
13 rows in set

CREATE TABLE `tbltruckingshipment` (
  `TruckingShipmentId` int(10) NOT NULL AUTO_INCREMENT,
  `GenericShipmentId` int(10) NOT NULL,
  `EstimatedDeliveryDate` date DEFAULT NULL,
  `ActualDeliveryDate` date DEFAULT NULL,
  `LastFreeDay` date DEFAULT NULL,
  `HouseAirwayBill` varchar(30) DEFAULT NULL,
  `AirlineId` int(10) DEFAULT NULL,
  `MasterBillOfLoading` varchar(30) DEFAULT NULL,
  `HouseBillOfLoading` varchar(30) DEFAULT NULL,
  `SteamshiplineId` int(10) DEFAULT NULL,
  `MasterBillA` varchar(3) NOT NULL DEFAULT '',
  `MasterBillB` varchar(4) NOT NULL DEFAULT '',
  `MasterBillC` varchar(4) NOT NULL DEFAULT '',
  PRIMARY KEY (`TruckingShipmentId`),
  KEY `TruckingShipment_GenericShipmentId` (`GenericShipmentId`),
  KEY `TruckingShipment_AirlineId` (`AirlineId`),
  KEY `TruckingShipment_SteamshiplineId` (`SteamshiplineId`),
  CONSTRAINT `tblTruckingShipment_ibfk_1` FOREIGN KEY (`GenericShipmentId`) REFERENCES `tblgenericshipment` (`Id`) ON DELETE CASCADE,
  CONSTRAINT `tblTruckingShipment_ibfk_2` FOREIGN KEY (`AirlineId`) REFERENCES `tblairline` (`Id`),
  CONSTRAINT `tblTruckingShipment_ibfk_3` FOREIGN KEY (`SteamshiplineId`) REFERENCES `tblsteamshipline` (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=latin1;

[edit] Fields

[edit] TruckingShipmentId

` int(10) NOT NULL AUTO_INCREMENT,

[edit] GenericShipmentId

` int(10) NOT NULL,

 `EstimatedDeliveryDate` date DEFAULT NULL,
 `ActualDeliveryDate` date DEFAULT NULL,
 `LastFreeDay` date DEFAULT NULL,
 `HouseAirwayBill` varchar(30) DEFAULT NULL,
 `AirlineId` int(10) DEFAULT NULL,
 `MasterBillOfLoading` varchar(30) DEFAULT NULL,
 `HouseBillOfLoading` varchar(30) DEFAULT NULL,
 `SteamshiplineId` int(10) DEFAULT NULL,
 `MasterBillA` varchar(3) NOT NULL DEFAULT ,
 `MasterBillB` varchar(4) NOT NULL DEFAULT ,
 `MasterBillC` varchar(4) NOT NULL DEFAULT ,