labrary.pdm

本系统是用PB+SQL做的一个图书管理系统

/BEGIN_TABLE AMCHEAD
NAME A30
VERS A8
USER A30
/BEGIN_DATA AMCHEAD
PowerDesigner/PDM
6.0.0

/END_TABLE AMCHEAD

/BEGIN_TABLE AMCMODL
@       N5
OID     N8
MODL    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
OPTS    TXT
EXOP    TXT
DBMS    A256
FILE    A256
HEAD    TXT
FOOT    TXT
POID    N8
PNAM    A80
PCOD    A80
USER    A80
VERS    A8
CDAT    N12
MDAT    N12
EDAT    N12
PART    N1
ACCS    N5
CUST    TXT
/BEGIN_DATA AMCMODL
3
9
9
图书管理系统
LABRARY





Sybase SQL Anywhere
SQLANY5.DEF


0
图书管理系统
LABRARY
胡开英
V1.0
1180651595
1181141888
0
0
0

/END_TABLE AMCMODL

/BEGIN_TABLE AMCDOMN
@       N5
OID     N8
DOMN    N8
NAME    A80
CODE    A80
DESC    TXT
NOTE    TXT
LABL    A254
DTTP    A30
MLEN    N8
PREC    N2
IDNT    N1
WDEF    N1
MAND    N1
UNIT    A8
FRMT    A20
LVAL    A20
HVAL    A20
DVAL    A30
UPPR    N1
LOWR    N1
NMDF    N1
VALS    TXT
CRUL    TXT
SRUL    TXT
SOID    N8
/BEGIN_DATA AMCDOMN
/END_TABLE AMCDOMN

/BEGIN_TABLE AMCTABL
@       N5
OID     N8
TABL    N8
MODL    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
NBRC    N8
SOID    N8
TOBJ    N5
COBJ    A80
OPTS    TXT
PKOP    TXT
CRUL    TXT
SRUL    TXT
PKCN    A30
CKCN    A30
HEAD    TXT
FOOT    TXT
NGEN    N1
/BEGIN_DATA AMCTABL
3
1
1
9
图书信息
BOOK_INFO



2000
17
4
BOOK_INFO








0
3
11
11
9
会员信息
MEMBER



1000
27
4
MEMBER








0
3
87
87
9
借阅
LEND



0
42
7
LEND








0
3
264
264
9
还书
RETURN_BOOK



0
48
7
RETURN_BOOK








0
3
420
420
9
管理员
ADMIN



0
0
0
ADMIN








0
/END_TABLE AMCTABL

/BEGIN_TABLE AMCCOLN
@       N5
OID     N8
COLN    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
TABL    N8
DOMN    N8
DTTP    A30
MLEN    N8
PREC    N2
IDNT    N1
WDEF    N1
UNIT    A8
FRMT    A20
LVAL    A20
HVAL    A20
DVAL    A30
UPPR    N1
LOWR    N1
NMDF    N1
VALS    TXT
CRUL    TXT
SRUL    TXT
PRIM    N1
FORN    N1
MAND    N1
DISP    N1
SOID    N8
TOBJ    N5
COBJ    A80
CKCN    A30
NUMR    N8
/BEGIN_DATA AMCCOLN
3
2
2
图书编号
BOO_CODE



1
0
varchar(5)
5
0
0
0





0
0
0



1
0
1
1
23
8
BOO_CODE

1
3
4
4
书名
BOOK_NAME



1
0
varchar(50)
50
0
0
0





0
0
0



0
0
1
1
22
8
BOOK_NAME

2
3
10
10
作者
AUTHOR



1
0
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
26
8
AUTHOR

3
3
6
6
出版社
PUBLISH



1
0
varchar(50)
50
0
0
0





0
0
0



0
0
0
1
19
8
PUBLISH

4
3
5
5
出版日期
PUBLISH_DATE



1
0
date
0
0
0
0





0
0
0



0
0
0
1
18