Undefined tbl

From UG

Revision as of 08:46, 31 January 2010 (edit) Alex (Talk | contribs) m (moved Tbl Undefined Shipment to Undefined Shipment (tbl)) ← Older edit		Revision as of 19:15, 3 February 2010 (edit) (undo) Alex (Talk | contribs) Newer edit →
Line 1:		Line 1:
	[[Category:Shipment Data Objects]]		[[Category:Shipment Data Objects]]
		+
		+	== Related bo wiki ==
		+	[[CT bo]]
		+
		+	== My SQL ==
	<pre>		<pre>

---

Revision as of 19:15, 3 February 2010

Related bo wiki

CT bo

My SQL

mysql> describe tblUndefined Shipment;
+---------------------+---------+------+-----+---------+----------------+
| Field               | Type    | Null | Key | Default | Extra          |
+---------------------+---------+------+-----+---------+----------------+
| UndefinedShipmentId | int(10) | NO   | PRI | NULL    | auto_increment |
| GenericShipmentId   | int(10) | NO   | MUL | NULL    |                |
+---------------------+---------+------+-----+---------+----------------+
2 rows in set


-- ----------------------------

-- Table structure for tblUndefinedShipment

-- ----------------------------

DROP TABLE IF EXISTS `tblUndefinedShipment`;

CREATE TABLE `tblUndefinedShipment` (
  `UndefinedShipmentId` int(10) NOT NULL auto_increment,
  `GenericShipmentId` int(10) NOT NULL,
  PRIMARY KEY  (`UndefinedShipmentId`),
  KEY `UndefinedShipment_GenericShipmentId` (`GenericShipmentId`),
  CONSTRAINT `tblUndefinedShipment_ibfk_11` FOREIGN KEY (`GenericShipmentId`) REFERENCES `tblGenericShipment` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=997 DEFAULT CHARSET=latin1;