sport

199 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
createdOn DATETIME 19 current_timestamp()
modifiedOn DATETIME 19 current_timestamp()
coachName VARCHAR 30 √ NULL
coachEmail VARCHAR 30 √ NULL
positionId BIGINT 19 √ NULL
sportPosition.id sport_positionId_sportPosition_id_fk R
sportTypeId BIGINT 19 null
sportType.id sport_sportTypeId_sportType_id_fk R
school VARCHAR 80 √ NULL
userId BIGINT 19 null
user.id sport_userId_user_id_fk R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
sport_positionId_sportPosition_id_fk Performance Asc positionId
sport_sportTypeId_index Performance Asc sportTypeId
sport_userId_index Performance Asc userId

Relationships

Close relationships within degrees of separation