응급서비스
테이블 (6)
CrawlingData
- DataID — INT — 기본 키 — NOT NULL
- SearchLink — VARCHAR(255) — NOT NULL
- SearchDate — DATE — NOT NULL
- SearchTerm — VARCHAR(255) — NOT NULL
- TreatmentSuggestion — VARCHAR(255) — NOT NULL
HealthRecords
- DiseaseID — INT — 기본 키 — NOT NULL
- DiseaseName — VARCHAR(100)
- DiseaseKeywords — VARCHAR(255)
- TreatmentRecord — CLOB
- PetID — INT — NOT NULL
InternalData
- InternalDataID — INT — 기본 키 — NOT NULL
- GuardianID — INT — 외래 키 → Users.GuardianID — NOT NULL
- PetID — INT — 외래 키 → Pets.PetID — NOT NULL
- LoginID — INT — 외래 키 → LoginManagement.LoginID — NOT NULL
- DiseaseID — INT — 외래 키 → HealthRecords.DiseaseID — NOT NULL
LoginManagement
- LoginID — INT — 기본 키 — NOT NULL
- GuardianID — INT — NOT NULL
- LoginSuccess — BOOLEAN — NOT NULL
- LoginDate — DATE — NOT NULL
Pets
- PetID — INT — 기본 키 — NOT NULL
- GuardianID — INT — NOT NULL
- PetName — VARCHAR(100) — NOT NULL
- Age — INT
- Gender — VARCHAR(10)
- Breed — VARCHAR(100)
- MedicalConditions — VARCHAR(255)
- RegistrationDate — DATE — NOT NULL
Users
- GuardianID — INT — 기본 키 — NOT NULL
- GuardianName — VARCHAR(100) — NOT NULL
- Email — VARCHAR(100) — NOT NULL
- Password — VARCHAR(100) — NOT NULL
- Address — VARCHAR(255)
- RegistrationDate — DATE — NOT NULL