CREATE TABLE Forest ( ForestId INT NOT NULL, Parent INT, Type CHAR( 50 ) NOT NULL, PRIMARY KEY( ForestID, Type ));