CREATE TABLE `Client` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`age` int NOT NULL,
	`sex` varchar(255) NOT NULL,
	PRIMARY KEY (`id`)
);

CREATE TABLE `Product` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`name` varchar(255) NOT NULL,
	`company` varchar(255) NOT NULL,
	`cost` DECIMAL NOT NULL,
	PRIMARY KEY (`id`)
);

CREATE TABLE `Product_Product_Group` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`product_id` bigint NOT NULL,
	`product_group_id` bigint NOT NULL,
	PRIMARY KEY (`id`)
);

CREATE TABLE `Product_Group` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`group` varchar(255) NOT NULL,
	PRIMARY KEY (`id`)
);

CREATE TABLE `Pharmacy` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`type` varchar(255) NOT NULL,
	`area` varchar(255) NOT NULL,
	PRIMARY KEY (`id`)
);

CREATE TABLE `Transaction` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`date` DATETIME NOT NULL,
	`client_id` DATETIME NOT NULL,
	`pharmacy_id` DATETIME NOT NULL,
	PRIMARY KEY (`id`)
);

CREATE TABLE `Product_Transaction` (
	`id` bigint NOT NULL AUTO_INCREMENT,
	`product_id` bigint NOT NULL,
	`transaction_id` bigint NOT NULL,
	PRIMARY KEY (`id`)
);

ALTER TABLE `Product_Product_Group` ADD CONSTRAINT `Product_Product_Group_fk0` FOREIGN KEY (`product_id`) REFERENCES `Product`(`id`);

ALTER TABLE `Product_Product_Group` ADD CONSTRAINT `Product_Product_Group_fk1` FOREIGN KEY (`product_group_id`) REFERENCES `Product_Group`(`id`);

ALTER TABLE `Transaction` ADD CONSTRAINT `Transaction_fk0` FOREIGN KEY (`client_id`) REFERENCES `Client`(`id`);

ALTER TABLE `Transaction` ADD CONSTRAINT `Transaction_fk1` FOREIGN KEY (`pharmacy_id`) REFERENCES `Pharmacy`(`id`);

ALTER TABLE `Product_Transaction` ADD CONSTRAINT `Product_Transaction_fk0` FOREIGN KEY (`product_id`) REFERENCES `Product`(`id`);

ALTER TABLE `Product_Transaction` ADD CONSTRAINT `Product_Transaction_fk1` FOREIGN KEY (`transaction_id`) REFERENCES `Transaction`(`id`);