biblionumber |
int |
10 |
|
|
0 |
|
|
subscriptionid |
int |
10 |
|
√ |
|
|
|
librarian |
varchar |
100 |
√ |
|
|
|
|
startdate |
date |
10 |
√ |
|
null |
|
|
aqbooksellerid |
int |
10 |
√ |
|
0 |
|
|
cost |
int |
10 |
√ |
|
0 |
|
|
aqbudgetid |
int |
10 |
√ |
|
0 |
|
|
weeklength |
int |
10 |
√ |
|
0 |
|
|
monthlength |
int |
10 |
√ |
|
0 |
|
|
numberlength |
int |
10 |
√ |
|
0 |
|
|
periodicity |
int |
10 |
√ |
|
null |
|
|
countissuesperunit |
int |
10 |
|
|
1 |
|
|
notes |
mediumtext |
16777215 |
√ |
|
null |
|
|
status |
varchar |
100 |
|
|
|
|
|
lastvalue1 |
int |
10 |
√ |
|
null |
|
|
innerloop1 |
int |
10 |
√ |
|
0 |
|
|
lastvalue2 |
int |
10 |
√ |
|
null |
|
|
innerloop2 |
int |
10 |
√ |
|
0 |
|
|
lastvalue3 |
int |
10 |
√ |
|
null |
|
|
innerloop3 |
int |
10 |
√ |
|
0 |
|
|
firstacquidate |
date |
10 |
√ |
|
null |
|
|
manualhistory |
bit |
0 |
|
|
0 |
|
|
irregularity |
text |
65535 |
√ |
|
null |
|
|
skip_serialseq |
bit |
0 |
|
|
0 |
|
|
letter |
varchar |
20 |
√ |
|
null |
|
|
numberpattern |
int |
10 |
√ |
|
null |
|
|
locale |
varchar |
80 |
√ |
|
null |
|
|
distributedto |
text |
65535 |
√ |
|
null |
|
|
internalnotes |
longtext |
2147483647 |
√ |
|
null |
|
|
callnumber |
text |
65535 |
√ |
|
null |
|
|
location |
varchar |
80 |
√ |
|
|
|
|
branchcode |
varchar |
10 |
|
|
|
|
branches.branchcode
|
Implied Constraint R |
|
lastbranch |
varchar |
10 |
√ |
|
null |
|
|
serialsadditems |
bit |
0 |
|
|
0 |
|
|
staffdisplaycount |
varchar |
10 |
√ |
|
null |
|
|
opacdisplaycount |
varchar |
10 |
√ |
|
null |
|
|
graceperiod |
int |
10 |
|
|
0 |
|
|
enddate |
date |
10 |
√ |
|
null |
|
|
closed |
int |
10 |
|
|
0 |
|
|
reneweddate |
date |
10 |
√ |
|
null |
|
|
itemtype |
varchar |
10 |
√ |
|
null |
|
|
previousitemtype |
varchar |
10 |
√ |
|
null |
|
|