club_enrollments - testsql_comments.testsql

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 8 of 8 entries

Indexes

Search:

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

Showing 1 to 4 of 4 entries

Relationships

Close relationships within degrees of separation

One
Two degrees