Undefined tbl
From UG
(Difference between revisions)
m (moved Undefined Shipment (tbl) to Undefined tbl) |
|||
Line 1: | Line 1: | ||
- | [[Category: | + | [[Category:CT Profile]] |
== Related bo wiki == | == Related bo wiki == |
Revision as of 21:28, 3 February 2010
Related bo wiki
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;