KU-HEALTH

Tables (5)

Hospital (병원)

  • hospitalId — Long — Primary key — NOT NULL
  • googleMapId — Long

Member (맴버)

  • memberId — Long — Primary key — NOT NULL
  • nickname — String
  • userId — String
  • password — String
  • email — String
  • profileimage — String

Survey (건강설문)

  • surveyId — Long — Primary key — NOT NULL
  • memberId — Long — Foreign key → Member.memberId — NOT NULL
  • targetbody — String
  • diagnosisPart — String
  • presentedsymptom — String

hospital_comment (병원 댓글)

  • commentId — Long — Primary key — NOT NULL — PK
  • memberId — Long — Foreign key → Member.memberId — NOT NULL
  • hospitalId — Long — Foreign key → Hospital.hospitalId — NOT NULL
  • content — String
  • reportCount — Long
  • isDeleted — Boolean
  • star — Long
  • parentId — VARCHAR(255)

member_hospital (병원_멤버)

  • memberHospitalId — Long — Primary key — NOT NULL
  • hospitalId — Long — Foreign key → Hospital.hospitalId — NOT NULL
  • memberId — Long — Foreign key → Member.memberId — NOT NULL
  • isBookmarked — Boolean