---

-- =============================================
-- 1. EMPLOYEE
-- =============================================

INSERT INTO Employee
(
    employee_id,
    full_name,
    birth_date,
    passport_data,
    address,
    phone,
    email
)
VALUES
(1, 'Ivanov Ivan Sergeevich', '1990-03-15',
 '4500 123456', 'Moscow, Lesnaya St. 10',
 '+7-900-111-11-11', 'ivanov@mail.ru'),

(2, 'Petrov Petr Andreevich', '1988-07-22',
 '4501 234567', 'Tula, Sovetskaya St. 25',
 '+7-900-222-22-22', 'petrov@mail.ru'),

(3, 'Sidorova Anna Viktorovna', '1995-01-09',
 '4502 345678', 'Kaluga, Centralnaya St. 7',
 '+7-900-333-33-33', 'sidorova@mail.ru'),

(4, 'Kuznetsov Alexey Olegovich', '1992-11-30',
 '4503 456789', 'Ryazan, Novaya St. 14',
 '+7-900-444-44-44', 'kuznetsov@mail.ru'),

(5, 'Orlova Maria Dmitrievna', '1997-05-18',
 '4504 567890', 'Voronezh, Molodezhnaya St. 3',
 '+7-900-555-55-55', 'orlova@mail.ru');

GO


-- =============================================
-- 2. EMPLOYER
-- =============================================

INSERT INTO Employer
(
    employer_id,
    name,
    tax_number,
    address,
    phone
)
VALUES
(1, 'Alpha LLC',
 '7701000001',
 'Moscow, Tverskaya St. 1',
 '+7-495-100-00-01'),

(2, 'Beta LLC',
 '7102000002',
 'Tula, Sovetskaya St. 12',
 '+7-4872-200-00-02'),

(3, 'Gamma LLC',
 '4003000003',
 'Kaluga, Kirova St. 8',
 '+7-4842-300-00-03'),

(4, 'Delta LLC',
 '6204000004',
 'Ryazan, Lenina St. 20',
 '+7-4912-400-00-04'),

(5, 'Omega LLC',
 '3605000005',
 'Voronezh, Plekhanovskaya St. 5',
 '+7-473-500-00-05');

GO


-- =============================================
-- 3. EMPLOYMENT BOOK
-- =============================================

INSERT INTO Employment_Book
(
    employment_book_id,
    book_number,
    issue_date,
    closing_date,
    status,
    format
)
VALUES
(1, 'EB-000001',
 '2016-06-10',
 NULL,
 'Active',
 'Paper'),

(2, 'EB-000002',
 '2018-04-20',
 NULL,
 'Active',
 'Electronic'),

(3, 'EB-000003',
 '2020-09-01',
 NULL,
 'Active',
 'Electronic'),

(4, 'EB-000004',
 '2017-12-05',
 '2024-11-30',
 'Closed',
 'Paper'),

(5, 'EB-000005',
 '2022-03-14',
 NULL,
 'Active',
 'Electronic');

GO


-- =============================================
-- 4. SPECIALIST
-- =============================================

INSERT INTO Specialist
(
    specialist_id,
    full_name,
    position,
    phone,
    email,
    employer_id
)
VALUES
(1, 'Smirnova Elena Viktorovna',
 'HR Specialist',
 '+7-901-100-10-01',
 'smirnova@alpha.ru',
 1),

(2, 'Volkova Olga Sergeevna',
 'HR Inspector',
 '+7-901-200-20-02',
 'volkova@beta.ru',
 2),

(3, 'Popova Natalia Igorevna',
 'Head of HR Department',
 '+7-901-300-30-03',
 'popova@gamma.ru',
 3),

(4, 'Morozova Irina Pavlovna',
 'HR Specialist',
 '+7-901-400-40-04',
 'morozova@delta.ru',
 4),

(5, 'Vasilieva Tatiana Andreevna',
 'HR Inspector',
 '+7-901-500-50-05',
 'vasilieva@omega.ru',
 5);

GO


-- =============================================
-- 5. EMPLOYMENT RECORD
-- =============================================

INSERT INTO Employment_Record
(
    record_id,
    record_date,
    record_type,
    position,
    department,
    document_number,
    employment_book_id,
    specialist_id
)
VALUES
(1,
 '2016-06-10',
 'Hiring',
 'Manager',
 'Sales Department',
 'Order No. 101',
 1,
 1),

(2,
 '2021-05-17',
 'Transfer',
 'Senior Manager',
 'Sales Department',
 'Order No. 57',
 2,
 2),

(3,
 '2023-08-15',
 'Hiring',
 'Accountant',
 'Accounting Department',
 'Order No. 120',
 3,
 3),

(4,
 '2024-11-30',
 'Dismissal',
 'Engineer',
 'Technical Department',
 'Order No. 145',
 4,
 4),

(5,
 '2023-10-02',
 'Hiring',
 'HR Specialist',
 'HR Department',
 'Order No. 88',
 5,
 5);

GO