Undefined tbl

From UG

Current revision as of 19:49, 22 February 2010

[edit] Related bo wiki

CT bo

[edit] 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;