---

CREATE TABLE Breeds (
    BreedID INT PRIMARY KEY,
    BreedName VARCHAR(100) NOT NULL
);

CREATE TABLE Owners (
    OwnerID INT PRIMARY KEY,
    FullName VARCHAR(100) NOT NULL,
    Phone VARCHAR(20)
);

CREATE TABLE Animals (
    AnimalID INT PRIMARY KEY,
    Name VARCHAR(100) NOT NULL,
    BirthDate DATE,
    BreedID INT,
    OwnerID INT,
    FatherID INT NULL,
    MotherID INT NULL,

    FOREIGN KEY (BreedID) REFERENCES Breeds(BreedID),
    FOREIGN KEY (OwnerID) REFERENCES Owners(OwnerID),
    FOREIGN KEY (FatherID) REFERENCES Animals(AnimalID),
    FOREIGN KEY (MotherID) REFERENCES Animals(AnimalID)
);

CREATE TABLE Doctors (
    DoctorID INT PRIMARY KEY,
    FullName VARCHAR(100) NOT NULL,
    Specialization VARCHAR(100)
);

CREATE TABLE Certificates (
    CertificateID INT PRIMARY KEY,
    DoctorID INT NOT NULL,
    CertificateName VARCHAR(100) NOT NULL,

    FOREIGN KEY (DoctorID) REFERENCES Doctors(DoctorID)
);

CREATE TABLE Services (
    ServiceID INT PRIMARY KEY,
    ServiceName VARCHAR(100) NOT NULL,
    Price DECIMAL(10,2) NOT NULL
);

CREATE TABLE Visits (
    VisitID INT PRIMARY KEY,
    AnimalID INT NOT NULL,
    DoctorID INT NOT NULL,
    ServiceID INT NOT NULL,
    VisitDate DATE NOT NULL,

    FOREIGN KEY (AnimalID) REFERENCES Animals(AnimalID),
    FOREIGN KEY (DoctorID) REFERENCES Doctors(DoctorID),
    FOREIGN KEY (ServiceID) REFERENCES Services(ServiceID)
);