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