student.sql

本电子书

CREATE TABLE "dba"."student" ("student_id" char(10) NOT NULL DEFAULT NULL, "name" char(10) NOT NULL DEFAULT NULL, "birthday" date DEFAULT NULL, "address" varchar(50) DEFAULT NULL , PRIMARY KEY ("student_id")) ;
insert into "dba".pbcattbl (pbt_tnam, pbt_ownr, pbd_fhgt, pbd_fwgt, pbd_fitl, pbd_funl, pbd_fchr, pbd_fptc, pbd_ffce, pbh_fhgt, pbh_fwgt, pbh_fitl, pbh_funl, pbh_fchr, pbh_fptc, pbh_ffce, pbl_fhgt, pbl_fwgt, pbl_fitl, pbl_funl, pbl_fchr, pbl_fptc, pbl_ffce, pbt_cmnt) values ('student', 'dba', -10, 400, 'N', 'N', 0, 34, 'Arial', -10, 400, 'N', 'N', 0, 34, 'Arial', -10, 400 , 'N', 'N', 0, 34, 'Arial', '') ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap, pbc_cmnt ) values ('student', 'dba', 'student_id', '学号', 23 , '学号', 25, 25 , 0 , 0 , 0 , 'N', '学号' ) ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap, pbc_cmnt ) values ('student', 'dba', 'name', '姓名', 23 , '姓名', 25, 25 , 0 , 0 , 0 , 'N', '姓名' ) ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap, pbc_cmnt ) values ('student', 'dba', 'birthday', '生日', 23 , '生日', 25, 25 , 0 , 0 , 0 , 'N', '生日' ) ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap, pbc_cmnt ) values ('student', 'dba', 'address', '家庭住址', 23 , '家庭住址', 25, 25 , 0 , 0 , 0 , 'N', '家庭住址' ) ;
CREATE TABLE "dba"."lesson" ("lessonid" char(10) NOT NULL DEFAULT NULL, "name" char(20) NOT NULL DEFAULT NULL, "teacher" char(10) DEFAULT NULL, "book" char(50) DEFAULT NULL , PRIMARY KEY ("lessonid")) ;
insert into "dba".pbcattbl (pbt_tnam, pbt_ownr, pbd_fhgt, pbd_fwgt, pbd_fitl, pbd_funl, pbd_fchr, pbd_fptc, pbd_ffce, pbh_fhgt, pbh_fwgt, pbh_fitl, pbh_funl, pbh_fchr, pbh_fptc, pbh_ffce, pbl_fhgt, pbl_fwgt, pbl_fitl, pbl_funl, pbl_fchr, pbl_fptc, pbl_ffce, pbt_cmnt) values ('lesson', 'dba', -10, 400, 'N', 'N', 0, 34, 'Arial', -10, 400, 'N', 'N', 0, 34, 'Arial', -10, 400 , 'N', 'N', 0, 34, 'Arial', '') ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap, pbc_cmnt ) values ('lesson', 'dba', 'lessonid', '课程代号', 23 , '课程代号', 25, 25 , 0 , 0 , 0 , 'N', '课程代号' ) ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap, pbc_cmnt ) values ('lesson', 'dba', 'name', '课程名称', 23 , '课程名称', 25, 25 , 0 , 0 , 0 , 'N', '课程名称' ) ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap, pbc_cmnt ) values ('lesson', 'dba', 'teacher', '授课老师', 23 , '授课老师', 25, 25 , 0 , 0 , 0 , 'N', '授课老师' ) ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap, pbc_cmnt ) values ('lesson', 'dba', 'book', '使用教材', 23 , '使用教材', 25, 25 , 0 , 0 , 0 , 'N', '使用教材' ) ;
CREATE TABLE "dba"."score" ("student_id" char(10) NOT NULL DEFAULT NULL, "lessonid" char(10) NOT NULL DEFAULT NULL, "score" decimal(5,2) DEFAULT 0.0 , PRIMARY KEY ("student_id", "lessonid")) ;
insert into "dba".pbcattbl (pbt_tnam, pbt_ownr, pbd_fhgt, pbd_fwgt, pbd_fitl, pbd_funl, pbd_fchr, pbd_fptc, pbd_ffce, pbh_fhgt, pbh_fwgt, pbh_fitl, pbh_funl, pbh_fchr, pbh_fptc, pbh_ffce, pbl_fhgt, pbl_fwgt, pbl_fitl, pbl_funl, pbl_fchr, pbl_fptc, pbl_ffce, pbt_cmnt) values ('score', 'dba', -10, 400, 'N', 'N', 0, 34, 'Arial', -10, 400, 'N', 'N', 0, 34, 'Arial', -10, 400 , 'N', 'N', 0, 34, 'Arial', '') ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap, pbc_cmnt ) values ('score', 'dba', 'student_id', '学号', 23 , '学号', 25, 25 , 0 , 0 , 0 , 'N', '学号' ) ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap, pbc_cmnt ) values ('score', 'dba', 'lessonid', '课程代号', 23 , '课程代号', 25, 25 , 0 , 0 , 0 , 'N', '课程代号' ) ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_labl, pbc_lpos, pbc_hdr, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap, pbc_cmnt ) values ('score', 'dba', 'score', '考试成绩', 23 , '考试成绩', 25, 25 , 0 , 0 , 0 , 'N', '考试成绩' ) ;