return_claims

0 rows


Columns

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

Unique ID of the return claim

itemnumber INT 10 null
items.itemnumber rc_items_ibfkC

ID of the item

issue_id INT 10 null

ID of the checkout that triggered the claim

borrowernumber INT 10 null
borrowers.borrowernumber rc_borrowers_ibfkC

ID of the patron

notes MEDIUMTEXT 16777215 null

Notes about the claim

created_on TIMESTAMP 19 null

Time and date the claim was created

created_by INT 10 null
borrowers.borrowernumber rc_created_by_ibfkN

ID of the staff member that registered the claim

updated_on TIMESTAMP 19 null

Time and date of the latest change on the claim (notes)

updated_by INT 10 null
borrowers.borrowernumber rc_updated_by_ibfkN

ID of the staff member that updated the claim

resolution VARCHAR 80 null

Resolution code (RETURN_CLAIM_RESOLUTION AVs)

resolved_on TIMESTAMP 19 null

Time and date the claim was resolved

resolved_by INT 10 null
borrowers.borrowernumber rc_resolved_by_ibfkN

ID of the staff member that resolved the claim

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
item_issue Must be unique Asc/Asc itemnumber + issue_id
itemnumber Performance Asc itemnumber
rc_borrowers_ibfk Performance Asc borrowernumber
rc_created_by_ibfk Performance Asc created_by
rc_resolved_by_ibfk Performance Asc resolved_by
rc_updated_by_ibfk Performance Asc updated_by

Relationships