lib .sql

Power Builder 9.0信息管理系统开发源代码

/*1.3.1  创建系统用户表格user_Info*/
CREATE TABLE user_Info1
(
	user_ID VARCHAR (10) NOT NULL ,
	user_PWD VARCHAR (10) NOT NULL ,
	user_Des VARCHAR (20),
	CONSTRAINT user_ID_PK1  PRIMARY KEY (User_ID)
)

/*1.3.2  创建读者种类信息表格readertype*/
CREATE TABLE readertype
(
	typeno VARCHAR(10) NOT NULL ,
	typename VARCHAR(10) NOT NULL ,
	booknumber numeric(4, 0) NULL ,
	bookdays numeric(4, 0) NULL ,
	userfullife numeric(5, 0) NULL ,
	memo VARCHAR(200) NULL,
	CONSTRAINT readertype_typeno_PK  PRIMARY KEY (typeno)
)

/*1.3.3  创建读者信息表格readers*/
CREATE TABLE readers
(
	readerno VARCHAR(10) NOT NULL ,
	readername VARCHAR(20) NULL ,
	readersex VARCHAR(3) NULL ,
	readertype VARCHAR(10) NULL ,
	readerdep VARCHAR(40) NULL ,
	address VARCHAR(40) NULL ,
	readertel VARCHAR(20) NULL ,
	email VARCHAR(20)  NULL ,
	checkdate datetime NULL ,
	readermemo VARCHAR(100) NULL,
	CONSTRAINT readers_readerno_PK PRIMARY KEY (readerno)
)

/*1.3.4  创建书籍类别信息信息表booktype*/
CREATE TABLE booktype
(
	booktypeno VARCHAR(10)  NOT NULL ,
	typename VARCHAR(20)  NULL ,
	keyword VARCHAR(20)  NULL ,
	memo VARCHAR(200)  NULL ,
	CONSTRAINT booktype_booktypeno_PK PRIMARY KEY (booktypeno)
)

/*1.3.5  创建书籍信息表books*/
CREATE TABLE books
(
	bookid VARCHAR(14)  NOT NULL ,
	bookname VARCHAR(40)  NOT NULL ,
	booktype VARCHAR(20)   NULL ,
	bookauthor VARCHAR(20)  NULL ,
	bookpub VARCHAR(20)  NULL ,
	bookpubdate datetime NULL ,
	bookpages numeric(5, 0) NULL ,
	bookkeyword VARCHAR(10)  NULL ,
	bookindate datetime NULL ,
	putup VARCHAR(10)  NULL ,
	bookmemo VARCHAR(200)  NULL,
	CONSTRAINT books_bookid_PK PRIMARY KEY (bookid)
)

/*1.3.6  创建借阅信息表borrowinfo*/
CREATE TABLE borrowinfo
(
	borrowno VARCHAR(14)  NOT NULL ,
	readerid VARCHAR(10)  NULL,
	readername VARCHAR(20)  NULL ,
	bookid VARCHAR(14)  NULL ,
	bookname VARCHAR(40)  NULL ,
	borrowdate datetime NULL ,
	returndate datetime NULL ,
	memo VARCHAR(200)  NULL ,
	CONSTRAINT borrowinfo_borrowno_PK PRIMARY KEY (borrowno)
)