2 person_id INTEGER PRIMARY KEY,
3 name varchar(20) not null,
7 is_rock_star tinyint default '1',
11 create unique index u_name on person (name);
19 primary key (pet_id, person_id)
22 create trigger after insert on pet
24 update pet set name=name;
28 create view person_pet as
29 select pr.person_id, pr.name as person_name, pt.name as pet_name
30 from person pr, pet pt
31 where person.person_id=pet.pet_id