동물병원
테이블 (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)