Data Dictionary

Table 1-26 shows the Data Dictionary is a comprehensive documentation

that provides detailed descriptions of the data elements and their properties within
a system or database. It serves as a reference guide that outlines the structure,
attributes, and constraints of each data element. The Data Dictionary includes
information such as field names, data types, field lengths, constraints, and
descriptions. By documenting and defining the data elements, the Data Dictionary
ensures consistency and accuracy in data usage, facilitates system understanding
and development, and serves as a valuable resource for developers,
administrators, and users involved in the management and utilization of the data.

Table 1. Admin
Field Name Data Type Field Null Default
Length
Username INT 11 NO
ID VARCHAR 60 NO

Password VATCHAR 60 NO
First_name VARCHAR 255 YES NULL
Last_name VARCHAR 255 YES NULL
Role VARCHAR 255 YES NULL
Email VARCHAR 100 YES NULL
Special Key VARCHAR 20 YES NULL
Table 2. baby notes

column type null default

id Int(11) No Auto
increment
user_id Int(11) no

date date Yes

notes Time No

Category Varchar(100) Yes

type Varchar(225) Yes

active Varchar(225) Yes

Varchar(100) yes

Table 3. Clinical_Cover
Column Type Null Default

id int(11) No
user_id int(11) No

informant varchar(255 Yes NULL

)
relationship varchar(100 Yes NULL
)
case_no varchar(50) Yes NULL
address varchar(255 Yes NULL
)
sex varchar(100 Yes NULL
)
civil_status enum('Singl e', 'Married', Yes NULL
'Widowed')

ad_type enum('NEW' Yes NULL

, 'OLD',
'Former OPD')

birthplace varchar(255 Yes NULL

)
birthdate date Yes NULL
age int(11) Yes NULL
occupation varchar(255 Yes NULL
)
religion varchar(100 Yes NULL
)
philhealth_statu s enum('Mem ber', 'None', '') Yes NULL

admission_date date Yes NULL

husb_name varchar(255 Yes NULL
)
husb_address varchar(255 Yes NULL
)
husb_occupatio n varchar(255 Yes NULL
)
husb_religion varchar(100 Yes NULL
)
husb_mobile varchar(15) Yes NULL
mother_name varchar(100 Yes NULL
)
mother_age int(11) Yes NULL
mother_add varchar(255 Yes NULL
)
father_name varchar(100 Yes NULL
)
father_age int(11) Yes NULL
father_add varchar(255 Yes NULL
)
coo varchar(255 Yes NULL
)
ad varchar(255 Yes NULL
)
final_d varchar(255 Yes NULL
)
disposition enum('Disch arged', Yes NULL
'Absconed', 'Referred')

no_days int(11) Yes NULL

ad_mid varchar(100 Yes NULL
)
at_mid varchar(100 Yes NULL
)
dis_mid varchar(100 Yes NULL
)
dis_date date Yes NULL
category varchar(255 Yes Pre Natal
)
type varchar(255 Yes Clinical Cover
)
created_at datetime Yes NULL
pre_id int(11) Yes NULL

product_name varchar(50) Yes NULL

price decimal(10, 2) Yes NULL

new_created_at datetime Yes NULL

active varchar(10) Yes active
app_id int(11) Yes NULL
payment varchar(50) Yes Unpaid

Table 4. del_service
Column Type Null Default Extra

id int(11) No auto_increment
service_name varchar(255 No
)
cost decimal(10, 2) No

Table 5. doctors_order
Column Type Attributes Null Default

id int(11) No
user_id int(11) No

ward varchar(100 Yes NULL

)
case_no varchar(20) No
checkup_date date No
checkup_time time No
notes text No
created_at timestamp No current_tim
estamp()
payment_type varchar(255 Yes NULL
)
amount int(11) Yes NULL
status varchar(255 Yes Pending
)
image_path varchar(255 Yes NULL
)
category varchar(255 Yes Pre Natal
)
type varchar(255 Yes Doctors Order
)
active varchar(100 Yes active
)
app_id int(11) Yes NULL

Table 6. fam_service
Column Type Null Default Extra

id int(11) No auto_increment
service_name varchar(255 Yes NULL
)
cost decimal(10, 2) Yes NULL

Table 7. high_risk
Column Type Null Default
id int(11) No
para varchar(50) No
abortion varchar(50) No
lmp varchar(50) Yes NULL
lmp_ultra varchar(50) Yes NULL
age_array varchar(255 Yes NULL
)
surgery_array varchar(255 Yes NULL
)
bleeding_array varchar(255 Yes NULL
)
parity_array varchar(255 Yes NULL
)
chronic_array varchar(255 Yes NULL
)
anemia_array varchar(255 Yes NULL
)
maturity_array varchar(255 Yes NULL
)
hypertension_ar ray varchar(255 Yes NULL
)
polyhydramios_ array varchar(255 Yes NULL
)
history_array varchar(255 Yes NULL
)
infertility_array varchar(50) Yes NULL
pospartum_arra y varchar(50) Yes NULL

manual_array varchar(50) Yes NULL

diabetes_array varchar(255 Yes NULL
)
intrauterine_arr ay varchar(50) Yes NULL

sevirity_array varchar(255 Yes NULL

)
cardiac_array varchar(255 Yes NULL
)
rupture_array varchar(255 Yes NULL
)
toxemia_array varchar(255 Yes NULL
)
multiple_array varchar(50) Yes NULL
previous_array varchar(255 Yes NULL
)
malpresentatio n_array varchar(255 Yes NULL
)
abnormal_array varchar(255 Yes NULL
)
rh_array varchar(255 Yes NULL
)
column1_total int(11) No
column2_total int(11) No
column3_total int(11) No
overall_total int(11) No
payment_type varchar(255 Yes NULL
)
amount int(11) Yes NULL
status varchar(255 Yes Pending
)
image_path varchar(255 Yes NULL
)
category varchar(255 Yes Pre Natal
)
type varchar(255 Yes High Risk Pregnancy
) Evaluation

active varchar(10) Yes active

user_id int(11) No

app_id int(11) Yes NULL

Table 8. Inventory
Column Type Null Default

prod_id int(11) No
product_name varchar(255 No
)
price decimal(10, 2) No

quantity int(11) No
category varchar(255 Yes NULL
)
type varchar(20) Yes Inventory
created_at timestamp No current_tim estamp()

Table 9. midwife_notes
Column Type Null Default

id int(11) No
user_id int(11) No

ward varchar(100 Yes NULL

)
case_no varchar(20) No
checkup_date date No
checkup_time time No
notes text No
created_at timestamp No current_tim estamp()

payment_type varchar(255 Yes NULL

)
status varchar(255 Yes Pending
)
image_path varchar(255 Yes NULL
)
category varchar(255 Yes Pre Natal
)
type varchar(255 Yes Midwife Notes
)
active varchar(100 Yes active
)
app_id int(11) Yes

Table 10. mid_sheets

Column Type Null Default

id int(11) No
user_id int(11) No

date date Yes NULL

time time No
orders varchar(50) No
attending_midw ife varchar(50) Yes NULL

date_1 date Yes NULL

vs_id int(11) Yes NULL

category varchar(255 Yes Post Natal

)
type varchar(255 Yes Midwife Orders Sheet
)

active varchar(100 Yes active

)

Table 11. new_born

Column Type Null Default

id int(11) No
user_id int(11) No

baby_name varchar(50) No
bed_number int(11) No
birth_date date No
birth_time time No
gestation_age int(11) No
sex enum('male' No
, 'female')
nationality varchar(50) No
ap_score int(11) No
delivery_type varchar(50) No
weight varchar(50) No
height varchar(50) No
head_circum varchar(50) No
chest_circum varchar(50) No
abd_circum varchar(50) No
sig_op varchar(50) No
handled_by varchar(50) No
assisted_by varchar(50) No
category varchar(255 Yes Post Natal
)
type varchar(255 Yes New Born Sheet
)
created_at datetime Yes NULL
del_id int(11) Yes NULL

product_name varchar(255 Yes NULL

)
price decimal(10, 2) Yes NULL

new_created_at datetime Yes NULL

active varchar(100 Yes active
)
philhealth_statu s enum('Mem ber', Yes NULL
'None', '')

app_id int(11) Yes NULL

professionalism int(11) Yes 2
_id

payment varchar(50) Yes Unpaid

address varchar(100 Yes NULL
)
age int(11) Yes NULL
phone_number varchar(50) Yes NULL
email_address varchar(50) Yes NULL
occupation varchar(50) Yes NULL
civil_status varchar(50) Yes NULL
partner_name varchar(50) Yes NULL
partner_contact varchar(20) Yes NULL
partner_addres s varchar(100 Yes NULL
)
mother_name varchar(50) Yes NULL
mother_contact varchar(30) Yes NULL
mother_address varchar(100 Yes NULL
)
disposition varchar(20) Yes NULL
number_days int(11) Yes NULL
discharge_date date Yes NULL

Table 12. new_midwife_notes

Column Type Null Default

id int(11) No
user_id int(11) No

presentation varchar(255 No
)
aog int(11) No
tag_made varchar(255 No
)
gravida varchar(255 No
)
para varchar(255 No
)
abortion varchar(255 No
)
remarks text No
created_at timestamp No current_tim estamp()

category varchar(255 Yes Post Natal

)
type varchar(255 Yes New Born Midwife
) Notes

active varchar(100 Yes active

)
app_id int(11) Yes NULL

Table 13. notification

Column Type Null Default

id int(11) No
user_id int(11) No

type enum('Appr oved', Yes NULL

'Resc heduled',
'Cancelled')

message varchar(255 No
)
is_read tinyint(1) Yes 0
created_at timestamp No current_tim estamp()

Table 14. Pap_smear

Column Type Null Default

id int(11) No
user_id int(11) No

age int(11) Yes NULL

address varchar(255 Yes NULL
)
phone_num varchar(15) Yes NULL
occupation varchar(100 Yes NULL
)
company varchar(100 Yes NULL
)
email_add varchar(100 Yes NULL
)
work_add varchar(255 Yes NULL
)
work_no varchar(15) Yes NULL
husband varchar(100 Yes NULL
)
menarche int(11) Yes NULL
menopause varchar(10) Yes NULL
pmp varchar(10) Yes NULL
lasting varchar(50) Yes NULL
amount varchar(50) Yes NULL
menstrual varchar(50) Yes NULL
sexual_act varchar(50) Yes NULL
methods varchar(255 Yes NULL
)
g varchar(10) Yes NULL
p varchar(10) Yes NULL
lmp varchar(10) Yes NULL
edd varchar(10) Yes NULL
hpv varchar(50) Yes NULL
last_pap varchar(50) Yes NULL
others text Yes NULL
blood varchar(10) Yes NULL
allergy varchar(100 Yes NULL
)
asthma varchar(100 Yes NULL
)
complaint_date date Yes NULL
complaints varchar(255 Yes NULL
)
treatment varchar(255 Yes NULL
)
status varchar(20) Yes pending
category varchar(255 Yes PAP Smear
)
type varchar(255 Yes PAP Smear
)
created_at timestamp No current_tim estamp()

menstrual_patt ern enum('regul ar', No

'irregular')

active varchar(100 Yes active

)
app_id int(11) Yes NULL

Table 15. patient_details

Column Type Null Default

id int(11) No
user_id int(11) No

prod_id int(11) Yes NULL

fam_id int(11) Yes NULL

product_name varchar(100 Yes NULL

)
price decimal(10, 2) Yes NULL

education varchar(255 No
)
occupation varchar(255 No
)
contact_num varchar(20) No
civil_status varchar(50) No
religion varchar(100 No
)
spouse_name varchar(255 No
)
spouse_birth date No
spouse_educati on varchar(255 No
)
spouse_occupat ion varchar(255 No
)
no_children int(11) No
plan_more_child ren enum('yes', No
'no')
avg_monthly_in come varchar(100 No
)
type_of_client varchar(100 No
)
prev_methods varchar(100 Yes for current user only
)
created_at datetime Yes NULL
category varchar(255 Yes Family Planning
)
type varchar(255 Yes Family Planning
)
is_archived enum('activ e', Yes active
'archived')

new_created_at datetime Yes NULL

philhealth_statu s enum('Mem ber', Yes NULL
'None')
medical_history varchar(255 Yes NULL
)
pregnancies int(11) Yes 0
last_delivery date Yes NULL
pregnancy_outc omes enum('full- term', Yes NULL
'premature', 'abortion',
'li ving- children')

last_period date Yes NULL

previous_period date Yes NULL
menstrual_flow enum('scant y', Yes NULL
'moderate', 'heavy',
'dys menorrhea',
'hydatidifor m-mole',
'hi story-of-ect opic-
pregnancy')

genital_dischar ge enum('yes', Yes no

'no')
genital_area varchar(255 Yes NULL
)
sores_ulcers enum('yes', Yes no
'no')
burning_sensati on enum('yes', Yes no
'no')
treatment_histo ry enum('yes', Yes no
'no')
hiv_aids enum('yes', Yes no
'no')
unpleasant_rela tionship enum('yes', Yes no
'no')
partner_approv al enum('yes', Yes no
'no')
domestic_violen ce enum('yes', Yes no
'no')
referred_to enum('dswd ', 'wcpu', Yes NULL
'ngos',
'others')

referred_to_oth er varchar(255 Yes NULL

)
weight float Yes NULL
height float Yes NULL
blood_pressure varchar(20) Yes NULL
pulse_rate smallint(6) Yes NULL
skin varchar(100 Yes NULL
)
conjunctiva varchar(100 Yes NULL
)
neck varchar(100 Yes NULL
)
breast varchar(100 Yes NULL
)
abdomen varchar(100 Yes NULL
)
extremities varchar(100 Yes NULL
)
pelvic_exam varchar(100 Yes NULL
)
pelvic_cervical varchar(100 Yes NULL
)
pelvic_abnorma lities varchar(255 Yes NULL
)
delivery_type enum('vagin al', Yes NULL
'cesarea n-section')

app_id int(11) Yes NULL

professionalism int(11) Yes 2
_id

payment varchar(100 Yes Unpaid

)
Table 16. physical_exam
Column Type Null Default

id int(11) No
case_number varchar(20) No
address varchar(255 No
)
date_of_admissi on date No

bp varchar(50) No
cr varchar(50) No
rr varchar(50) No
temp varchar(50) No
weight varchar(50) No
height varchar(50) No
hent varchar(255 No
)
breast varchar(255 No
)
chest varchar(255 No
)
abdomen varchar(255 No
)
fundic_height varchar(50) No
fetal_heart_ton e varchar(50) No

presentation varchar(255 No
)
prenium varchar(50) No
ie varchar(50) No
dilatation varchar(50) No
effacement varchar(50) No
bow varchar(50) No
intact_rupture varchar(50) No
attending_midw ife varchar(255 No
)
payment_type varchar(255 Yes NULL
)
amount int(11) Yes NULL
status varchar(255 Yes Pending
)
image_path varchar(255 Yes NULL
)
category varchar(255 Yes Pre Natal
)
type varchar(255 Yes Physical Examination
)
user_id int(11) No

active varchar(10) Yes active

app_id int(11) Yes NULL

Table 17. pre_service

Column Type Null Default

id int(11) No
service_name varchar(255 No
)
cost decimal(10, 2) No

Table 18. professionalism

Column Type Null Default

id int(11) No
service_name varchar(100 Yes NULL
)
cost decimal(10, 2) Yes NULL

Table 19. records

Column Type Null Default

id int(11) No
name varchar(255 No
)

status varchar(50) Yes NULL

report_type varchar(100 No
)

created_at timestamp No current_tim estamp()

updated_at timestamp No current_tim estamp()

archived_at timestamp Yes NULL

is_archived enum('activ e', Yes archived

'archived')

user_id int(11) Yes NULL

Table 20. trash_delivery

Column Type Null Default

id int(11) No
newborn_id int(11) Yes NULL

nbmn_id int(11) Yes NULL

vital_id int(11) Yes NULL

baby_id int(11) Yes NULL

order_id int(11) Yes NULL

form_type varchar(255 No
)
first_name varchar(100 Yes NULL
)
last_name varchar(100 Yes NULL
)
category varchar(100 Yes NULL
)
deleted_at timestamp No current_tim estamp()

Table 21. trash_fam

Column Type Null Default

id int(11) No
fam_id int(11) Yes NULL

form_type varchar(255 No
)
first_name varchar(100 Yes NULL
)
last_name varchar(100 Yes NULL
)
category varchar(100 Yes NULL
)
deleted_at timestamp No current_tim estamp()

Table 22. trash_forms

Column Type Null Default

id int(11) No
clinical_id int(11) Yes NULL

high_id int(11) Yes NULL

physical_id int(11) Yes NULL

midwife_id int(11) Yes NULL

doctors_id int(11) Yes NULL

pap_id int(11) Yes NULL

form_type varchar(255 No
)
first_name varchar(100 Yes NULL
)
last_name varchar(100 Yes NULL
)
category varchar(100 Yes NULL
)
deleted_at timestamp No current_tim estamp()
 Table 23. users
Column Type Null Default

user_id int(11) No
first_name varchar(255 No
)
last_name varchar(255 No
)
birth_date date No
email_add varchar(255 Yes NULL
)
address varchar(255 No
)
age int(11) No
username varchar(255 No
)
password varchar(255 No
)
role varchar(50) Yes user
gender varchar(50) No
verification_tok en varchar(255 Yes NULL
)
status enum('unve rified', Yes unverified
'verified')

reset_token varchar(255 Yes NULL

)
reset_expiry datetime Yes NULL
profile_picture varchar(255 Yes NULL
)
category varchar(255 Yes Patient
)
is_archived enum('activ e', Yes active
'archived')

last_email_sent datetime Yes NULL

partner_name varchar(100 Yes NULL
)
partner_age varchar(11) Yes NULL
partner_contact varchar(30) Yes NULL
partner_religion varchar(50) Yes NULL
partner_occupa tion varchar(50) Yes NULL

mother_name varchar(50) Yes NULL

mother_age int(11) Yes NULL
mother_address varchar(50) Yes NULL
mother_contact varchar(50) Yes NULL
father_name varchar(50) Yes NULL
father_age int(11) Yes NULL
father_address varchar(50) Yes NULL
father_contact varchar(50) Yes NULL
work_add varchar(50) Yes NULL
phone_num varchar(20) Yes NULL
user_occupatio n varchar(50) Yes NULL

user_religion varchar(50) Yes NULL

civil_status varchar(20) Yes NULL
educ_attain varchar(100 Yes NULL
)
company varchar(100 Yes NULL
)
work_contact varchar(15) Yes NULL
partner_educati on varchar(20) Yes NULL

partner_birth date Yes NULL

birth_place varchar(100 Yes NULL
)
transaction_typ e varchar(100 Yes NULL
)
partner_add varchar(20) Yes NULL
created_at datetime Yes current_tim estamp()

Table 24. user_app

Column Type Null Default

user_id int(11) No

appointment_ty pe varchar(100 No
)
patient_name varchar(100 No
)
preferred_time varchar(20) No

status varchar(50) Yes Pending

preferred_date date No
reason varchar(200 No
)
doctor varchar(100 No
)
created_at timestamp No current_tim estamp()

app_id int(11) No

appointment_id varchar(10) No
secondary_stat us varchar(50) Yes NULL

rescheduled_by enum('user', Yes NULL

'admin')
attendance_stat us enum('Upco ming', Yes Upcoming
'Attended', 'Not
Attended', 'Cancelled')

Table 25. vital_sign

Column Type Null Default

id int(11) No
user_id int(11) No

case_number int(11) No

date date Yes NULL

time time No
bp varchar(10) Yes NULL

cry varchar(10) Yes NULL

suck varchar(10) Yes NULL
skin_color varchar(10) Yes NULL

temp varchar(10) Yes NULL

cr varchar(10) Yes NULL
rr varchar(10) Yes NULL

category varchar(255 Yes Post Natal

)
type varchar(255 Yes Vital Signs
)
batch_id varchar(255 No
)
active varchar(100 Yes active
)

Table 26. vital_signs_history

Column Type Null Default

history_id int(11) No

vital_id int(11) Yes NULL

history_date date Yes NULL

history_time time Yes NULL

history_bp varchar(50) Yes NULL

history_cry varchar(50) Yes NULL

history_suck varchar(50) Yes NULL

history_skin_col or varchar(50) Yes NULL

history_temp varchar(50) Yes NULL

history_cr varchar(50) Yes NULL

history_rr varchar(50) Yes NULL