V302Lk76

1DROP TABLE IF EXISTS `swampdb2003`.`FieldObsResult`;
2CREATE TABLE `swampdb2003`.`FieldObsResult` (
3  `FieldObsResultRowID` int(10) unsigned NOT NULL auto_increment,
4  `SampleRowID` int(10) unsigned NOT NULL,
5  `ConstituentRowID` int(10) unsigned NOT NULL,
6  `TextResult` VARCHAR(80) NULL,
7  `FieldObsResultComments` VARCHAR(150) NULL,
8  PRIMARY KEY (`FieldObsResultRowID`),
9  CONSTRAINT `FK_SampleRowID` FOREIGN KEY (`SampleRowID`) REFERENCES `Sample` (`SampleRowID`) ON UPDATE CASCADE,
10  CONSTRAINT `FK_ConstituentRowID` FOREIGN KEY (`ConstituentRowID`) REFERENCES `ConstituentLookUp` (`ConstituentRowID`) ON UPDATE CASCADE,
11  UNIQUE INDEX `UniqueConstraint` (`SampleRowID`, `ConstituentRowID`)
12)
13ENGINE = INNODB;