Бази даних
information_schema
mysql
performance_schema
phpmyadmin
school
test

Структура таблиць бази даних school

classroom
('building', 'varchar(15)', 'NO', 'PRI', None, '')
('room_number', 'varchar(3)', 'NO', 'PRI', None, '')
('capacity', 'tinyint(3) unsigned', 'YES', '', None, '')

courses
('title', 'varchar(15)', 'NO', 'PRI', None, '')
('form', 'char(3)', 'NO', 'PRI', None, '')
('no', 'varchar(9)', 'YES', 'MUL', None, '')
('hours', 'smallint(5) unsigned', 'YES', '', None, '')
('dept_name', 'varchar(15)', 'YES', '', None, '')

department
('dept_name', 'varchar(20)', 'NO', 'PRI', None, '')
('persons', 'tinyint(3) unsigned', 'YES', '', None, '')

marks
('course', 'varchar(15)', 'NO', 'PRI', None, '')
('form', 'varchar(3)', 'NO', 'PRI', None, '')
('sename', 'varchar(15)', 'NO', 'PRI', None, '')
('name', 'varchar(15)', 'NO', 'PRI', None, '')
('day', 'date', 'NO', 'PRI', None, '')
('mark', 'tinyint(3) unsigned', 'YES', '', None, '')
('type', "enum('контрольна','самостійна','усна','домашня')", 'NO', 'PRI', None, '')

pupils
('sename', 'varchar(15)', 'YES', '', None, '')
('name', 'varchar(15)', 'YES', '', None, '')
('form', 'varchar(3)', 'YES', '', None, '')
('no', 'varchar(9)', 'NO', 'PRI', None, '')

teachers
('sename', 'varchar(15)', 'YES', '', None, '')
('name', 'varchar(15)', 'YES', '', None, '')
('quality', 'varchar(20)', 'YES', '', None, '')
('no', 'varchar(9)', 'NO', 'PRI', None, '')