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') ;