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 CONSTRAINT Document_id REFERENCES Document(id), "user_id" int CONSTRAINT User_id REFERENCES User(id), "date_edited" datetime, "title" varchar(255), "content" varchar(255) ); CREATE TABLE "DocumentFile" ( "document_id" int CONSTRAINT Document_id REFERENCES Document(id), "user_id" int CONSTRAINT User_id REFERENCES User(id), "filename" varchar(255), "path" varchar(255) );