Trucking tbl
From UG
(Difference between revisions)
m (moved Trucking Shipment (tbl) to Trucking tbl) |
|||
(One intermediate revision not shown) |
Current revision as of 19:49, 22 February 2010
Contents |
[edit] Related bo wiki
[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 ,