---

-- Таблица "Специальности" (Specialties)[span_0](start_span)[span_0](end_span)
CREATE TABLE Specialties (
    SpecialtyID INT PRIMARY KEY,
    Title VARCHAR(50) NOT NULL,
    Vacancies INT NOT NULL
);

-- Таблица "Абитуриенты" (Applicants)[span_1](start_span)[span_1](end_span)
CREATE TABLE Applicants (
    ApplicantID INT PRIMARY KEY,
    LastName VARCHAR(30) NOT NULL,
    FirstName VARCHAR(20) NOT NULL,
    MiddleName VARCHAR(20) NOT NULL,
    Status VARCHAR(20) NULL,
    City VARCHAR(30) NOT NULL
);

-- Таблица "Заявления" (Applications)[span_2](start_span)[span_2](end_span)
CREATE TABLE Applications (
    ApplicationID INT PRIMARY KEY,
    ApplicantID INT NOT NULL,
    SpecialtyID INT NOT NULL,
    Status VARCHAR(20) NULL,
    FOREIGN KEY (ApplicantID) REFERENCES Applicants(ApplicantID),
    FOREIGN KEY (SpecialtyID) REFERENCES Specialties(SpecialtyID)
);

-- Таблица "Оценки" (Grades)[span_3](start_span)[span_3](end_span)
CREATE TABLE Grades (
    GradeID INT PRIMARY KEY,
    ApplicantID INT NOT NULL,
    ExamID INT NOT NULL,
    Grade INT NULL,
    FOREIGN KEY (ApplicantID) REFERENCES Applicants(ApplicantID)
);

-- Таблица "Журнал" (Log)[span_4](start_span)[span_4](end_span)
CREATE TABLE Log (
    EventID INT PRIMARY KEY,
    Description VARCHAR(100) NOT NULL,
    Date DATE NOT NULL
);