데이터베이스 과제

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