Trucking tbl
From UG
(Difference between revisions)
m (moved Tbl Trucking Shipment to Trucking Shipment (tbl)) |
|||
Line 1: | Line 1: | ||
[[Category:Shipment Data Objects]] | [[Category:Shipment Data Objects]] | ||
+ | |||
+ | == MySQL Table Definitions == | ||
+ | |||
+ | on 02-Feb-2010 | ||
<pre> | <pre> | ||
Line 23: | Line 27: | ||
+-----------------------+-------------+------+-----+---------+----------------+ | +-----------------------+-------------+------+-----+---------+----------------+ | ||
13 rows in set | 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; | ||
</pre> | </pre> | ||
+ | |||
+ | == 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:'' |
Revision as of 18:05, 2 February 2010
Contents |
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: