checkout_renewals

0 rows


Columns

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

the id of the checkout this renewal pertains to

renewer_id INT 10 null
borrowers.borrowernumber renewals_renewer_idN

the id of the user who processed the renewal

seen BIT 0 0

boolean denoting whether the item was present or not

interface VARCHAR 16 null

the interface this renewal took place on

timestamp TIMESTAMP 19 current_timestamp()

the date and time the renewal took place

renewal_type enum('Automatic', 'Manual') 10 Manual

whether the renewal was an automatic or manual renewal

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc renewal_id
renewer_id Performance Asc renewer_id

Relationships