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