【正文】 9。,39。C000139。,39。2010122039。)GO/*留言表*/PRINT 39。CREAT TABLE Message278239。GOCREATE TABLE Message2782( messageNo2782 char(7) NOT NULL PRIMARY KEY, /*留言編號(hào)*/ adminNo2782 char(4) NOT NULL, /*管理員編號(hào)*/ studentNo2782 char(7) NOT NULL, /*學(xué)號(hào)*/ releaseDate2782 datetime NOT NULL, /*發(fā)布日期*/ messageContent2782 varchar(100) NULL, /*留言內(nèi)容*/ replyContent2782 varchar(100) NULL, /*回復(fù)內(nèi)容*/ replyDate2782 datetime NOT NULL, /*回復(fù)日期*/ CONSTRAINT Message2782FK1 FOREIGN KEY(adminNo2782) REFERENCES Admin2782(adminNo2782), CONSTRAINT Message2782FK2 FOREIGN KEY(studentNo2782) REFERENCES Student2782(studentNo2782) )GOGRANT ALL ON Message2782 TO USER01GO/*留言表（Message2782）數(shù)據(jù)：*/ INSERT Message2782 VALUES(39。M00000139。,39。A00139。,39。009218339。,39。2010121239。,39。你好，我想問一下有關(guān)工資的問題，謝謝！39。,39。關(guān)于工資，我們這里只能負(fù)責(zé)根據(jù)你的工作時(shí)間和每小時(shí)工資算出你的工資供你查詢。39。,39。2010121239。)GO/*工作意向表*/PRINT 39。CREAT TABLE workWill278239。GO CREATE TABLE workWill2782( willNo2782 char(8) NOT NULL PRIMARY KEY, /*意向編號(hào)*/ studentNo2782 char(7) NOT NULL, /*學(xué)號(hào)*/ sortNo2782 char(4) NOT NULL, /*工作類別*/ starTime2782 datetime NOT NULL, /*開始時(shí)間*/ endTime2782 datetime NOT NULL, /*結(jié)束時(shí)間*/ note2782 char(100) NULL, /*備注*/ salarywant2782 numeric(8,2) NULL, /*預(yù)期工資*/ submitDate2782 datetime NOT NULL, /*提交時(shí)間*/ CONSTRAINT workWill2782FK1 FOREIGN KEY(studentNo2782) REFERENCES Student2782(studentNo2782), CONSTRAINT workWill2782FK2 FOREIGN KEY(sortNo2782) REFERENCES jobSort2782(sortNo2782) )GOGRANT ALL ON workWill2782 TO USER01GO/*工作意向表（workWill2782）數(shù)據(jù)：*/ INSERT workWill2782 VALUES (39。W007236539。, 39。007236539。, 39。S00339。, 39。2010122039。, 39。2010122439。, NULL,39。15039。,39。2010121539。)INSERT workWill2782 VALUES (39。W008195639。, 39。008195639。, 39。S00139。, 39。2010121539。, 39。2010122339。, NULL,39。12039。,39。2010121239。)INSERT workWill2782 VALUES (39。W009218339。 , 39。009218339。, 39。S00239。, 39。2010120839。, 39。2010122839。, NULL,39。50039。,39。2010120539。)GO/*空閑時(shí)間表*/PRINT 39。CREAT TABLE freetime278239。GOCREATE TABLE freetime2782( studentNo2782 char(7) NOT NULL, /*學(xué)號(hào)*/ startTime2782 datetime NOT NULL, /*開始時(shí)間*/ endTime2782 datetime NOT NULL, /*結(jié)束時(shí)間*/ CONSTRAINT freetime2782PK PRIMARY KEY CLUSTERED (studentNo2782, startTime2782, endTime2782), CONSTRAINT freetime2782FK FOREIGN KEY(studentNo2782) REFERENCES Student2782(studentNo2782))GOGRANT ALL ON freetime2782 TO USER01GO/*空閑時(shí)間表（freetime2782）數(shù)據(jù)：*/ INSERT freetime2782 VALUES(39。007236539。,39。2010122039。,39。2010122439。)INSERT freetime2782 VALUES(39。008195639。,39。2010121539。,39。2010122339。)INSERT freetime2782 VALUES(39。009218339。,39。2010120839。,39。2010122839。)GO/*分派表*/PRINT 39。CREAT TABLE Assign278239。GOCREATE TABLE Assign2782( adminNo2782 char(4) NOT NULL, /*管理員編號(hào)*/ studentNo2782 char(7) NOT NULL, /*學(xué)號(hào)*/ jobNo2782 char(8) NOT NULL, /*工作編號(hào)*/ assignDate2782 datetime NOT NULL, /*分派時(shí)間*/ CONSTRAINT Assign2782PK PRIMARY KEY CLUSTERED (adminNo2782, studentNo2782,jobNo2782), CONSTRAINT Assign2782FK1 FOREIGN KEY(adminNo2782) REFERENCES Admin2782(adminNo2782), CONSTRAINT Assign2782FK2 FOREIGN KEY(studentNo2782) REFERENCES Student2782(studentNo2782), CONSTRAINT Assign2782FK3 FOREIGN KEY(jobNo2782) REFERENCES Job2782(jobNo2782) )GOGRANT ALL ON Assign2782 TO USER01GO/*分派表（Assign2782）數(shù)據(jù)：*/ INSERT Assign2782 VALUES(39。A00139。,39。007236539。,39。J000100239。,39。2010121639。)INSERT Assign2782 VALUES(39。A00139。,39。008195639。,39。J000100139。,39。2010120939。)INSERT Assign2782 VALUES(39。A00139。,39。009218339。,39。J000200139。,39。2010122139。)GO/*確認(rèn)表*/PRINT 39。CREAT TABLE Confirm278239。GOcreate table Confirm2782( orderNo2782 char(11) NOT NULL, /*工作單編號(hào)*/ jobNo2782 char(8) NOT NULL, /*工作編號(hào)*/ studentNo2782 char(7) NOT NULL, /*學(xué)號(hào)*/ confirmTime2782 datetime NULL, /*確認(rèn)時(shí)間*/ pleteTime2782 datetime NULL, /*完成時(shí)間*/ orderState2782 char(1) NOT NULL, /*工作單狀態(tài)*/ CONSTRAINT Confirm2782PK PRIMARY KEY CLUSTERED (orderNo2782, jobNo2782,studentNo2782), CONSTRAINT Confirm2782FK1 FOREIGN KEY(jobNo2782) REFERENCES Job2782(jobNo2782), CONSTRAINT Confirm2782FK2 FOREIGN KEY(studentNo2782) REFERENCES Student2782(studentNo2782))GOGRANT ALL ON Confirm2782 TO USER01GO/*確認(rèn)表（Confirm2782）數(shù)據(jù)：*/ INSERT Confirm2782 VALUES (39。2010122100139。, 39。J000100239。, 39。007236539。, 39。2010122139。, 39。2010122439。,39。139。)INSERT Confirm2782 VALUES (39。2010121800139。, 39。J000100139。, 39。008195639。, 39。2010121839。, 39。2010122239。,39。239。)INSERT Confirm2782 VALUES (39。2010121000139。, 39。J000200139。, 39。009218339。, 39。2010121039。, NULL,39。039。)8 附錄2 觸發(fā)器與存儲(chǔ)過程(1) 創(chuàng)建插入觸發(fā)器studentIns首先建立一張跟蹤表