pythonicshahdev/mysql-clinical repository overview

⁠mysql-clinical

Mock HR database for physician golden record demos. Simulates an Infor/Lawson-style HR system with pre-seeded employee data including employed physicians and non-clinical staff.

⁠Connection Details

⁠Data Design

30 employee records in table employees:

• 18 employed physicians (NPI not null) — collision candidates matching records in pythonicshahdev/fastapi-clinical-source
• 12 non-clinical employees (NPI null) — nurses, admins, coordinators — no golden record created

Physician records span 5 conflict groups designed to demonstrate DataHub match rules and survivorship.

⁠Boomi Connection

• Type: Database V2 Connector
• Driver: MySQL 8.x
• Host: host.docker.internal:3308
• Database: clinical_hr

⁠Quick Start

  docker run -d --name mysql-clinical -p 3308:3306 \                       
    -e MYSQL_ROOT_PASSWORD=clinical_root \                                 
    -e MYSQL_DATABASE=clinical_hr \
    -e MYSQL_USER=clinical_user \                                            
    -e MYSQL_PASSWORD=clinical_pass \
    pythonicshahdev/mysql-clinical:latest 

Use with pythonicshahdev/fastapi-clinical-source for the full demo stack.

⁠Part of the Clinical DataHub Demo Stack

• pythonicshahdev/fastapi-clinical-source — Credentialing REST API + Epic receiver
• pythonicshahdev/mysql-clinical — HR database