AtcuMFaW

1create database if not exists pet_db;
2
3use pet_db;
4
5drop table if exists pets;
6
7create table pets (
8    pet_id int not null auto_increment,
9    pet_type_id int not null,
10    pet_breed_id int not null,
11    pet_name varchar(30) not null,
12    primary key (pet_id)
13);
14
15create table pet_types (
16    pet_type_id int not null auto_increment,
17    pet_breed_id int not null,
18    pet_type_name varchar(30) not null,
19    primary key (pet_type_id)
20);
21
22create table breeds (
23    pet_breed_id int(11) not null auto_increment,
24    pet_type_id int(11) not null,
25    pet_breed_name varchar(30),
26    pet_min_lifespan int,
27    pet_max_lifespan int,
28    primary key (pet_breed_id),
29    foreign key (pet_breed_id) references pet_types(pet_breed_id)
30);
31
32create table traits (
33    pet_trait_id int not null auto_increment,
34    pet_trait_type int not null,
35    pet_trait_name varchar(30),
36    primary key (pet_trait_id),
37    foreign key (pet_trait_type) references pet_types(pet_type_id)
38);
39