club_enrollments

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
club_enrollment_fields.club_enrollment_id club_enrollment_fields_ibfk_1C
club_id INT 10 null
clubs.id club_enrollments_ibfk_1C
borrowernumber INT 10 null
borrowers.borrowernumber club_enrollments_ibfk_2C
date_enrolled TIMESTAMP 19 CURRENT_TIMESTAMP
date_canceled TIMESTAMP 19 null
date_created TIMESTAMP 19 null
date_updated TIMESTAMP 19 null
branchcode VARCHAR 10 null
branches.branchcode club_enrollments_ibfk_3N

Indexes

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

Relationships