checkins

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
checkin_id INT 10 √ null

primary key
item_id INT 10 null
items.itemnumber checkins_ibfk_1 C

foreign key from the items table defining which item was checked in
user_id INT 10 √ NULL
borrowers.borrowernumber checkins_ibfk_2 N

foreign key from the borrowers table defining which staff member processed the checkin
library_id VARCHAR 10 null
branches.branchcode checkins_ibfk_3 C

foreign key from the branches table defining where the checkin took place
desk_id INT 10 √ NULL
desks.desk_id checkins_ibfk_4 N

foreign key from the desks table defining which desk the checkin took place at
timestamp TIMESTAMP 19 current_timestamp()

date and time the checkin was processed
exempt_fine TINYINT 3 0

whether fines were exempted on this checkin
local_use TINYINT 3 0

whether this checkin was recorded as a local use
checkout_id INT 10 √ NULL
old_issues.issue_id checkins_ibfk_5 N

foreign key from the old_issues table if this checkin returned a checkout
transfer_id INT 10 √ NULL
branchtransfers.branchtransfer_id checkins_ibfk_6 N

foreign key from the branchtransfers table if this checkin triggered a transfer
hold_id INT 10 √ NULL
reserves.reserve_id checkins_ibfk_7 N

foreign key from the reserves table if this checkin filled a hold
recall_id INT 10 √ NULL
recalls.recall_id checkins_ibfk_8 N

foreign key from the recalls table if this checkin filled a recall
restriction_id INT 10 √ NULL
borrower_debarments.borrower_debarment_id checkins_ibfk_9 N

foreign key from the borrower_debarments table if this checkin triggered a restriction
claim_id INT 10 √ NULL
return_claims.id checkins_ibfk_10 N

foreign key from the return_claims table if this checkin resolved a claim
interface VARCHAR 16 √ NULL

the interface this checkin was processed from (intranet, api, sip, cron, commandline)

Indexes

Constraint Name Type Sort Column(s)
checkins_s_pk Primary key Asc checkin_id
checkout_id Performance Asc checkout_id
claim_id Performance Asc claim_id
desk_id Performance Asc desk_id
hold_id Performance Asc hold_id
item_id Performance Asc item_id
library_id Performance Asc library_id
PRIMARY Must be unique Asc checkin_id
recall_id Performance Asc recall_id
restriction_id Performance Asc restriction_id
transfer_id Performance Asc transfer_id
user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation