clubs

Columns

Related columns Constraint Comments

Search:

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_holds.club_id	clubs_holds_ibfk_1 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

Showing 1 to 9 of 9 entries

Table contained 0 rows

Indexes

Search:

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

Showing 1 to 3 of 3 entries

Relationships

Close relationships within degrees of separation

One
Two degrees