patron_consent


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
borrowernumber INT 10 null
borrowers.borrowernumber patron_consent_ibfk_1 C
type enum('GDPR_PROCESSING') 16 √ null

allows for future extension
given_on DATETIME 19 √ null
refused_on DATETIME 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
borrowernumber Performance Asc borrowernumber

Relationships

Close relationships within degrees of separation