동물병원

테이블 (9)

Nurse (nurses)

  • Nurse_Id (nurse_id) — INT(11) — 기본 키 — NOT NULL
  • FirstName (first_name) — VARCHAR(100)
  • LastName (last_name) — VARCHAR(100)
  • Salary (salary) — INT(11)

OperatingRoom (operatingrooms)

  • Room_Id (room_id) — INT(11) — 기본 키 — NOT NULL
  • RoomNumber (room_number) — INT(11)

Owner (owners)

  • Owner_Id (owner_id) — INT(11) — 기본 키 — NOT NULL
  • FirstName (first_name) — VARCHAR(100)
  • LastName (last_name) — VARCHAR(100)
  • Address (address) — VARCHAR(255)
  • City (city) — VARCHAR(100)
  • Telephone (telephone) — VARCHAR(100)

Pet (pets)

  • Pet_Id (pet_id) — INT(11) — 기본 키 — NOT NULL
  • Owner_Id (owner_id) — INT(11) — 외래 키 → Owner.Owner_Id — NOT NULL
  • Type_Id (type_id) — INT(11) — 외래 키 → Type.Type_Id — NOT NULL
  • Name (name) — VARCHAR(100)
  • BirthDate (birth_date) — VARCHAR(50)

Speciality (specialities)

  • Speciality_Id (speciality_id) — INT(11) — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(100)

Type (types)

  • Type_Id (type_id) — INT(11) — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(100)

Vet (vets)

  • Vet_Id (vet_id) — INT(11) — 기본 키 — NOT NULL
  • FirstName (first_name) — VARCHAR(100)
  • LastName (last_name) — VARCHAR(100)
  • Salary (salary) — INT(11)

Vet_Speciality (vet_speciality)

  • Vet_Id (vet_id) — INT(11) — 외래 키 → Vet.Vet_Id — NOT NULL
  • Speciality_Id (speciality_id) — INT(11) — 외래 키 → Speciality.Speciality_Id — NOT NULL

Visit (visits)

  • Visit_Id (visit_id) — INT(11) — 기본 키 — NOT NULL
  • Pet_Id (pet_id) — INT(11) — 외래 키 → Pet.Pet_Id — NOT NULL
  • Vet_Id (vet_id) — INT(11) — 외래 키 → Vet_Speciality.Vet_Id — NOT NULL
  • Nurse_Id (nurse_id) — INT(11) — 외래 키 → Nurse.Nurse_Id — NOT NULL
  • Room_Id (room_id) — INT(11) — 외래 키 → OperatingRoom.Room_Id — NOT NULL
  • VisitDate (visit_date) — VARCHAR(50)
  • Description (description) — VARCHAR(255)