Field Name Data Field Length Constrain Description

Type t
PhilHealth_ID Integer no field length PRIMARY Unique identifier for PhilHealth
KEY instances.
Name String Max length: NOT Name of the Philippine Health
255 NULL Insurance Corporation.
characters
Address String Max length: NOT Address of PhilHealth
255 NULL headquarters or regional offices.
characters
Supervising_Age Integer no field length FOREIGN Identifier of the government
ncy KEY agency supervising PhilHealth.
Contact_Person String Max length: NOT Name of the contact person for
100 NULL PhilHealth inquiries.
characters
Contact_Number String Max length: NOT Phone number for contacting
20 characters NULL PhilHealth.
Email String Max length: NOT Email address for contacting
100 NULL PhilHealth.
characters
Website String Max length: NOT Official website URL for
255 NULL PhilHealth.
characters

PHILHEALTH

MEMBERS
Field Name Data Field Length Constraint Description
Type
Member_ID Integer no field PRIMARY Unique identifier for member
length KEY instances.
PhilHealth_ID Integer no field FOREIGN Identifier linking members to their
length KEY PhilHealth enrollment.
Name String Max length: NOT NULL Name of the member.
100
characters
Gender Boolean no field ENUM Gender of the member.
length
Date_of_Birth Date no field NOT NULL Date of birth of the member.
length
Civil_Status Boolean no field ENUM Civil status of the member.
length
Address String Max length: NOT NULL Member's residential address.
255
characters
Contact_Number String Max length: NOT NULL Member's contact number.
20
characters
Email String Max length: NOT NULL Member's email address.
100
characters
Date_Joined Date no field NOT NULL Date when the member joined
length PhilHealth.
Employer_ID Integer no field FOREIGN Identifier linking members to their
length KEY employer.
Date_of_Employm Date no field NOT NULL Date when the member started
ent length employment

HEALTHCARE PROVIDERS
Field Name Data Field Length Constraint Description
Type
Provider_ID Integer no field PRIMARY Unique identifier for healthcare
length KEY provider instances.
Name String Max length: NOT NULL Name of the healthcare provider.
255
characters
Type String Max length: NOT NULL Type of healthcare provider.
255
characters
Specialty String Max length: NOT NULL Specialty or focus area of the
255 healthcare provider.
characters
Address String Max length: NOT NULL Address of the healthcare
255 provider.
characters
Contact_Number String Max length: NOT NULL Contact number of the healthcare
20 provider.
characters
Accreditation_St Boolean no field NOT NULL Indicates if the provider is
atus length accredited by PhilHealth.

GOVERNMENT AGENCIES
Field Name Data Field Length Constraint Description
Type
Agency_ID Integer no field PRIMARY Unique identifier for government
length KEY agency instances.
Name String Max length: NOT NULL Name of the government
255 agency,.
characters
Address String Max length: NOT NULL Address of the government
255 agency.
characters
Contact_Person String Max length: NOT NULL Name of the contact person for
100 the government agency.
characters
Contact_Number String Max length: NOT NULL Contact number for the
20 government agency.
characters
Email String Max length: NOT NULL Email address for contacting the
100 government agency.
characters
Website String Max length: NOT NULL Official website URL for the
255 government agency
characters

EMPLOYERS
Field Name Data Field Length Constraint Description
Type
Employer_ID Integer no field PRIMARY Unique identifier for employer
length KEY instances.
Name String Max length: NOT NULL Name of the employer.
255
characters
Industry String Max length: NOT NULL Industry in which the employer
100 operates.
characters
Address String Max length: NOT NULL Address of the employer.
255
characters
Contact_Person String Max length: NOT NULL Name of the contact person for
100 employer inquiries.
characters
Contact_Number String Max length: NOT NULL Contact number for the employer.
20
characters
Email String Max length: NOT NULL Email address for contacting the
100 employer.
characters
Website String Max length: NOT NULL Official website URL for the
255 employer.
characters