studentgrade.sql

来自「这是一个用Struts+Hibernate+Tomcat5.5.9实现的一个“课」· SQL 代码 · 共 62 行

alter table STUDENTS drop constraint FK9E77B5985CB11CBE;
drop table CLASSES;
drop table COURSEES;
drop table STUDENTS;
drop table TEACHERS;
drop table USERS;
create table CLASSES (
    ID numeric(19,0) identity not null,
    CLASS_NAME varchar(255) null,
    NUMBER int null,
    CLASSROOM int null,
    primary key (ID)
);
create table COURSEES (
    ID numeric(19,0) identity not null,
    COURSE_ID varchar(255) null,
    NAME varchar(255) null,
    MARK int null,
    PREPARE varchar(255) null,
    DEVELOP varchar(255) null,
    primary key (ID)
);
create table STUDENTS (
    ID numeric(19,0) identity not null,
    USER_NAME varchar(255) null,
    STUDENT_NUMBER varchar(255) null,
    NAME varchar(255) null,
    PASSWORD varchar(255) null,
    SEX varchar(255) null,
    AGE int null,
    TELEPHONE varchar(255) null,
    E_MAIL varchar(255) null,
    ADDRESS varchar(255) null,
    DEPARTMENT varchar(255) null,
    MARK int null,
    TEACHER_ID numeric(19,0) not null,
    primary key (ID)
);
create table TEACHERS (
    ID numeric(19,0) identity not null,
    USER_NAME varchar(255) null,
    NAME varchar(255) null,
    PASSWORD varchar(255) null,
    SEX varchar(255) null,
    TITLE varchar(255) null,
    AGE varchar(255) null,
    TELEPHONE varchar(255) null,
    E_MAIL varchar(255) null,
    ADDRESS varchar(255) null,
    primary key (ID)
);
create table USERS (
    ID numeric(19,0) identity not null,
    USER_NAME varchar(255) null,
    PASSWORD varchar(255) null,
    primary key (ID)
);
alter table STUDENTS 
    add constraint FK9E77B5985CB11CBE 
    foreign key (TEACHER_ID) 
    references TEACHERS;