CREATE TABLE `Animal` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`Species` TEXT NOT NULL,
	`Enclosure` bigint NOT NULL,
	PRIMARY KEY (`id`)
);

CREATE TABLE `Enclosure` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`Name` TEXT NOT NULL UNIQUE,
	`PrimaryCaretaker` bigint NOT NULL,
	PRIMARY KEY (`id`)
);

CREATE TABLE `Worker` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`Name` TEXT NOT NULL UNIQUE,
	`Role` TEXT NOT NULL,
	PRIMARY KEY (`id`)
);

CREATE TABLE `ItemTransaction` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`Amount` DECIMAL NOT NULL,
	`Description` DECIMAL NOT NULL,
	`Time` TIMESTAMP NOT NULL,
	`Worker` bigint NOT NULL,
	PRIMARY KEY (`id`)
);

CREATE TABLE `TicketTransaction` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`Time` TIMESTAMP NOT NULL,
	`price` DECIMAL NOT NULL AUTO_INCREMENT,
	`Worker` bigint NOT NULL,
	PRIMARY KEY (`id`)
);

ALTER TABLE `Animal` ADD CONSTRAINT `Animal_fk0` FOREIGN KEY (`Enclosure`) REFERENCES `Enclosure`(`id`);

ALTER TABLE `Enclosure` ADD CONSTRAINT `Enclosure_fk0` FOREIGN KEY (`PrimaryCaretaker`) REFERENCES `Worker`(`id`);

ALTER TABLE `ItemTransaction` ADD CONSTRAINT `ItemTransaction_fk0` FOREIGN KEY (`Worker`) REFERENCES `Worker`(`id`);

ALTER TABLE `TicketTransaction` ADD CONSTRAINT `TicketTransaction_fk0` FOREIGN KEY (`Worker`) REFERENCES `Worker`(`id`);