db/firebird/02_seed.sql - master - evernotenkai/DataBaseXJavaProject

db/firebird/02_seed.sql
137 строк7 KB
Makson4ik
Весь проект с src db и прочим делом
12 май 2026, 22:43
12 май 2026, 22:43431f4aa
INSERT INTO teachers (full_name, department, email, phone)
VALUES ('Иванов Иван Иванович', 'Кафедра информатики', 'ivanov@uni.ru', '+79000000001');

INSERT INTO teachers (full_name, department, email, phone)
VALUES ('Петров Петр Сергеевич', 'Кафедра математики', 'petrov@uni.ru', '+79000000002');

INSERT INTO teachers (full_name, department, email, phone)
VALUES ('Сидорова Анна Викторовна', 'Кафедра программной инженерии', 'sidorova@uni.ru', '+79000000003');

INSERT INTO teachers (full_name, department, email, phone)
VALUES ('Кузнецов Дмитрий Олегович', 'Кафедра информационных систем', 'kuznetsov@uni.ru', '+79000000004');

INSERT INTO teachers (full_name, department, email, phone)
VALUES ('Смирнова Елена Павловна', 'Кафедра баз данных', 'smirnova@uni.ru', '+79000000005');

INSERT INTO students (full_name, group_name, email, phone)
VALUES ('Алексеев Артем Николаевич', 'ИС-21', 'alekseev@student.ru', '+78000000001');

INSERT INTO students (full_name, group_name, email, phone)
VALUES ('Борисова Мария Игоревна', 'ИС-21', 'borisova@student.ru', '+78000000002');

INSERT INTO students (full_name, group_name, email, phone)
VALUES ('Волков Кирилл Андреевич', 'ПИ-22', 'volkov@student.ru', '+78000000003');

INSERT INTO students (full_name, group_name, email, phone)
VALUES ('Громова София Денисовна', 'ПИ-22', 'gromova@student.ru', '+78000000004');

INSERT INTO students (full_name, group_name, email, phone)
VALUES ('Данилов Максим Евгеньевич', 'БД-23', 'danilov@student.ru', '+78000000005');

INSERT INTO users (login, password, role, teacher_id, student_id)
VALUES ('admin', '1234', 'admin', NULL, NULL);

INSERT INTO users (login, password, role, teacher_id, student_id)
VALUES ('ivanov', '1234', 'teacher', 1, NULL);

INSERT INTO users (login, password, role, teacher_id, student_id)
VALUES ('petrov', '1234', 'teacher', 2, NULL);

INSERT INTO users (login, password, role, teacher_id, student_id)
VALUES ('sidorova', '1234', 'teacher', 3, NULL);

INSERT INTO users (login, password, role, teacher_id, student_id)
VALUES ('kuznetsov', '1234', 'teacher', 4, NULL);

INSERT INTO users (login, password, role, teacher_id, student_id)
VALUES ('smirnova', '1234', 'teacher', 5, NULL);

INSERT INTO users (login, password, role, teacher_id, student_id)
VALUES ('student1', '1234', 'student', NULL, 1);

INSERT INTO users (login, password, role, teacher_id, student_id)
VALUES ('student2', '1234', 'student', NULL, 2);

INSERT INTO users (login, password, role, teacher_id, student_id)
VALUES ('student3', '1234', 'student', NULL, 3);

INSERT INTO users (login, password, role, teacher_id, student_id)
VALUES ('student4', '1234', 'student', NULL, 4);

INSERT INTO users (login, password, role, teacher_id, student_id)
VALUES ('student5', '1234', 'student', NULL, 5);

INSERT INTO courses (course_name, description, teacher_id)
VALUES ('Базы данных', 'Проектирование баз данных и SQL', 1);

INSERT INTO courses (course_name, description, teacher_id)
VALUES ('ООП на Java', 'Основы объектно-ориентированного программирования', 3);

INSERT INTO courses (course_name, description, teacher_id)
VALUES ('Высшая математика', 'Математический анализ и линейная алгебра', 2);

INSERT INTO courses (course_name, description, teacher_id)
VALUES ('Информационные системы', 'Модели, процессы, внедрение', 4);

INSERT INTO courses (course_name, description, teacher_id)
VALUES ('Алгоритмы и структуры данных', 'Списки, деревья, сортировки', 5);

INSERT INTO enrollments (student_id, course_id, enrollment_date)
VALUES (1, 1, DATE '2026-02-01');

INSERT INTO enrollments (student_id, course_id, enrollment_date)
VALUES (2, 1, DATE '2026-02-01');

INSERT INTO enrollments (student_id, course_id, enrollment_date)
VALUES (3, 2, DATE '2026-02-02');

INSERT INTO enrollments (student_id, course_id, enrollment_date)
VALUES (4, 4, DATE '2026-02-02');

INSERT INTO enrollments (student_id, course_id, enrollment_date)
VALUES (5, 5, DATE '2026-02-03');

INSERT INTO assignments (course_id, title, description, due_date, created_at)
VALUES (1, 'ЛР 1: ER-диаграмма', 'Спроектировать ER-модель предметной области', DATE '2026-03-10', DATE '2026-02-20');

INSERT INTO assignments (course_id, title, description, due_date, created_at)
VALUES (1, 'ЛР 2: SQL', 'Создать таблицы и ограничения базы данных', DATE '2026-03-20', DATE '2026-02-25');

INSERT INTO assignments (course_id, title, description, due_date, created_at)
VALUES (2, 'Практика 1', 'Реализовать базовые классы на Java', DATE '2026-03-15', DATE '2026-02-22');

INSERT INTO assignments (course_id, title, description, due_date, created_at)
VALUES (4, 'Кейс 1', 'Описать бизнес-процесс и UML', DATE '2026-03-18', DATE '2026-02-24');

INSERT INTO assignments (course_id, title, description, due_date, created_at)
VALUES (5, 'Домашнее задание 1', 'Реализовать сортировки и поиск', DATE '2026-03-19', DATE '2026-02-26');

INSERT INTO submissions (assignment_id, student_id, submission_date, content_note, status)
VALUES (1, 1, DATE '2026-03-05', 'ER-диаграмма готова', 'checked');

INSERT INTO submissions (assignment_id, student_id, submission_date, content_note, status)
VALUES (2, 2, DATE '2026-03-06', 'SQL-скрипт создания таблиц', 'checked');

INSERT INTO submissions (assignment_id, student_id, submission_date, content_note, status)
VALUES (3, 3, DATE '2026-03-10', 'Код на Java', 'submitted');

INSERT INTO submissions (assignment_id, student_id, submission_date, content_note, status)
VALUES (4, 4, DATE '2026-03-12', 'UML и описание кейса', 'returned');

INSERT INTO submissions (assignment_id, student_id, submission_date, content_note, status)
VALUES (5, 5, DATE '2026-03-13', 'Сортировки и поиск', 'checked');

INSERT INTO grades (submission_id, grade_value, teacher_comment, graded_date)
VALUES (1, 85, 'Хорошая работа', DATE '2026-03-07');

INSERT INTO grades (submission_id, grade_value, teacher_comment, graded_date)
VALUES (2, 92, 'Отлично', DATE '2026-03-08');

INSERT INTO grades (submission_id, grade_value, teacher_comment, graded_date)
VALUES (3, 78, 'Можно лучше', DATE '2026-03-12');

INSERT INTO grades (submission_id, grade_value, teacher_comment, graded_date)
VALUES (4, 69, 'На доработку', DATE '2026-03-13');

INSERT INTO grades (submission_id, grade_value, teacher_comment, graded_date)
VALUES (5, 88, 'Скрипт выполнен корректно', DATE '2026-03-14');