information_schema
mysql
performance_schema
phpmyadmin
school
test

classroom
{"Field"=>"building", "Type"=>"varchar(15)", "Null"=>"NO", "Key"=>"PRI", "Default"=>nil, "Extra"=>""}
{"Field"=>"room_number", "Type"=>"varchar(3)", "Null"=>"NO", "Key"=>"PRI", "Default"=>nil, "Extra"=>""}
{"Field"=>"capacity", "Type"=>"tinyint(3) unsigned", "Null"=>"YES", "Key"=>"", "Default"=>nil, "Extra"=>""}

courses
{"Field"=>"title", "Type"=>"varchar(15)", "Null"=>"NO", "Key"=>"PRI", "Default"=>nil, "Extra"=>""}
{"Field"=>"form", "Type"=>"char(3)", "Null"=>"NO", "Key"=>"PRI", "Default"=>nil, "Extra"=>""}
{"Field"=>"no", "Type"=>"varchar(9)", "Null"=>"YES", "Key"=>"MUL", "Default"=>nil, "Extra"=>""}
{"Field"=>"hours", "Type"=>"smallint(5) unsigned", "Null"=>"YES", "Key"=>"", "Default"=>nil, "Extra"=>""}
{"Field"=>"dept_name", "Type"=>"varchar(15)", "Null"=>"YES", "Key"=>"", "Default"=>nil, "Extra"=>""}

department
{"Field"=>"dept_name", "Type"=>"varchar(20)", "Null"=>"NO", "Key"=>"PRI", "Default"=>nil, "Extra"=>""}
{"Field"=>"persons", "Type"=>"tinyint(3) unsigned", "Null"=>"YES", "Key"=>"", "Default"=>nil, "Extra"=>""}

marks
{"Field"=>"course", "Type"=>"varchar(15)", "Null"=>"NO", "Key"=>"PRI", "Default"=>nil, "Extra"=>""}
{"Field"=>"form", "Type"=>"varchar(3)", "Null"=>"NO", "Key"=>"PRI", "Default"=>nil, "Extra"=>""}
{"Field"=>"sename", "Type"=>"varchar(15)", "Null"=>"NO", "Key"=>"PRI", "Default"=>nil, "Extra"=>""}
{"Field"=>"name", "Type"=>"varchar(15)", "Null"=>"NO", "Key"=>"PRI", "Default"=>nil, "Extra"=>""}
{"Field"=>"day", "Type"=>"date", "Null"=>"NO", "Key"=>"PRI", "Default"=>nil, "Extra"=>""}
{"Field"=>"mark", "Type"=>"tinyint(3) unsigned", "Null"=>"YES", "Key"=>"", "Default"=>nil, "Extra"=>""}
{"Field"=>"type", "Type"=>"enum('контрольна','самостійна','усна','домашня')", "Null"=>"NO", "Key"=>"PRI", "Default"=>nil, "Extra"=>""}

pupils
{"Field"=>"sename", "Type"=>"varchar(15)", "Null"=>"YES", "Key"=>"", "Default"=>nil, "Extra"=>""}
{"Field"=>"name", "Type"=>"varchar(15)", "Null"=>"YES", "Key"=>"", "Default"=>nil, "Extra"=>""}
{"Field"=>"form", "Type"=>"varchar(3)", "Null"=>"YES", "Key"=>"", "Default"=>nil, "Extra"=>""}
{"Field"=>"no", "Type"=>"varchar(9)", "Null"=>"NO", "Key"=>"PRI", "Default"=>nil, "Extra"=>""}

teachers
{"Field"=>"sename", "Type"=>"varchar(15)", "Null"=>"YES", "Key"=>"", "Default"=>nil, "Extra"=>""}
{"Field"=>"name", "Type"=>"varchar(15)", "Null"=>"YES", "Key"=>"", "Default"=>nil, "Extra"=>""}
{"Field"=>"quality", "Type"=>"varchar(20)", "Null"=>"YES", "Key"=>"", "Default"=>nil, "Extra"=>""}
{"Field"=>"no", "Type"=>"varchar(9)", "Null"=>"NO", "Key"=>"PRI", "Default"=>nil, "Extra"=>""}