?? jxjstudent.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') ;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -