veterinary clinic

Tables (13)

Answer (Untitled6)

  • 답변키 (answer_id) — Int — Primary key — NOT NULL
  • 질문키 (inquiry_id) — Int — Foreign key → Inquiry.질문키 — NOT NULL
  • 유저키 (user_id2) — Int — Foreign key → Inquiry.유저키 — NOT NULL
  • 답변제목 (title) — Char
  • 답변내용 (content) — Text

Article (Untitled4)

  • 아티클키 (article_id) — Int — Primary key — NOT NULL
  • 병원키 (hospital_id) — Int — Foreign key → Clinic.병원키 — NOT NULL
  • 아티클제목 (title) — Char
  • 아티클내용 (content) — Text

Clinic (Untitled2)

  • 병원키 (hospital_id) — Int — Primary key — NOT NULL
  • 유저키 (user_id) — Int — Foreign key → User.유저키 — NOT NULL
  • 병원이름 (name) — Char
  • 병원소개 (bio) — Text
  • 주소 (address) — Char
  • 지역분류 (address_gu) — Char(choices)
  • 전문종 (species) — Char(choices)

Comment (Untitled13)

  • Key — Primary key — NOT NULL
  • 아티클키 (article_id) — Int — Foreign key → Article.아티클키 — NOT NULL
  • 유저키 (user_id) — Int — Foreign key → GeneralUser.유저키 — NOT NULL
  • 내용 (content) — Char

GeneralUser (Untitled10)

  • Key — Primary key — NOT NULL
  • 유저키 (user_id) — Int — Foreign key → User.유저키 — NOT NULL
  • 펫이름 (pet_name) — Char
  • 펫종류 (pet_species) — Char(choices)
  • 지역분류 (address_gu) — Char(choices)

HashTag (Untitled9)

  • 해시태그키 (hashtag_id) — Int — Primary key — NOT NULL
  • 태그이름 (tag_name) — Char

Hospital_HashTag (Untitled11)

  • Key (hospital_hashtag_id) — Int — Primary key — NOT NULL
  • 병원키 (hospital_id) — Int — Foreign key → Clinic.병원키 — NOT NULL
  • 해시태그키 (hashtag_id2) — Int — Foreign key → HashTag.해시태그키 — NOT NULL

Inquiry (Untitled5)

  • 질문키 (inquiry_id) — Int — Primary key — NOT NULL
  • 병원키 (hospital_id) — Int — Foreign key → Clinic.병원키 — NOT NULL
  • 유저키 (user_id) — Int — Foreign key → User.유저키 — NOT NULL
  • 유저키 (user_id2) — Int — Foreign key → Clinic.유저키 — NOT NULL
  • 문의제목 (title) — Char
  • 문의내용 (content) — Text

Reservation (Untitled8)

  • 예약키 (reservation_id) — Int — Primary key — NOT NULL
  • 유저키 (user_id) — Int — Foreign key → User.유저키 — NOT NULL
  • 병원키 (hospital_id) — Int — Foreign key → Clinic.병원키 — NOT NULL
  • 유저키 (user_id2) — Int — Foreign key → Clinic.유저키 — NOT NULL
  • 예약일 (date_time) — DateTime

Review (Untitled3)

  • 리뷰키 (review_id) — Int — Primary key — NOT NULL
  • 유저키 (user_id) — Int — Foreign key → User.유저키 — NOT NULL
  • 병원키 (hospital_id) — Int — Foreign key → Clinic.병원키 — NOT NULL
  • 리뷰제목 (title) — Char
  • 진료분류 (clinic_category) — Char(choices)
  • 펫종류 (pet_species) — Char(choices)
  • 진료비용 (price) — Int
  • 리뷰내용 (content) — Text
  • 평점 (rating) — Int

Review_HashTag (Untitled12)

  • Key (review_hashtag_id) — Int — Primary key — NOT NULL
  • 리뷰키 (review_id) — Int — Foreign key → Review.리뷰키 — NOT NULL
  • 해시태그키 (hashtag_id2) — Int — Foreign key → HashTag.해시태그키 — NOT NULL

User (Untitled)

  • 유저키 (user_id) — Int — Primary key — NOT NULL
  • 유저이름 (username) — Char
  • 권한 (permission) — Char

User_Hospital (follow) (Untitled7)

  • Key (user_hospital_id) — Int — Primary key — NOT NULL
  • 유저키 (user_id) — Int — Foreign key → User.유저키 — NOT NULL
  • 병원키 (hospital_id) — Int — Foreign key → Clinic.병원키 — NOT NULL