Scribd
Upload
33 views1 page

Healthcare Data Management

The document outlines a comprehensive database schema related to maintenance, equipment usage, insurance policies, billing details, and supplier information. It includes various entities such as Maintenance, Equipment Info, Patients, Insurance Provider Details, and Claim Details, each with specific attributes like IDs, dates, costs, and statuses. The structure is designed to manage and track maintenance activities, patient information, insurance claims, and supplier details effectively.

Uploaded by

aman
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
33 views1 page

Healthcare Data Management

The document outlines a comprehensive database schema related to maintenance, equipment usage, insurance policies, billing details, and supplier information. It includes various entities such as Maintenance, Equipment Info, Patients, Insurance Provider Details, and Claim Details, each with specific attributes like IDs, dates, costs, and statuses. The structure is designed to manage and track maintenance activities, patient information, insurance claims, and supplier details effectively.

Uploaded by

aman
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Maintenance

PK Maintenance_ID Numeric
FK Equipment_ID Numeric
Maintenance_Date Date
Equipment Usage
Issue_Description String
PK Usage_ID Numeric Resolution_Description String
FK Equipment_ID Numeric FK Technician_ID Numeric
FK Staff_ID Numeric Cost Numeric
FK Patient_ID String Next_Maintenance Date
Usage_Start_Time Datetime Status Categorical
Usage_End_Time Datetime Priority Categorical
Charges_Billed Numeric
Condition_Pre String
Condition_Post String Purchase_Orders
Updated_At Datetime PK Order_ID Numeric
Req_Maintenance String FK Equipment_ID Numeric
FK Supplier_ID Numeric
Quantity Numeric
Insurance_Policy_Details
Order_Date Date
FK Patient_ID Type Equipment Info
Expected_Delivery_Date Date
PK Insurance_Policy_ID Numeric PK Equipment_ID Numeric Actual_Delivery_Date Date
Fk Insurance_Provider_ID Numeric Product_Description String Cost_Per_Unit Numeric
Coverage_Amount Numeric Technician Lease_Length Numeric Total_Cost Numeric
Expiry_Date Date Equipment_Price NUmeric
PK Technician ID Numeric Status Categorical
Name String Equipment_Type Categorical Payment_Status Categorical
Department Categorical Purchase_Date Date Notes String
Cerification Categorical Purchase_Used Binary
Billing_Details Patients
Years of Experience Numeric Equipment_Age Numeric
PK Serial Number Numeric PK Patient ID Numeric
Warranty Numeric
Billing ID Numeric Name String
Speciality String
FK Patient_ID Numeric DOB Date

Insurance_Provider_Details Date_Issued Date Gender Categorical


Total_Amount Numeric
PK Insurance_Provider_ID Numeric
FK Insurance_Policy_ID Numeric
Insurance_Provider_Name String
Fk Claim_ID Numeric Test Details
Insurance_SPOC_Name Numeric
Patient_Payment Numeric PK Test ID Numeric Supplier Details
Insurance_SPOC_Number Numeric
Payment_Status Binary FK Patient ID Numeric
Network_Hospital Binary PK Supplier_ID Numeric
FK Technician ID Numeric
Supplier_Org_Name Categorical
FK Equipment ID Numeric
Supplier_Provider_Credentials Numeric
Status String
Supplier_Provider_Entity_Code Numeric
Findings String
Supplier_Provider_Street_1 String
Supplier_Provider_Street_2 String
Supplier_Provider_City String
Supplier_Provider_State String
Claim_Details
Supplier_Provider_ZIP Numeric
PK Claim_ID Numeric
Supplier_Provider_Specality_Code Categorical
FK Insurance Provider_ID Type
Specality_Decription String
Date_Submitted Date
Status Categorical
Amount_Claimed Numeric
Insurance_Amount_Approved Binary

You might also like