sqlplus.sql

来自「学生成绩管理系统。主要是管理学生的成绩。对成绩进行查询。」· SQL 代码 · 共 95 行

DROP TABLE Classinfo;
CREATE TABLE Classinfo(
cID    char(6) primary key not null,
cClass char(10)
);

DROP TABLE Course;
CREATE TABLE Course(
cID    char(6)  prinmary key not null,
cName  char(8)  not null
);

DROP TABLE Arcinfo;
CREATE TABLE Arcinfo(
bID        char(8) primary key not null,
cID        char(6) not null,
bGender    char(2) not null,
bNation    char(4),
bPlitic    char(8),
bFamily    char(8),
bNative    char(12),
bFaName    char(8),
bWorkAddr  char(30),
bFamAddr   char(30),
bPost      char(6),
bTel       char(12),
bDate      char(10),
bBirth     char(10),
bHobby     char(100),
bStatus    char(4),
bResume    text,
bMemo      text,
bPhoto     image,
foreign key(cID) references Classinfo(cID)
);

DROP TABLE Coursemark;
CREATE TABLE Coursemark(
bID   char(8) not null,
cID   char(6) not null,
ccID  char(6) not null,
mark  numeric(4,1) null,
foreign key(bID) references Arcinfo(bID)
);

DROP TABLE  Loginfo;
CREATE TABLE Loginfo(
uID      char(8)  not null,
User     char(10) ,
LogDate  char(10),
LogTime  char(10),
LeftTime char(10)
);

DROP TABLE Reginfo;
CREATE TABLE Reginfo(
bID    char(8) not null,
cID    char(6) not null,
age    int,
rterm  char(10),
rDate  char(10),
Mem0   text
);

DROP TABLE Userinfo;
CREATE TABLE Userinfo(
uID     char(8)  primary key not null,
User    char(10) not null,
Passwd  char(8) not null,
CreateD char(8)
);

DROP TABLE Statusinfo;
CREATE TABLE Statusinfo(
bID     char(8) not null,
Statu   char(4),
Reasion char(100),
cDate   char(10),
Memo    char(255),
foreign key(bID) reference Arcinfo(bID),
);

DROP TABLE funt;
CREATE TABLE funt(
fID    char(10) primary key not null,
fName  char(10) not null
);

DROP TABLE grant;
CREATE TABLE grant(
uID    char(8) not null,
fID    char(10) not null,
rright bit,
foreign key(uID) reference Userinfo(uID)
);