pet_health

Tables (9)

CalerdarEvent (일정)

  • event_id (pk) — int — Primary key — NOT NULL
  • user_id (fk) — int
  • pet_id (fk2) — int
  • eventType (일정 유형) — varchar
  • eventDate (일정 날짜) — date
  • eventTime (일정 시간) — time
  • description (일정 메모) — text

Hospital (병원)

  • hospital_id (pk) — int — Primary key — NOT NULL
  • hosName (병원이름) — varchar
  • hosAddress (병원주소) — varchar
  • hosPhone (병원연락처) — varchar
  • hosAvgRating (병원평균평점) — int

HospitalVisit (병원 방문)

  • event_id (pk,fk) — int — Foreign key → CalerdarEvent.event_id — NOT NULL
  • hospital_id (fk) — int — Foreign key → Hospital.hospital_id — NOT NULL
  • hospitalName (병원 이름) — varchar
  • doctorName (의사 이름) — varcher
  • symptom (증상) — varchar
  • reviewCalerdar (간단후기) — varchar

Medication (약 복용)

  • event_id (pk,fk) — int — Foreign key → CalerdarEvent.event_id — NOT NULL
  • drugName (약 이름) — varchar
  • dosage (복용량) — carchar
  • frequency (횟수) — int
  • isCompleted (복용완료 여부) — boolean

Pet (반려동물)

  • pet_id (pk) — int — Primary key — NOT NULL
  • event_id (pk2) — int — Foreign key → CalerdarEvent.event_id — NOT NULL
  • petBirth (펫생일) — date

Review (병원 후기)

  • review_id (pk) — int — Primary key — NOT NULL
  • hospital_id (pk2) — int — Foreign key → Hospital.hospital_id — NOT NULL
  • user_id (pk3) — int — Foreign key → User.user_id — NOT NULL
  • pet_id (pk4) — int — Foreign key → Pet.pet_id — NOT NULL
  • hospital_id (Field) — int
  • visitDate (방문일) — date
  • reviewTitle (후기제목) — varchar
  • reviewContent (내용) — varchar
  • hosRating (평점) — int
  • reviewRegdate (후기등록시간) — datetime
  • hosCost (비용) — int

ReviewComment (후기댓글)

  • comment_id (pk) — int — Primary key — NOT NULL
  • review_id (pk2) — int — Foreign key → Review.review_id — NOT NULL
  • user_id (pk3) — int — Foreign key → User.user_id — NOT NULL
  • hospital_id (pk22) — int — Foreign key → Review.hospital_id — NOT NULL
  • pet_id (pk4) — int — Foreign key → Review.pet_id — NOT NULL
  • commentContent (댓글 내용) — varchar
  • commentRegDate (댓글 작성시각) — datetime

User (사용자)

  • user_id (pk) — int — Primary key — NOT NULL
  • event_id (pk2) — int — Foreign key → CalerdarEvent.event_id — NOT NULL
  • nickname (닉네임) — varchar
  • email (이메일) — varchar
  • userBirth (생일) — date

Working (산책/운동)

  • event_id (fk, pk) — int — Foreign key → CalerdarEvent.event_id — NOT NULL
  • stratTime (시작 시간) — time
  • endTime (종료 시간) — time
  • allTime (총 시간) — varchar
  • Route (경로) — varchar
  • distance (거리) — varchar