응급서비스

테이블 (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