school
.school
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
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
One