題目盛發(fā)3c量販網(wǎng)路問卷調(diào)查系統(tǒng)(編輯修改稿)
2025-04-22 05:31 本頁面
【文章內(nèi)容簡介】 HAR(100) NOT NULL,qmPrefix VARCHAR(100),qmPostfix VARCHAR(100),adNo CHAR(6) NOT NULL,qmStarttime DATE NOT NULL,qmEndtime DATE NOT NULL,PRIMARY KEY (qmId),FOREIGN KEY (tId) REFERENCES Type (tId)ON DELETE CASCADE,FOREIGN KEY (adNo) REFERENCES Admin (adNo)ON DELETE SET NULL)。CREATE TABLE Questiond(qmId CHAR(3) NOT NULL,qdId CHAR(2) NOT NULL,qdTitle VARCHAR(100) NOT NULL,amount INT,PRIMARY KEY (qmId, qdId),FOREIGN KEY (qmId) REFERENCES Questionm (qmId)ON DELETE CASCADE)。CREATE TABLE Choice(qmId CHAR(3) NOT NULL,qdId CHAR(2) NOT NULL,no CHAR(2) NOT NULL,content VARCHAR(100) NOT NULL,cJump CHAR(2),jumpId CHAR(2),PRIMARY KEY (qmId, qdId, no),FOREIGN KEY (qmId, qdId) REFERENCES Questiond (qmId, qdId)ON DELETE CASCADE)。CREATE TABLE Sessions(qmId CHAR(3) NOT NULL,seq INT NOT NULL,sdate DATE NOT NULL,PRIMARY KEY (qmId, seq),FOREIGN KEY (qmId) REFERENCES Questionm (qmId)ON DELETE CASCADE)。CR
試題試卷相關(guān)推薦
鄂ICP備17016276號(hào)-1