create table addressess(
id int,
house_number int,
city varchar(30),
postcode varchar(20));
CREATE TABLE people (
id INT,
first_name VARCHAR(30),
last_name VARCHAR(30),
address_id INT
);
create table pets(
id int,
name varchar(20),
species varchar(20),
order_id int);
alter table pets add primary key (id);
alter table pets drop primary key;
alter table pets modify id int;
alter table pets add constraint foreign key(order_id) references orders(id);
select * from addressess;
select * from people;
select * from pets;