CREATE TABLE `users` (
	`id` int,
	`email` varchar(255),
	`user_name` varchar(255),
	`phone number` varchar(255),
	`first_name` varchar(255),
	`last_name` varchar(255),
	`password` varchar(255),
	`bio` varchar(255),
	`approved` bool,
	`active` bool,
	`region_id` int,
	FOREIGN KEY(`region_id`) REFERENCES `region` (`id`)
);
CREATE TABLE `box` (
	`id` int,
	`user_id` int,
	`products_id` int,
	FOREIGN KEY(`user_id`) REFERENCES `users` (``),
	FOREIGN KEY(`products_id`) REFERENCES `products` (`id`)
);
CREATE TABLE `products` (
	`id` int,
	`name` varchar(255),
	`user_id` int,
	`box_id` int,
	`description` varchar(255),
	`sh_or_do` bool,
	`published` bool,
	`date_created` datetime,
	`tag_id` int,
	FOREIGN KEY(`user_id`) REFERENCES `users` (`id`),
	FOREIGN KEY(`box_id`) REFERENCES `box` (`id`),
	FOREIGN KEY(`tag_id`) REFERENCES `tag` (`id`)
);
CREATE TABLE `tag` (
	`id` int,
	`name` varchar(255)
);
CREATE TABLE `region` (
	`id` int,
	`name` varchar(255)
);