数据库课程设计---某期刊的在线投稿审稿管理系统

CREATE DATABASE online journal management; DEFAULT CHARACTER SET utf8; DEFAULT COLLATE utf8_general_ci; CREATE TABLE admin ( adminID INT(10), adminName VARCHAR(20) NOT NULL, password VARCHAR(20) NOT NULL, createtime DATETIME, PRIMARY KEY(admin) ); CREATE TABLE user ( userID INT(10), flag INT(1), userName VARCHAR(20) NOT NULL, password VARCHAR(20) NOT NULL, createtime DATE, subject VARCHAR(20) NOT NULL, userBirthday DATETIME, userSex VARCHAR(2), education VARCHAR(10), phone INT(20), email VARCHAR(20), PRIMARY KEY(userID,flag) ); CREATE TABLE journal ( journalID INT(10), cTitle VARCHAR(20), eTitle VARCHAR(20), cabstract VARCHAR(50), eabstract VARCHAR(50), ckeywords VARCHAR(20), ekeywords VARCHAR(20), fundtype VARCHAR(10), fwriterName VARCHAR(10), swriterName VARCHAR(10), twriterName VARCHAR(10), subject VARCHAR(20) NOT NULL, PRIMARY KEY(journalID) ); CREATE TABLE submitdetails ( submissionDate DATETIME, modifiedDate DATETIME, auditOption VARCHAR(50), userID INT(10), flag INT(2), journalID INT(10), count INT(5), PRIMARY KEY(userID,flag,journalID), FOREIGN KEY(userID)REFERENCES user(userID), FOREIGN KEY(flag)REFERENCES user(flag), FOREIGN KEY(journal)REFERENCES journal(journalID) ) CREATE TABLE processdetails ( acceptedDate DATETIME, withdrawlDate DATETIME, journalStatus VARCHAR(10), contributorFree INT(20), reviewerFree INT(20), adminID INT(10), journalID INT(10), PRIMARY KEY(adminID,journalID), FOREIGN KEY(adminID)REFERENCES admin(adminID), FOREIGN KEY(journalID)REFERENCES journal(journalID) ); CREATE TABLE Omessage ( senderID INT(10) NOT NULL, recipientID INT(10) NOT NULL, message INT(10) NOT NULL, sendTime INT(100) );