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