Trucking tbl
From UG
(Difference between revisions)
Line 1: | Line 1: | ||
[[Category:Shipment Data Objects]] | [[Category:Shipment Data Objects]] | ||
+ | |||
+ | == Related bo wiki == | ||
+ | [[CT bo]] | ||
+ | |||
== MySQL Table Definitions == | == MySQL Table Definitions == |
Revision as of 19:14, 3 February 2010
Contents |
Related bo wiki
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;
Related Business Object and Its Fields
This table corresponds to Trucking Shipment business object.
See its fields (attributes) below.
TruckingShipmentId
- 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
EstimatedDeliveryDate
- meaning:
- type/format: Datatypes#CT2 date;
- examples: 02-Feb-2010
ActualDeliveryDate
- meaning:
- type/format: Datatypes#CT2 date;
- examples: 02-Feb-2010
LastFreeDay
- meaning:
- type/format: Datatypes#CT2 date;
- examples: 02-Feb-2010
HouseAirwayBill
- meaning:
- type/format: Datatypes#;
- examples:
AirlineId
- meaning: FRN key, see tbl Airline#Id
- type/format: Datatypes#;
- examples:
MasterBillOfLoading
- meaning:
- type/format: Datatypes#;
- examples:
HouseBillOfLoading
- meaning:
- type/format: Datatypes#;
- examples:
SteamshiplineId
- meaning: FRN key, see tbl Steamshipline#Id
- type/format: Datatypes#;
- examples:
MasterBillA
- meaning:
- type/format: Datatypes#;
- examples:
MasterBillB
- meaning:
- type/format: Datatypes#;
- examples:
MasterBillC
- meaning:
- type/format: Datatypes#;
- examples: