Trucking tbl

From UG

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

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