CREATE TABLE PRATIMONIO_AMBIENTAL
	(ID INT UNSIGNED NOT NULL PRIMARY KEY,
	NUM_INVETARIO INT ,
	ETNOSITIO TEXT ,
	DESCRICAO TEXT ,
	LINK_FOTOGRAFIA TEXT,
	INDEX (ID),
FOREIGN KEY (ID)
     	REFERENCES PATRIMONIO(ID)
	ON UPDATE CASCADE ON DELETE CASCADE

	) ENGINE=InnoDB;

CREATE TABLE PATRIMONIO_BOTANICO
	(ID INT UNSIGNED PRIMARY KEY,
	NUM_BIB INT ,
	TAXA TEXT ,
	DESIGNACAO TEXT ,
	FUNCAO TEXT,
	INDEX (ID),
  	FOREIGN KEY (ID)
     	REFERENCES PATRIMONIO_AMBIENTAL(ID)
	ON UPDATE CASCADE ON DELETE CASCADE
	) ENGINE=InnoDB;