Scribd
Upload
2 views16 pages

Table

The document outlines a database schema consisting of various tables related to healthcare management, including tables for drugs, patients, laboratory results, transactions, and user privileges. Each table is detailed with its respective columns, data types, and attributes, indicating the structure for storing relevant information. The document serves as a reference for understanding the relationships and data organization within the healthcare system.

Uploaded by

wube hailu
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
2 views16 pages

Table

The document outlines a database schema consisting of various tables related to healthcare management, including tables for drugs, patients, laboratory results, transactions, and user privileges. Each table is detailed with its respective columns, data types, and attributes, indicating the structure for storing relevant information. The document serves as a reference for understanding the relationships and data organization within the healthcare system.

Uploaded by

wube hailu
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
You are on page 1/ 16

Table of contents

1 excelfiles Page number: 2


2 tbl_drugs Page number: 3
3 tbl_icd10 Page number: 4
4 tbl_laboratory Page number: 5
5 tbl_labresults Page number: 6
6 tbl_managementplan Page number: 7
7 tbl_petients Page number: 8
8 tbl_readings Page number: 9
9 tbl_transactions Page number: 10
10 tbl_treatment Page number: 11
11 tbl_userlogs Page number: 12
12 tbl_userprivilages Page number: 13
13 tbl_users Page number: 14
14 tbl_vendors Page number: 15
15 Relational schema Page number: 16

Page number: 1/16 May 26, 2025 at 03:24 PM


1 excelfiles

Creation: May 21, 2025 at 10:45 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
ids varchar(30) No
PaymentP varchar(30) No
name varchar(100 No
0)
type varchar(30) No
Size decimal(10, No
0)
content longblob No

Page number: 2/16 May 26, 2025 at 03:24 PM


2 tbl_drugs

Creation: May 21, 2025 at 10:45 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
Name varchar(300 No
)
DOE varchar(300 No
)
Quantity varchar(300 No
)
Drugsremain varchar(300 No
)
PurchasedPrice varchar(300 No
)
RetailPrice varchar(300 No
)
Strength varchar(300 No
)
Medstype varchar(300 No
)
Marker varchar(300 No
)

Page number: 3/16 May 26, 2025 at 03:24 PM


3 tbl_icd10

Creation: May 21, 2025 at 10:45 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
Diagnosisname varchar(300 No
0)
Diagnosiscode varchar(30) No

Page number: 4/16 May 26, 2025 at 03:24 PM


4 tbl_laboratory

Creation: May 21, 2025 at 10:45 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
Patientid varchar(30) No
Diseased varchar(300 No
0)
Test_RBS varchar(300 No
0)
Test_FBS varchar(300 No
0)
Test_PBS varchar(300 No
0)
Test_UCT varchar(300 No
0)
Test_MRDT varchar(300 No
0)
Test_FBC varchar(300 No
0)
Test_TFT varchar(300 No
0)
Test_LFT varchar(300 No
0)
Patient_Complai varchar(300 No
nt 0)
Patient_Story varchar(300 No
0)
Test_comment varchar(300 No
0)
Results varchar(300 No
0)
Officer varchar(300 No
)
Date varchar(30) No
Status varchar(30) No

Page number: 5/16 May 26, 2025 at 03:24 PM


5 tbl_labresults

Creation: May 21, 2025 at 10:45 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
Patientid varchar(30) No
Testid varchar(30) No
Status varchar(30) No
Test_FBS varchar(300 No
0)
FBS_Comment varchar(300 No
0)
Test_RBS varchar(300 No
0)
RBS_Comment varchar(300 No
0)
Test_UCT varchar(300 No
0)
UCT_Comment varchar(300 No
0)
Test_PBS varchar(300 No
0)
PBS_Comment varchar(300 No
0)
Test_MRDT varchar(300 No
0)
MRDT_Commen varchar(300 No
t 0)
Test_FBC varchar(300 No
0)
FBC_Comment varchar(300 No
0)
Test_TFT varchar(300 No
0)
TFT_Comment varchar(300 No
0)
Test_LFT varchar(300 No
0)
LFT_Comment varchar(300 No
0)
Officer varchar(300 No
)
Date varchar(30) No

Page number: 6/16 May 26, 2025 at 03:24 PM


6 tbl_managementplan

Creation: May 21, 2025 at 10:45 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
Resultsid varchar(300 No
0)
Patientid varchar(30) No
Management_pl varchar(300 No
an 0)
Date varchar(30) No
Status varchar(300 No
0)
Plan varchar(300 No
0)

Page number: 7/16 May 26, 2025 at 03:24 PM


7 tbl_petients

Creation: May 21, 2025 at 10:45 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
Mtitle varchar(30) No
Firstname varchar(300 No
)
Middlename varchar(300 No
)
Sirname varchar(300 No
)
Gender varchar(30) No
Phone varchar(30) No
NextKphone varchar(300 No
)
DOB varchar(300 No
)
Location varchar(300 No
)
Relation varchar(300 No
)
Guardian varchar(300 No
)
Status varchar(300 No
)
Status2 varchar(30) No
Date varchar(300 No
)
Payment varchar(30) No

Page number: 8/16 May 26, 2025 at 03:24 PM


8 tbl_readings

Creation: May 21, 2025 at 10:45 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
Patientid varchar(30) No
Date varchar(300 No
)
Time varchar(300 No
)
BodyT varchar(300 No
0)
PulseRate varchar(300 No
0)
RespirationRate varchar(300 No
0)
SystolicBP varchar(300 No
0)
DiastolicBP varchar(300 No
0)
Oxygensaturati varchar(300 No
on 0)

Page number: 9/16 May 26, 2025 at 03:24 PM


9 tbl_transactions

Creation: May 21, 2025 at 10:45 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
Patientid varchar(30) No
Drugname varchar(300 No
0)
Quantity varchar(300 No
0)
Amount varchar(30) No
Days varchar(30) No
Unitprice varchar(300 No
0)
Totalcost varchar(300 No
0)
Consultation_fe varchar(300 No
e 0)
Lab_fee varchar(300 No
0)
Payment varchar(300 No
)
Scheme_id varchar(300 No
)
Date varchar(300 No
)
Time varchar(300 No
)

Page number: 10/16 May 26, 2025 at 03:24 PM


10 tbl_treatment

Creation: May 21, 2025 at 10:45 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
Resultsid varchar(300 No
0)
Patientid varchar(30) No
Drugid varchar(300 No
0)
Quantity varchar(300 No
0)
Amount varchar(30) No
Timesperday varchar(300 No
0)
Days varchar(30) No
Prescribe_Com varchar(300 No
ment )
Date varchar(30) No
Officer varchar(300 No
0)
Status varchar(300 No
0)
Plan varchar(300 No
0)
Progress varchar(300 No
0)

Page number: 11/16 May 26, 2025 at 03:24 PM


11 tbl_userlogs

Creation: May 21, 2025 at 10:45 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
Userid varchar(300 No
)
Machineip varchar(300 No
)
Login varchar(300 No
)
Logout varchar(300 No
)
Activities varchar(300 No
0)
Count varchar(300 No
0)

Page number: 12/16 May 26, 2025 at 03:24 PM


12 tbl_userprivilages

Creation: May 21, 2025 at 10:45 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
Userid varchar(30) No
Adduser varchar(300 No
0)
Manageuser varchar(300 No
0)
Logactivities varchar(300 No
0)
Addpatient varchar(300 No
0)
Editpatient varchar(300 No
0)
Managepatient varchar(300 No
0)
Consultation varchar(300 No
0)
Labaccess varchar(300 No
0)
Accountaccess varchar(300 No
0)
Givedrugs varchar(300 No
0)
Adddrugs varchar(300 No
)
Managedrugs varchar(30) No
Todayssales varchar(300 No
0)
Todaystreat varchar(300 No
)
Monthlyreport varchar(30) No

Page number: 13/16 May 26, 2025 at 03:24 PM


13 tbl_users

Creation: May 21, 2025 at 10:45 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
Firstname varchar(300 No
)
Sirname varchar(300 No
)
Mtitle varchar(30) No
Pic_name varchar(30) No
Phone varchar(30) No
Email varchar(300 No
)
Password varchar(300 No
)
Role varchar(30) No
State varchar(30) No
Online varchar(300 No
)
Time bigint(30) No

Page number: 14/16 May 26, 2025 at 03:24 PM


14 tbl_vendors

Creation: May 21, 2025 at 10:45 PM

Column Type Attributes Null Default Extra Links to Comments MIME

id int(11) No auto_increment
Fullname varchar(300 No
)
Location varchar(300 No
)
Phone varchar(300 No
)
Email varchar(300 No
)
DOP varchar(300 No
)
Drugid varchar(300 No
)

Page number: 15/16 May 26, 2025 at 03:24 PM


tbl_drugs tbl_laboratory tbl_readings
id id id
Name Patientid Patientid
DOE Diseased Date
Quantity Test_RBS Time
Drugsremain Test_FBS BodyT
PurchasedPrice Test_PBS PulseRate
RetailPrice Test_UCT RespirationRate
Strength Test_MRDT SystolicBP
Medstype Test_FBC DiastolicBP
Marker Test_TFT Oxygensaturation
Test_LFT
Patient_Complaint
Patient_Story
Test_comment
Results
Officer
Date
Status

tbl_petients tbl_userprivilages
excelfiles
id id
id
Mtitle Userid
ids
Firstname Adduser
PaymentP
Middlename Manageuser
name
Sirname Logactivities
type
Gender Addpatient
Size
Phone Editpatient
content
NextKphone Managepatient
DOB Consultation
Location Labaccess
Relation Accountaccess
Guardian Givedrugs
Status Adddrugs
Status2 Managedrugs
Date Todayssales
Payment Todaystreat
Monthlyreport

tbl_transactions
id tbl_icd10
Patientid id
Drugname Diagnosisname
Quantity Diagnosiscode
Amount
Days
Unitprice
Totalcost
Consultation_fee
Lab_fee
Payment
Scheme_id
Date
Time

tbl_treatment
id
Resultsid
Patientid
Drugid
Quantity
Amount
Timesperday
Days
tbl_vendors Prescribe_Comment
id Date
Fullname Officer
Location Status
Plan tbl_labresults
Phone
Progress id
Email
Patientid
DOP
Testid
Drugid
Status
Test_FBS
FBS_Comment
Test_RBS
RBS_Comment
Test_UCT
UCT_Comment
Test_PBS
PBS_Comment
Test_MRDT
MRDT_Comment
Test_FBC
FBC_Comment
tbl_managementplan Test_TFT
id TFT_Comment
Resultsid Test_LFT
Patientid LFT_Comment
tbl_userlogs Management_plan Officer
id Date Date
Userid Status
Machineip Plan
Login
Logout
Activities
Count

tbl_users
id
Firstname
Sirname
Mtitle
Pic_name
Phone
Email
Password
Role
State
Online
Time

Page number: 16/16 May 26, 2025 at 03:24 PM


Powered by TCPDF (www.tcpdf.org)

You might also like