student1.sql

数据插入优化系统,可以非常快的同时插入 上千条信息,

CREATE TABLE "dba"."student" ("stud_id" char(8) NOT NULL DEFAULT NULL, "name" char(10) NOT NULL DEFAULT NULL, "birthday" date DEFAULT NULL, "sex" char(2) DEFAULT NULL, "nation" char(10) DEFAULT NULL, "home" char(40) DEFAULT NULL, "tel" char(15) DEFAULT NULL, "party" char(16) DEFAULT NULL, "resume" varchar(200) DEFAULT NULL , PRIMARY KEY ("stud_id")) ;

CREATE TABLE "dba"."user_1" ("name" char(10) NOT NULL DEFAULT NULL, "password" integer NOT NULL DEFAULT NULL , PRIMARY KEY ("name")) ;

CREATE TABLE "dba"."subjectinfo" ("subject_id" char(8) NOT NULL DEFAULT NULL, "belong_id" char(8) DEFAULT NULL, "subtitle_id" char(8) DEFAULT NULL, "important" char(20) DEFAULT NULL, "doctor" char(20) DEFAULT NULL , PRIMARY KEY ("subject_id")) ;

CREATE TABLE "dba"."subtitle" ("subtitle_id" char(8) NOT NULL DEFAULT NULL, "title" char(30) NOT NULL DEFAULT NULL , PRIMARY KEY ("subtitle_id")) ;

CREATE TABLE "dba"."subject" ("subject" char(20) NOT NULL DEFAULT NULL, "startdate" date NOT NULL DEFAULT NULL, "teacher" char(20) NOT NULL DEFAULT NULL, "subtime" char(10) NOT NULL DEFAULT NULL , PRIMARY KEY ("subject")) ;

CREATE TABLE "dba"."grade" ("stud_id" char(10) NOT NULL DEFAULT NULL, "subject" char(20) NOT NULL DEFAULT NULL, "grade" integer NOT NULL DEFAULT NULL) ;