student

2000 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
StudentID INT 10 √ null
grade.StudentID grade_ibfk_1 R
parent.StudentID parent_ibfk_1 R
FirstName VARCHAR 100 √ null
LastName VARCHAR 100 √ null
Gender enum('Male', 'Female', 'Other') 6 √ null
DOB DATE 10 √ null
Class VARCHAR 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc StudentID

Relationships

Close relationships within degrees of separation