jxjstudent.sql

学生管理系统 采用SQL语言来编写

CREATE TABLE "dba"."student" ("xh" char(10) NOT NULL DEFAULT NULL, "ksh" char(15) DEFAULT NULL, "xm" char(8) DEFAULT NULL, "xb" char(2) DEFAULT NULL, "csrq" date DEFAULT NULL, "mz" char(8) DEFAULT NULL, "xsh" char(24) DEFAULT NULL, "zyh" char(24) DEFAULT NULL, "bh" char(16) DEFAULT NULL, "xz" char(1) DEFAULT NULL, "dqszj" char(4) DEFAULT NULL, "zylb" char(10) DEFAULT NULL, "rxrq" char(10) DEFAULT NULL, "pycc" char(10) DEFAULT NULL, "zzmm" char(16) DEFAULT NULL, "sfzh" char(20) DEFAULT NULL , PRIMARY KEY ("xh")) ;
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', -12, 400, 'N', 'N', 134, 33, 'System', -12, 400, 'N', 'N', 134, 33, 'System', -12, 400 , 'N', 'N', 134, 33, 'System', '') ;
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) values ('student', 'dba', 'xh', '学号', 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) values ('student', 'dba', 'ksh', '考试号', 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) values ('student', 'dba', 'xm', '姓名', 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) values ('student', 'dba', 'xb', '性别', 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_mask, pbc_case, pbc_hght, pbc_wdth, pbc_bmap) values ('student', 'dba', 'csrq', '出生日期', 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) values ('student', 'dba', 'mz', '民族', 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) values ('student', 'dba', 'xsh', '学院', 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) values ('student', 'dba', 'zyh', '专业', 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) values ('student', 'dba', 'bh', '班级', 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) values ('student', 'dba', 'xz', '学制', 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) values ('student', 'dba', 'dqszj', '入学时间', 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) values ('student', 'dba', 'zylb', '学科门类', 23 , '学科门类', 25, 25 , 0 , 0 , 0 , 'N') ;
insert into "dba".pbcatcol (pbc_tnam, pbc_ownr, pbc_cnam, pbc_lpos, pbc_hpos, pbc_jtfy, pbc_case, pbc_hght, pbc_wdth, pbc_bmap) values ('student', 'dba', 'rxrq', 0 , 0, 0 , 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) values ('student', 'dba', 'pycc', '学历层次', 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) values ('student', 'dba', 'zzmm', '政治面貌', 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) values ('student', 'dba', 'sfzh', '身份证号', 23 , '身份证号', 25, 25 , 0 , 0 , 0 , 'N') ;