Commit | Line | Data |
eaaa8f8a |
1 | create table pet ( |
2 | "pet_id" int, |
3 | "person_id" int |
4 | constraint fk_person_id references person(person_id), |
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 | ); |