---

CREATE DATABASE Hospital;
GO
USE Hospital;
GO
-- Таблица Отделения
CREATE TABLE Departments
(
    Id INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
    Building INT NOT NULL CHECK (Building BETWEEN 1 AND 5),
    Financing MONEY NOT NULL CHECK (Financing >= 0),
    Name NVARCHAR(100) NOT NULL UNIQUE CHECK (Name <> '')
);
GO
-- Таблица Заболевания
CREATE TABLE Diseases
(
    Id INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
    Name NVARCHAR(100) NOT NULL UNIQUE CHECK (Name <> ''),
    Severity INT NOT NULL CHECK (Severity >= 1)
);
GO
-- Таблица Врачи
CREATE TABLE Doctors
(
    Id INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
    Name NVARCHAR(100) NOT NULL CHECK (Name <> ''),
    Phone NVARCHAR(20) NULL,
    Salary MONEY NOT NULL CHECK (Salary > 0),
    Surname NVARCHAR(100) NOT NULL CHECK (Surname <> '')
);
GO
-- Таблица Обследования
CREATE TABLE Examinations
(
    Id INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
    DayOfWeek INT NOT NULL CHECK (DayOfWeek BETWEEN 1 AND 7),
    EndTime TIME NOT NULL,
    Name NVARCHAR(100) NOT NULL UNIQUE CHECK (Name <> ''),
    StartTime TIME NOT NULL CHECK (StartTime BETWEEN '08:00:00' AND '18:00:00'),
    CHECK (EndTime > StartTime)
);
GO