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_1 C
club_id INT 10 null
clubs.id club_enrollments_ibfk_1 C
borrowernumber INT 10 null
borrowers.borrowernumber club_enrollments_ibfk_2 C
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_3 N

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

Close relationships within degrees of separation