【正文】 (jobNo2782 like 39。[J][09][09][09][09][09][09][09]39。), jobName2782 varchar(20) NOT NULL, /*工作名稱*/ jobProperty2782 varchar(20) NOT NULL, /*工作屬性*/ sortNo2782 char(4) NOT NULL, /*工作類別*/ jobInfo2782 varchar(100) NULL, /*工作信息*/ personNeed2782 int NULL, /*所需人數(shù)*/ startTime2782 datetime NOT NULL, /*開始時間*/ deadline2782 datetime NULL, /*截止時間*/ salary2782 numeric(8,2) NULL, /*工資（小時）*/ panyNo2782 char(5) NOT NULL, /*公司編號*/ provideDate2782 datetime NOT NULL, /*提供時間*/ CONSTRAINT Job2782FK1 FOREIGN KEY(sortNo2782) REFERENCES jobSort2782(sortNo2782), CONSTRAINT Job2782FK2 FOREIGN KEY(panyNo2782) REFERENCES Company2782(panyNo2782) )GOGRANT ALL ON Job2782 TO USER01GO/*工作表（Job2782）數(shù)據(jù)：*/ INSERT Job2782 VALUES(39。J000100139。,39。打掃主要辦公室39。,39?？煞峙?9。,39。S00139。,NULL, 39。539。,39。2010122039。,39。2010122239。,39。1039。,39。C000139。,39。2010121839。)INSERT Job2782 VALUES(39。J000200139。,39。公司產(chǎn)品的校園代理39。,39?？煞峙?9。,39。S00239。,39。類似于區(qū)域經(jīng)理39。,39。139。,39。2010121039。,39。2010122539。,39。4039。,39。C000239。,39。2010120739。)INSERT Job2782 VALUES(39。J000100239。,39。派發(fā)傳單39。,39。可分配39。,39。S00339。,39。到市區(qū)各大商場派發(fā)傳單39。,39。1039。,39。2010122239。,39。2010122339。,39。1539。,39。C000139。,39。2010122039。)GO/*留言表*/PRINT 39。CREAT TABLE Message278239。GOCREATE TABLE Message2782( messageNo2782 char(7) NOT NULL PRIMARY KEY, /*留言編號*/ adminNo2782 char(4) NOT NULL, /*管理員編號*/ studentNo2782 char(7) NOT NULL, /*學(xué)號*/ 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ù)你的工作時間和每小時工資算出你的工資供你查詢。39。,39。2010121239。)GO/*工作意向表*/PRINT 39。CREAT TABLE workWill278239。GO CREATE TABLE workWill2782( willNo2782 char(8) NOT NULL PRIMARY KEY, /*意向編號*/ studentNo2782 char(7) NOT NULL, /*學(xué)號*/ sortNo2782 char(4) NOT NULL, /*工作類別*/ starTime2782 datetime NOT NULL, /*開始時間*/ endTime2782 datetime NOT NULL, /*結(jié)束時間*/ note2782 char(100) NULL, /*備注*/ salarywant2782 numeric(8,2) NULL, /*預(yù)期工資*/ submitDate2782 datetime NOT NULL, /*提交時間*/ 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/*空閑時間表*/PRINT 39。CREAT TABLE freetime278239。GOCREATE TABLE freetime2782( studentNo2782 char(7) NOT NULL, /*學(xué)號*/ startTime2782 datetime NOT NULL, /*開始時間*/ endTime2782 datetime NOT NULL, /*結(jié)束時間*/ CONSTRAINT freetime2782PK PRIMARY KEY CLUSTERED (studentNo2782, startTime2782, endTime2782), CONSTRAINT freetime2782FK FOREIGN KEY(studentNo2782) REFERENCES Student2782(studentNo2782))GOGRANT ALL ON freetime2782 TO USER01GO/*空閑時間表（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, /*管理員編號*/ studentNo2782 char(7) NOT NULL, /*學(xué)號*/ jobNo2782 char(8) NOT NULL, /*工作編號*/ assignDate2782 datetime NOT NULL, /*分派時間*/ 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。201