Базы данных SQL-DDL и SQL-DML. Изучение транзакций. Программирование на языке SQL. Консольное приложение (Цикл лабораторных работ). Вариант № 1, страница 11

INSERT INTO MEDICS (ID, NAME, PROFESSION_ID) VALUES (3, 'Крапов Т.Е.', 3);

INSERT INTO MEDICS (ID, NAME, PROFESSION_ID) VALUES (6, 'Анюков К.З.', 4);

INSERT INTO MEDICS (ID, NAME, PROFESSION_ID) VALUES (7, 'Петрачков У.К.', 5);

INSERT INTO MEDICS (ID, NAME, PROFESSION_ID) VALUES (8, 'Васюкова Т.К.', 6);

COMMIT WORK;

INSERT INTO MEDICAL_NOTES (ID, TEXT, AUTHOR_ID, PERSON_ID, DT_NOTE) VALUES (1, 'Зрение -2 и косит на левый глаз', 1, 3, '2011-06-01 00:00:00');

INSERT INTO MEDICAL_NOTES (ID, TEXT, AUTHOR_ID, PERSON_ID, DT_NOTE) VALUES (2, 'Сломана правая нога, плохо бегает', 2, 3, '2011-06-01 00:00:00');

INSERT INTO MEDICAL_NOTES (ID, TEXT, AUTHOR_ID, PERSON_ID, DT_NOTE) VALUES (3, 'Чесоточные образования на левой пятке', 3, 3, '2011-06-01 00:00:00');

INSERT INTO MEDICAL_NOTES (ID, TEXT, AUTHOR_ID, PERSON_ID, DT_NOTE) VALUES (4, 'Горло распухло до 30 сантиметров в диаметре', 6, 5, '2011-06-01 00:00:00');

INSERT INTO MEDICAL_NOTES (ID, TEXT, AUTHOR_ID, PERSON_ID, DT_NOTE) VALUES (5, 'Нервничает, просится к маме и грозится описаться', 7, 5, '2011-06-01 00:00:00');

INSERT INTO MEDICAL_NOTES (ID, TEXT, AUTHOR_ID, PERSON_ID, DT_NOTE) VALUES (6, 'Не идёт на контакт', 8, 7, '2011-06-01 00:00:00');

COMMIT WORK;

INSERT INTO STATUS (ID, DESCRIPTION) VALUES (0, 'Не обследован');

INSERT INTO STATUS (ID, DESCRIPTION) VALUES (1, 'Не годен');

INSERT INTO STATUS (ID, DESCRIPTION) VALUES (2, 'Условно годен');

INSERT INTO STATUS (ID, DESCRIPTION) VALUES (3, 'Годен');

COMMIT WORK;

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (2, 1, '2011-08-10 14:12:57');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (2, 2, '2011-09-02 16:42:06');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (2, 3, '2011-09-18 00:43:20');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (2, 5, '2011-01-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (1, 6, '2011-01-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (1, 7, '2011-01-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (3, 8, '2011-01-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (3, 9, '2011-01-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (3, 10, '2011-01-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (1, 11, '2011-01-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (3, 12, '2011-01-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (3, 13, '2011-01-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (3, 14, '2011-01-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (1, 15, '2011-01-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (1, 16, '2011-01-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (1, 17, '2011-01-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (2, 18, '2011-01-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (3, 19, '2011-01-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (2, 20, '2011-01-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (3, 21, '2011-02-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (2, 22, '2011-01-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (1, 23, '2011-01-01 00:00:00');