Trucking tbl

From UG

Revision as of 08:46, 31 January 2010 (edit) Alex (Talk | contribs) m (moved Tbl Trucking Shipment to Trucking Shipment (tbl)) ← Older edit		Revision as of 18:05, 2 February 2010 (edit) (undo) Andrei (Talk | contribs) Newer edit →
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
-	mysql>
		+	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 1 MySQL Table Definitions 2 Related Business Object and Its Fields 2.1 TruckingShipmentId 2.2 GenericShipmentId 2.3 EstimatedDeliveryDate 2.4 ActualDeliveryDate 2.5 LastFreeDay 2.6 HouseAirwayBill 2.7 AirlineId 2.8 MasterBillOfLoading 2.9 HouseBillOfLoading 2.10 SteamshiplineId 2.11 MasterBillA 2.12 MasterBillB 2.13 MasterBillC

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: