Trucking tbl

From UG

Revision as of 03:46, 15 January 2010 (edit) Alex (Talk | contribs) (Created page with 'Category:DB <pre> mysql> describe tblTrucking Shipment; +-----------------------+-------------+------+-----+---------+----------------+ | Field | Type …') ← Older edit		Revision as of 08:30, 31 January 2010 (edit) (undo) Alex (Talk | contribs) Newer edit →
Line 1:		Line 1:
-	[[Category:DB]]	+	[[Category:Shipment Data Objects]]
	<pre>		<pre>

---

Revision as of 08:30, 31 January 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
mysql>