Project:CityCare Hospital Migration
Source DB:
legacy_hmsTarget DB:
healthbookaiUpload Source Tables
Upload source schema files for legacy_hms. The system will detect multiple source tables and display them in table format.
✓Source schema saved · 10:43:38 AM
Source Database Upload
Source Database: legacy_hms · Supported: SQL, CSV, Excel, JSON, XML
✓
1 files uploaded successfully
30 tables · 420 columns detected from legacy_hms
appointments.csv
Source Schema Preview
Explore source database structure with multiple visualization options
Selected Source Table
old_patients
| Column Name | Data Type | Key | Nullable | Sample Value | Detected Meaning |
|---|---|---|---|---|---|
| patient_code | VARCHAR | PK | No | P1001 | Patient legacy identifier |
| fname | VARCHAR | - | Yes | Sujal | First name |
| lname | VARCHAR | - | Yes | Raut | Last name |
| dob | DATE | - | Yes | 1998-04-12 | Date of birth |
| gender | VARCHAR | - | Yes | M | Gender |
| mob_no | VARCHAR | - | Yes | 9876543210 | Mobile number |
| email_id | VARCHAR | - | Yes | sujal@example.com | Email address |
| address_line1 | VARCHAR | - | Yes | Baner Road | Address line 1 |
| address_line2 | VARCHAR | - | Yes | Near Hospital | Address line 2 |
| city | VARCHAR | - | Yes | Pune | City |
| state | VARCHAR | - | Yes | Maharashtra | State |
| pincode | VARCHAR | - | Yes | 411045 | Postal code |
Source Upload Summary
Database
legacy_hmsUploaded Files1
Detected Tables30
Detected Columns420
Primary Keys30
Foreign Keys64
✓Upload Complete