ㄱㄱㄷ
Tables (10)
CrawlingData
- CrawlingDataID — INT — Primary key — NOT NULL
- Keyword — VARCHAR(255) — NOT NULL
- SourceLink — VARCHAR(255) — NOT NULL
- CollectionDate — DATE — NOT NULL
GeneratedResult
- ResultID — INT — Primary key — NOT NULL
- GeneratedText — CLOB — NOT NULL
- GeneratedDate — DATE — NOT NULL
- SearchID — INT — NOT NULL
HealthRecord
- RecordID — INT — Primary key — NOT NULL
- HealthRecordContent — CLOB — NOT NULL
- HealthRecordDate — DATE — NOT NULL
- PetID — INT — NOT NULL
InternalData
- InternalDataID — INT — Primary key — NOT NULL
- InternalRecordContent — CLOB — NOT NULL
- InternalRecordDate — DATE — NOT NULL
- PetID — INT
- UserID — INT
- QuestionAnswerID — INT
- SearchHistoryID — INT
- LoginID — INT
- UserID (UserID2) — INT — Foreign key → User.UserID — NOT NULL
- PetID (PetID2) — INT — Foreign key → Pet.PetID — NOT NULL
- RecordID — INT — Foreign key → Pet.RecordID — NOT NULL
- PrognosisID — INT — Foreign key → Pet.PrognosisID — NOT NULL
LoginManagement
- LoginID — INT — Primary key — NOT NULL
- LoginSuccess — VARCHAR(10) — NOT NULL
- InternalDataID — INT — NOT NULL
Pet
- PetID — INT — Primary key — NOT NULL
- RecordID — INT — Foreign key → HealthRecord.RecordID — NOT NULL
- PrognosisID — INT — Foreign key → Prognosis.PrognosisID — 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 — NOT NULL
- UserID (UserID2) — 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 — INT — NOT NULL
QuestionAnswer
- QAID — INT — Primary key — NOT NULL
- QuestionContent — CLOB — NOT NULL
- AnswerContent — CLOB — NOT NULL
- AnswerDate — DATE — NOT NULL
- InternalDataID — INT — NOT NULL
- CrawlingDataID — INT — NOT NULL
SearchHistory
- SearchID — INT — Primary key — NOT NULL
- SearchTerm — VARCHAR(255) — NOT NULL
- SearchDate — DATE — NOT NULL
- InternalDataID — INT — 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