Trucking tbl

From UG

(Difference between revisions)
Jump to: navigation, search
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

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

EstimatedDeliveryDate

ActualDeliveryDate

LastFreeDay

HouseAirwayBill

AirlineId

MasterBillOfLoading

HouseBillOfLoading

SteamshiplineId

MasterBillA

MasterBillB

MasterBillC

Personal tools