student.sql

来自「数据库方面的很好的材料」· SQL 代码 · 共 63 行

/*创建系统用户表格*/
CREATE TABLE HXH.user_info
(
  user_ID VARCHAR2(10) NOT NULL,
  user_PWD VARCHAR2(10) NOT NULL,
  user_Des VARCHAR2(20),
  CONSTRAINT user_ID_PK PRIMARY KEY(User_ID)
)
TABLESPACE"USER_DATA";
/*创建学生基本信息表格*/
CREATE TABLE hxh.student_info
(
  student_ID Number(8) NOT NULL,
  student_Name VARCHAR2(10),
  student_Sex VARCHAR2(2),
  born_Date date,
  class_NO Number(8),
  tele_Number VARCHAR2(10),
  ru_Date date,
  address varchar(50),
  comments varchar(200),
  CONSTRAINT student_info_PK PRIMARY KEY(student_id) 
)
TABLESPACE"USER_DATA";
/*创建班级信息表格*/
CREATE TABLE HXH.class_info
(
  class_No Number(8) NOT NULL,
  grade VARCHAR2(10),
  director VARCHAR2(10),
  classroom_No VARCHAR2(10),
  CONSTRAINT class_No_PK PRIMARY KEY(class_No)
)
TABLESPACE"USER_DATEA";
/*创建课程基本信息表*/
CREATE TABLE HXH.course_info
(
  course_No Number(8) NOT NULL,
  course_Name VARCHAR2(10),
  course_Type VARCHAR2(10),
  course_Des VARCHAR2(50),
  CONSTRAINT course_No_PK PRIMARY KEY(COURSE_No)
)
TABLESPACE"USER_DATA";
/*创建年级课程设置信息表*/
CREATE TABLE HXH.gradecourse_info
(
  grade VARCHAR2(10),
  course_No Number(8)
)
TABLESPACE"USER_DATA";
/*创建学生成绩信息表*/
CREATE TABLE HXH.result_info
(
  exam_No VARCHAR2(10) NOT NULL,
  student_ID Number(8) NOT NULL,
  student_Name VARCHAR2(10),
  class_No Number(8),
  course_Name VARCHAR2(10),
  resilt Number(3,2),
  CONSTRAINT reslut_info_PK PRIMARY KEY(exam_no,student_id)
)
TABLESPACE"USER_DATA";