CREATE TABLE `user` (
	`id` int,
	`email` varchar(255),
	`username` varchar(255),
	`password` varchar(255),
	`date_joined` datetime,
	FOREIGN KEY(`date_joined`) REFERENCES `date` (`joined`)
);
CREATE TABLE `conversation` (
	`id` int,
	`user_id` int,
	`date_created` datetime,
	FOREIGN KEY(`user_id`) REFERENCES `user` (`id`),
	FOREIGN KEY(`date_created`) REFERENCES `date` (`created`)
);
CREATE TABLE `message` (
	`id` int,
	`conversation_id` int,
	`body` varchar(255),
	`date_created` datetime,
	FOREIGN KEY(`conversation_id`) REFERENCES `conversation` (`id`),
	FOREIGN KEY(`date_created`) REFERENCES `date` (`created`)
);
CREATE TABLE `recipient` (
	`user_id` int,
	`conversation_id` int,
	`is_read` bool,
	FOREIGN KEY(`user_id`) REFERENCES `user` (`id`),
	FOREIGN KEY(`conversation_id`) REFERENCES `conversation` (`id`)
);