Standard Entity Relationship Diagram
Use immediately

Standard Entity Relationship Diagram

tblCATEGORIES

PK

category_id

category_name

category_description

category_type

tblCONTACT_CAT

PK

contact_cat_id

FK1

FK2

FK3

category_id

contact_id project_hr_id

tblCONTACTS

PK

contact_id

FK1

contact_email_type_id

tblTYPE

PK

type_id

type_name

tblEQUIP_CAT

PK

equip_cat_id

FK1

FK2

category_id

equipment_id

tblCALENDAR

PK

calendar_id

FK1

FK2

calendar_date

project_hr_id

project_equip_id

invoice_id

calendar_date_confirmed

tblPROJECT_HR

PK

project_hr_id

FK1

project_id

project_testimonial

tblPROJECTS

PK

project_id

FK1

project_name

project_description

project_start_date

project_end_date

project_owner_id

contact_id

tblEQUIPMENT

PK

equipment_id

FK1

equipment_name

equipment_description

equipment_status_id

status_id

tblEQUIP_HIRE_RATES

PK

equip_hire_rate_id

FK1

FK2

equipment_id

hire_rate_id

tblPROJECT_EQUIPMENT

PK

project_equip_id

FK1

FK2

project_id

equipment_id

proj_equip_booking_rate

tblSTATUS

PK

status_id

FK1

status_name

status_notes

tblHIRE_RATES

PK

hire_rate_id

hire_rate_rate

hire_rate_period

Standard Entity Relationship Diagram

8
0
0
publish time: 2021-09-22
Viro

An Entity Relationship Diagram is a visual representation of how several entities exist in a system and their relationship with one another. A standard ER diagram shows department ids and their relationship with other service providers within the same industry.

See More Related Templates

ER Diagram from Dilshan
This is an ER diagram that I made, hope you can like it!
ER Diagram from Dilshan
23
0
0
DILSHAN SACHINDRA