club_templates


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
club_template_enrollment_fields.club_template_id club_template_enrollment_fields_ibfk_1 C
club_template_fields.club_template_id club_template_fields_ibfk_1 C
clubs.club_template_id clubs_ibfk_1 C
name TEXT 65535 null
description MEDIUMTEXT 16777215 √ null
is_enrollable_from_opac BIT 0 0
is_email_required BIT 0 0
branchcode VARCHAR 10 √ null
branches.branchcode club_templates_ibfk_1 C
date_created TIMESTAMP 19 current_timestamp()
date_updated TIMESTAMP 19 √ null
is_deletable BIT 0 1

Table contained 0 rows

Indexes

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

Relationships

Close relationships within degrees of separation