Trucking tbl

From UG

Revision as of 19:14, 3 February 2010 (edit) Alex (Talk | contribs) ← Older edit		Current revision as of 19:49, 22 February 2010 (edit) (undo) Alex (Talk | contribs)
(3 intermediate revisions not shown)
Line 56:		Line 56:
	</pre>		</pre>
-	== Related Business Object and Its Fields ==	+	==   Fields ==
-	This table corresponds to '''Trucking Shipment''' business object.	+
		+	=== TruckingShipmentId ===
-	See its fields (attributes) below.	+	` int(10) NOT NULL AUTO_INCREMENT,
-		+
-	=== TruckingShipmentId ===	+
-	* ''meaning:'' PRI key	+
	=== GenericShipmentId ===		=== 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 ===	+	` int(10) NOT NULL,
-	* ''meaning:''	+
-	* ''type/format:'' [[Datatypes#]];	+
-	* ''examples:''	+
-	=== MasterBillC ===	+	`EstimatedDeliveryDate` date DEFAULT NULL,
-	* ''meaning:''	+	`ActualDeliveryDate` date DEFAULT NULL,
-	* ''type/format:'' [[Datatypes#]];	+	`LastFreeDay` date DEFAULT NULL,
-	* ''examples:''	+	`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 '',

---

Current revision as of 19:49, 22 February 2010

Contents 1 Related bo wiki 2 MySQL Table Definitions 3 Fields 3.1 TruckingShipmentId 3.2 GenericShipmentId

[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 ,