2 person_id INTEGER PRIMARY KEY,
3 name varchar(20) not null,
6 iq tinyint default '0',
10 create unique index u_name on person (name);
14 person_id int references person (person_id),
18 primary key (pet_id, person_id)
21 create trigger pet_trig after insert on pet
23 update pet set name=name;
27 create view person_pet as
28 select pr.person_id, pr.name as person_name, pt.name as pet_name
29 from person pr, pet pt
30 where person.person_id=pet.pet_id