广东医科大学附属医院数据库

1. **Medical System Databases (kd, kd_find, kd_test)**

- Core business database for a hemodialysis (blood purification) clinical management system

- Contains operational data from May 21, 2025 to December 15, 2025 (7-month period)

- Includes critical tables like:

- `hd_msg_record`: Message notifications (95,507 records)

- Patient management and dialysis records

- Medical order processing system

2. **Payment/Financial System (cdb_test)**

- Contains payment processing and transaction data

- Includes merchant, transaction, and settlement tables

- Appears to be a test environment for financial operations

3. **System Databases (mysql)**

- Standard MySQL system tables

- Includes user permissions, system configuration

- Critical for user authentication and authorization

4. **Medical Dictionary & Patient Sync** (medical, syn_patient)

- `medical`: Standard medical dictionaries and code tables

- `syn_patient`: Patient data synchronization and integration

### Technical Characteristics

- **MySQL Version**: 5.7.36 for Linux (x86_64)

- **Database Size**: 1.4GB compressed

- **Character Set**: UTF-8 (utf8mb4)

- **Tables**: 100+ tables across 7 databases

- **Primary Data Volume**: Approximately 95,000+ medical record transactions

### Institution Ownership

**Confirmed Owner**: Guangdong Medical University Affiliated Hospital (广东医科大学附属医院)

- Tenant ID: 20071

- Hospital ID: 20071001

- Multi-tenant architecture with tenant isolation

### Data Quality Assessment

✅ **Strengths**:

- Complete operational period coverage (no gaps)

- High referential integrity across tables

- Consistent timestamp records

- Proper audit trails (create/modify tracking)

⚠️ **Considerations**:

- Mix of production and test data in backup

- Some deprecated test configurations present

- Requires data filtering for production recovery

### Usage Scenarios

This backup can be used for:

1. **Full System Recovery**: Complete restoration of all databases

2. **Single Database Restore**: Selective restoration of kd database only

3. **Data Analysis**: Historical analysis of dialysis operations

4. **Compliance**: Medical records retention and auditing

5. **Development**: Setting up test/staging environments

---

*Generated: 2025-12-23 01:26*

*Database Type: MySQL 5.7.36*

*Backup Format: mysqldump (SQL)*