실습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