데이터베이스 과제
테이블 (14)
Untitled (Users)
- Key (UserID) — 기본 키 — NOT NULL
- Field (Name)
- Field (Email)
- Field (Password)
- Field (RegisteredDate)
- Field (PetID)
Untitled (Pets)
- Key (PetID) — 기본 키 — NOT NULL
- Field (PetName)
- Field (PetCategoryID)
- Field (PetAge)
- Field (PetGender)
- Field (PetPhoto)
- Field (AnimalRegistrationNumber)
- Key (UserID) — 외래 키 → Untitled.Key — NOT NULL
Untitled (HealthInformations)
- Key (HealthInformationID) — 기본 키 — NOT NULL
- Field (NeuteringSurgery)
- Field (allergy)
- Field (OtherHealthInformation)
- Field
- Key (PetID) — 외래 키 → Untitled.Key — NOT NULL
Untitled (PetCategories)
- Key (PetCategoryID) — 기본 키 — NOT NULL
- Field (PetCategory)
Untitled (MedicalRecords)
- Key (MedicalRecordID) — 기본 키 — NOT NULL
- Field (MedicalRecordDate)
- Field (PetID)
- Field (Symptom)
- Field (Diagnosis)
- Field (VetID)
- Key (AnimalHospitalID) — 외래 키 → Untitled.Key — NOT NULL
Untitled (AnimalHospitals)
- Key (AnimalHospitalID) — 기본 키 — NOT NULL
- Field (AnimalHospitalName)
- Field (Local)
- Field (VetID)
- Field (AnimalHospitalPhone)
- Field (OperatingTime)
Untitled (Vets)
- Key (VetID) — 기본 키 — NOT NULL
- Field (VetName)
- Field (VetSpecialization)
- Field (VetEducation)
- Field (VetCareer)
- Key (AnimalHospitalID) — 외래 키 → Untitled.Key — NOT NULL
Untitled (PetFoods)
- Key (PetFoodID) — 기본 키 — NOT NULL
- Field (Brand)
- Field (PetFoodName)
- Field (PetFoodCategory)
- Field (Ingredient)
- Field (Weight)
- Field (Price)
- Field (RecommendedAge)
- Field (RecommendedWeight)
- Field (RecommendedIntake)
- Field (Photo)
Untitled (Trainers)
- Key (TrainerID) — 기본 키 — NOT NULL
- Field (TrainerName)
- Field (TrainerSpecialization)
- Field (TrainerEduciton)
- Field (TrainerCareer)
Untitled (Trainings)
- Key (TrainingID) — 기본 키 — NOT NULL
- Field (Training)
- Field (TrainingCategory)
- Key (TrainerID) — 외래 키 → Untitled.Key — NOT NULL
Untitled (MedicalKnowleddges)
- Key (MedicalKnowleddgeID) — 기본 키 — NOT NULL
- Field (MedicalKnowleddge)
- Field (MedicalKnowleddgeCategory)
- Key (VetID) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Questions)
- Key (QuestionID) — 기본 키 — NOT NULL
- Field (Question)
- Field (FieldQuestionCategory)
- Field2 (QuestionDate)
- Key (UserID) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Answers)
- Key (AnswerID) — 기본 키 — NOT NULL
- Field (Answer)
- Field
- Key (UserID) — 외래 키 → Untitled.Key — NOT NULL
- Key (QuestionID) — 외래 키 → Untitled.Key — NOT NULL
- Key (PetFoodID) — 외래 키 → Untitled.Key — NOT NULL
- Key (MedicalKnowleddgeID) — 외래 키 → Untitled.Key — NOT NULL
- Key (TrainingID) — 외래 키 → Untitled.Key — NOT NULL
Untitled (AnswerReviews)
- Key (AnswerReviewID) — 기본 키 — NOT NULL
- Field (ReviewScore)
- Field (ReviewDate)
- Key (UserID) — 외래 키 → Untitled.Key — NOT NULL
- Key (QuestionID) — 외래 키 → Untitled.Key — NOT NULL