re
Tables (11)
ExternalData
- ExternalDataID — INT — Primary key — NOT NULL
- ExternalSearchTerm — VARCHAR(255) — NOT NULL
- ExternalSourceLink — VARCHAR(255) — NOT NULL
- ExternalDataCollectionDate — DATE — NOT NULL
- SearchID — INT — NOT NULL
GeneratedResult
- ResultID — INT — Primary key — NOT NULL
- GeneratedText — CLOB — NOT NULL
- GeneratedDate — DATE — NOT NULL
- SearchID — INT — NOT NULL
- SearchID (SearchID2) — INT — Foreign key → SearchHistory.SearchID — NOT NULL
HealthRecord
- RecordID — INT — Primary key — NOT NULL
- HealthRecordContent — CLOB — NOT NULL
- HealthRecordDate — DATE — NOT NULL
- PetID (PetID2) — INT — Foreign key → Pet.PetID — NOT NULL
InternalData
- InternalDataID — INT — Primary key — NOT NULL
- InternalRecordContent — CLOB — NOT NULL
- InternalRecordDate — DATE — NOT NULL
- PetID — INT — NOT NULL
- UserID — INT — NOT NULL
- UserID (UserID2) — INT — Foreign key → User.UserID — NOT NULL
- PetID (PetID2) — INT — Foreign key → Pet.PetID — NOT NULL
InternetSearchData
- InternetDataID — INT — Primary key — NOT NULL
- InternetSearchTerm — VARCHAR(255) — NOT NULL
- InternetSourceLink — VARCHAR(255) — NOT NULL
- InternetCrawlingDate — DATE — NOT NULL
- SearchID — INT — NOT NULL
- SearchID (SearchID2) — INT — Foreign key → SearchHistory.SearchID — NOT NULL
LoginManagement
- LoginID — INT — Primary key — NOT NULL
- LoginSuccess — VARCHAR(10) — NOT NULL
- UserID — INT — NOT NULL
- UserID (UserID2) — INT — Foreign key → User.UserID — NOT NULL
Pet
- PetID — INT — Primary key — NOT NULL
- PetName — VARCHAR(100) — NOT NULL
- PetAge — INT
- PetGender — VARCHAR(10)
- PetBreed — VARCHAR(100)
- PetMedicalConditions — VARCHAR(255)
- PetSurgeryHistory — VARCHAR(255)
- PetRecordDate — DATE
- UserID — INT — Foreign key → User.UserID — NOT NULL
Prognosis
- PrognosisID — INT — Primary key — NOT NULL
- PrognosisSymptoms — VARCHAR(255) — NOT NULL
- PrognosisDiagnosis — VARCHAR(255) — NOT NULL
- PrognosisContent — CLOB — NOT NULL
- PrognosisRecordDate — DATE — NOT NULL
- PetID (PetID2) — INT — Foreign key → Pet.PetID — NOT NULL
QuestionAnswer
- QAID — INT — Primary key — NOT NULL
- QuestionContent — CLOB — NOT NULL
- AnswerContent — CLOB — NOT NULL
- AnswerDate — DATE — NOT NULL
- UserID — INT — NOT NULL
- PetID — INT — NOT NULL
- ExternalDataID — INT — Foreign key → ExternalData.ExternalDataID — NOT NULL
SearchHistory
- SearchID — INT — Primary key — NOT NULL
- SearchTerm — VARCHAR(255) — NOT NULL
- SearchDate — DATE — NOT NULL
User
- UserID — INT — Primary key — NOT NULL
- UserName — VARCHAR(100) — NOT NULL
- UserEmail — VARCHAR(100) — NOT NULL
- UserPassword — VARCHAR(100) — NOT NULL
- UserAddress — VARCHAR(255)
- UserRegistrationDate — DATE — NOT NULL