---

create database prim;
use prim;

create table clients(
	id int primary key auto_increment,
    surname varchar(20),
    mail varchar(30));

create table categories (
	id int primary key auto_increment,
    title varchar(20));

create table breeds (
	id int primary key auto_increment,
    title varchar(30),
    id_category int,
    foreign key (id_category) references categories (id));
    
create table animals (
	id int primary key auto_increment,
    name varchar(30),
    color varchar(30),
    id_breed int,
    birthday date,
    price decimal(10,2),
    foreign key (id_breed) references breeds (id));
    
create table ceils (
	id int primary key auto_increment,
    id_client int,
    status varchar(20),
    date_ceil date,
    foreign key (id_client) references clients(id));
    
create table sostav_ceil (
	id_ceil int,
    id_animal int,
	primary key (id_ceil, id_animal),
    foreign key (id_ceil) references ceils(id),
    foreign key (id_animal) references animals(id));