Commit | Line | Data |
---|---|---|
eaaa8f8a | 1 | create table pet ( |
2 | "pet_id" int, | |
3 | "person_id" int | |
ea4a3ecc | 4 | constraint fk_person_id references person(person_id) on update CASCADE on delete RESTRICT, |
eaaa8f8a | 5 | "name" varchar(30), |
6 | "age" int, | |
7 | constraint age_under_100 check ( age < 100 ), | |
8 | constraint pk_pet primary key (pet_id, person_id) | |
9 | ); |