실습1
테이블 (5)
PetOwners
- ownerID — int — 기본 키 — NOT NULL
- name — varchar
- contact — varchar
Pets
- petID — int — 기본 키 — NOT NULL
- ownerID — int — 외래 키 → PetOwners.ownerID — NOT NULL
- name — varchar
- species — varchar
- breed — varchar
Reservations
- reservationID — int — 기본 키 — NOT NULL
- petID — int — 외래 키 → Pets.petID — NOT NULL
- roomID — int — 외래 키 → Rooms.roomID — NOT NULL
- startDate — datetime
- endDate — datetime
Rooms
- roomID — int — 기본 키 — NOT NULL
- roomNumber — smallint
- roomType — varchar
- pricePerNight
Services
- serviceID — int — 기본 키 — NOT NULL
- reservationID — int — 외래 키 → Reservations.reservationID — NOT NULL
- serviceName — varchar
- servicePrice — int