?? 最新圖書.txt
字號:
create table thushuchuli( /*圖書損失處理*/
ChuLiyichi datetime,
name_no char(10),
book_no char(30),
book_destorykind char(20),
fakuanmoney money,
foreign key (book_no) references book(book_no),
foreign key (name_no) references readname(name_no));
create unique index name_no_index on thushuchuli(ChuLiyichi);
insert into ThuShuChuLi()
values("1992-2-2","0003","7-900084-17-7 9787900084678","bookbreak",50);
create table pop/*圖書流行指數(shù)*/
(book_no char(30) primary key,
point integer,
foreign key (book_no) references book(book_no));
/*讀者的資料*/
CREATE TABLE readname(
name_no char(10) primary key,
name_name char(8),
name_class char(20));
//讀者帳號
create table readpass(
name_name char(9) primary key,
name_pass char(8) not null,
sex char(2),
department char(12),
telephone char(13),
grade char(10) not null,
sign int, );
/*讀者的欠款*/
CREATE TABLE money(
name_no char(10) primary key,
name_name char(8),
name_arrearage money);
insert into money
values('200105001','林健雄',0);
insert into money
values('200105002','何文杰',100);
/*管理員帳號*/
//書本信息
create table book(
book_NO char(30) primary key,/* 圖書編號*/
book_name char(30) not null,
book_zname char(20),
book_publish char(26),
enter_num integer,
book_jg money,
enter_date datetime,
Book_leave integer,
kind integer);
insert into book
values('7-900084-17-7 9787900084170','photoshop6.0','斐紅義','中科多脈管體電子',5,27,'2003-10-1',5,10);
insert into book
values('7-900084-17-7 9787900084678','pb8.0','power','石油大學pb',5,27,'2003-10-1',5,5);
insert into book
values('7-900084-17-7 9787900085688','asp','asp','石油大學asp',5,29,'2003-10-1',5,11);
insert into book
values('7-900084-17-7 9757900184678','java','power','石油大學java',5,28,'2003-10-1',5,11);
insert into book
values('7-900084-17-7 9787901084678','mx','power','石油大學mx',5,32,'2003-10-1',5,11);
insert into book
values('7-900084-17-7 9787910084678','autoware','ware','石油大學ware',5,26,'2003-10-1',5,7);
insert into book
values('7-900084-17-7 9788900084678','english','english','石油大學english',5,25,'2003-10-1',5,1);
insert into book
values('7-922084-17-7 9787900084678','sd','power','石油大學pb',5,27,'2003-10-1',5,5);
insert into book
values('7-922084-17-7 9787900085688','addd','asp','石油大學asp',5,29,'2003-10-1',5,11);
insert into book
values('7-922084-17-7 9757900184678','jggg','power','石油大學java',5,28,'2003-10-1',5,11);
insert into book
values('7-922084-17-7 9787901084678','mmm','power','石油大學mx',5,32,'2003-10-1',5,11);
insert into book
values('7-9022084-17-7 9787910084678','pkh','ware','石油大學ware',5,26,'2003-10-1',5,7);
insert into book
values('7-902284-17-7 9788900084678','yhh','en3glish','石油大學english',5,25,'2003-10-1',5,1);
insert into book
values('7-111084-17-7 9787900084678','sd','po3wer','石油大學pb',5,27,'2003-10-1',5,5);
insert into book
values('7-111084-17-7 9787900085688','addd','as3p','石油大學asp',5,29,'2003-10-1',5,11);
insert into book
values('7-111084-17-7 9757900184678','jggg','p3ower','石油大學java',5,28,'2003-10-1',5,11);
insert into book
values('7-111084-17-7 9787901084678','mmm','po3wer','石油大學mx',5,32,'2003-10-1',5,11);
insert into book
values('7-9111084-17-7 9787910084678','pkh','wa3re','石油大學ware',5,26,'2003-10-1',5,7);
insert into book
values('7-11184-17-7 9788900084678','yhh','engli3sh','石油大學english',5,25,'2003-10-1',5,1);
insert into book
values('7-922084-17-7 9787900084678','sd','powe5r','石油大學pb',5,27,'2003-10-1',5,5);
insert into book
values('7-922084-17-7 9787900085777','addd','as5p','石油大學asp',5,29,'2003-10-1',5,11);
insert into book
values('7-922084-17-7 97579001847777','jggg','powe5r','石油大學java',5,28,'2003-10-1',5,11);
insert into book
values('7-922084-17-7 9787901087777','mmm','powe5r','石油大學mx',5,32,'2003-10-1',5,11);
insert into book
values('7-9022084-17-7 9787910087777','pkh','war5e','石油大學ware',5,26,'2003-10-1',5,7);
insert into book
values('7-902284-17-7 9788900087777','yhh','englis5h','石油大學english',5,25,'2003-10-1',5,1);
/*創(chuàng)建書的類型名稱與代號的對應表*/
create table kinds(kind integer primary key,
name char(26));
insert into kinds
values(1,'a');
insert into kinds
values(2,'b');
insert into kinds
values(3,'c');
insert into kinds
values(4,'d');
insert into kinds
values(5,'e');
insert into kinds
values(7,'f');
insert into kinds
values(8,'g');
insert into kinds
values(9,'h');
insert into kinds
values(10,'i');
insert into kinds
values(11,'j');
//系統(tǒng)設置
CREATE TABLE sz(
sta char(1) primary key,
bmp char(1),
flag char(1));
/*已借書的情況表*/在pb80中運行時會發(fā)生date5 is not null的錯誤
CREATE TABLE yjbook( //讀者借書情況
name_no char(10) primary key,//讀者
book_no1 char(30),
book1 char(30),
date1 datetime,
book_no2 char(30),
book2 char (30),
date2 datetime,
book_no3 char(30),
book3 char(30),
date3 datetime,
book_no4 char(30),
book4 char(30),
date4 datetime,
book_no5 char(30),
book5 char(30),
date5 datetime
foreign key (name_no) references readname(name_no));
create table wantlend( //已選擇想借的書
name_no char(10) primary key,
book_NO1 char(30) ,/* 圖書編號*/
book_name1 char(26) ,//書名
book_NO2 char(30) ,
book_name2 char(26),
book_NO3 char(30) ,
book_name3 char(26) ,
book_NO4 char(30) ,
book_name4 char(26),
book_NO5 char(30) ,
book_name5 char(26) );
//入庫圖書詳細信息表
create table book_in(
book_NO char(30) not null,/* 圖書編號*/
book_name char(30) not null,
book_zname char(20),
book_publish char(26),
enter_num integer,
book_jg money,
enter_date datetime primary key,
Book_leave integer,
kind integer);
//保存刪除圖書的表
create table book_leave_stay(
book_NO char(30) primary key,/* 圖書編號*/
book_name char(30) not null,
book_zname char(20),
book_publish char(26),
book_leave integer,
book_jg money,
enter_date datetime,
kind integer,
detail char(50));
/*money_list*/
create table money_list
(name_no char(10) primary key,
name_arrearage money,
foreign key(name_no) references money(name_no)
);
/*yjlist*/
create table yjlist
(id char(1)primary key,
name_no char(10),
name_name char(8),
book_no char(30),
book char(30),
datej datetime
); ?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -