clubs


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
club_enrollments.club_id club_enrollments_ibfk_1 C
club_fields.club_id club_fields_ibfk_4 C
club_template_id INT 10 null
club_templates.id clubs_ibfk_1 C
name TEXT 65535 null
description MEDIUMTEXT 16777215 √ null
date_start DATE 10 √ null
date_end DATE 10 √ null
branchcode VARCHAR 10 √ null
branches.branchcode clubs_ibfk_2 R
date_created TIMESTAMP 19 current_timestamp()
date_updated TIMESTAMP 19 √ null

Table contained 0 rows

Indexes

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

Relationships

Close relationships within degrees of separation