drop table Person;
drop table Borrower;
drop table Checkout;
drop table idSequence;

create table Person (
   id char(6) not null unique,
   firstName varchar(32) not null,
   lastName varchar(32) not null,
   address varchar(128),
   phoneNumber char(10)
);
create table Borrower (
   id char(6) not null,
   beginDate date not null,
   endDate date,
   borrower_id char(6)
);
create table Checkout (
   id int not null unique,  
   outDate longint not null,
   borrower_id char(6)
);
create table idSequence (
   sequence int
);
insert into idSequence values(1);