Geekzone: technology news, blogs, forums
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


608 posts

Ultimate Geek

#265662 4-Feb-2020 11:21
Send private message

We've been given a doctors SQL database dump from MyPractice - and the doctor has asked us to export his clinical letters, lab results, images etc.


We've looked through the db structure and see they have patients in the Person table, that's straightforward.


However storing notes, letters, etc is a bit less obvious. RecordData and PartyData contain some relevant rows, but there are also titles such as Column1 through Column15 which are less self-explanatory. For example Column2 of RecordData references various pdf filenames, but files were not provided in the export. 


Does anyone have any experience with this database structure at all?



Create new topic
1443 posts

Uber Geek
Inactive user

  #2412349 4-Feb-2020 11:36
Send private message

You can contact the developer directly, via the ‘contact’ information on the Mypractice website.


Learn cloud, mobile, security, data and web technologies with Pluralsight (affiliate link).

608 posts

Ultimate Geek

  #2412355 4-Feb-2020 11:42
Send private message

Tried that, they are unwilling to help.

441 posts

Ultimate Geek

ID Verified
Lifetime subscriber

  #2412407 4-Feb-2020 12:08
Send private message

You might find that the documents are not saved as as blob data at all. Its very common to "attach" files to a patient record thats just a link to a file on a central server.

Happy to have an out of public with an NDA as you have as you have patient data that requires a level of sensitivity.



608 posts

Ultimate Geek

  #2412533 4-Feb-2020 16:06
Send private message

Problem solved, thanks team.

Create new topic

News and reviews »

New Air Traffic Management Platform and Resilient Buildings a Milestone for Airways
Posted 6-Dec-2023 05:00

Logitech G Launches New Flagship Console Wireless Gaming Headset Astro A50 X
Posted 5-Dec-2023 21:00

NordVPN Helps Users Protect Themselves From Vulnerable Apps
Posted 5-Dec-2023 14:27

First-of-its-Kind Flight Trials Integrate Uncrewed Aircraft Into Controlled Airspace
Posted 5-Dec-2023 13:59

Prodigi Technology Services Announces Strategic Acquisition of Conex
Posted 4-Dec-2023 09:33

Samsung Announces Galaxy AI
Posted 28-Nov-2023 14:48

Epson Launches EH-LS650 Ultra Short Throw Smart Streaming Laser Projector
Posted 28-Nov-2023 14:38

Fitbit Charge 6 Review 
Posted 27-Nov-2023 16:21

Cisco Launches New Research Highlighting Gap in Preparedness for AI
Posted 23-Nov-2023 15:50

Seagate Takes Block Storage System to New Heights Reaching 2.5 PB
Posted 23-Nov-2023 15:45

Seagate Nytro 4350 NVMe SSD Delivers Consistent Application Performance and High QoS to Data Centers
Posted 23-Nov-2023 15:38

Amazon Fire TV Stick 4k Max (2nd Generation) Review
Posted 14-Nov-2023 16:17

Over half of New Zealand adults surveyed concerned about AI shopping scams
Posted 3-Nov-2023 10:42

Super Mario Bros. Wonder Launches on Nintendo Switch
Posted 24-Oct-2023 10:56

Google Releases Nest WiFi Pro in New Zealand
Posted 24-Oct-2023 10:18

Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.

Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.