CREATE TABLE `User` ( `id` int PRIMARY KEY, `password` varchar(255), `date_joined` datetime, `email` varchar(255) ); CREATE TABLE `Document` ( `id` int PRIMARY KEY ); CREATE TABLE `DocumentLog` ( `document_id` int, `user_id` int, `date_edited` datetime, `title` varchar(255), `content` varchar(255), FOREIGN KEY(`document_id`) REFERENCES `Document` (`id`), FOREIGN KEY(`user_id`) REFERENCES `User` (`id`) ); CREATE TABLE `DocumentFile` ( `document_id` int, `user_id` int, `filename` varchar(255), `path` varchar(255), FOREIGN KEY(`document_id`) REFERENCES `Document` (`id`), FOREIGN KEY(`user_id`) REFERENCES `User` (`id`) );