Undefined tbl

From UG

(Difference between revisions)
Jump to: navigation, search
 
Line 1: Line 1:
-
[[Category:CT Profile]]
+
[[Category:Shipment Data Objects]]
== Related bo wiki ==
== Related bo wiki ==

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;



Personal tools