Health Connect relational model
Users (nickname, firstName, surname, birthYear, city, suburb,job, TV, videoID, mentorNickname)
Posts (postID, datetime, content) PostAuthors (nickname,postID)
PostComments (nickname, postID, datetime, content) Video(videoID, title, description, duration, filetype)
HealthPractitioners (healthPracID, firstName, surname,streetNumber, street, suburb, city, postcode, type)
PhoneNumber (phoneNumber, healthPracID) Illness (illnessID,name, description)
TreatmentRecords (nickname, healthPracID, illnessID,dateStarted, degree)
FOREIGN KEYS
PostAuthors (nickname) is dependent on Users (nickname)
PostComments (nickname) is dependent on Users (nickname)
PostAuthors (postID) is dependent on Posts (postID)
PostComments (postID) is dependent on Posts (postID)
Users (videoID) is dependent on Video (videoID)
TreatmentRecords (healthPracID) is dependent onHealthPractitioners (healthPracID)
PhoneNumber (healthPracID) is dependent on HealthPractitioners(healthPracID)
TreatmentRecords (illnessID) is dependent on Illness(illnessID)
OTHER CONSTRAINTS
Video
PayPal Gateway not configured
PayPal Gateway not configured