Pay
Booking Equipment System ER Diagram

Booking Equipment System ER Diagram

tbICATEGORIES

PK

category_id

category_name

category_description

category_type

tbIContact_CAT

PK

contact_cat_id


FK1

FK2

FK3

category_id

contact_id

project_hr_id

tbICONTACTS

PK

contact_id



FK1


contact_email

type_id

tbITYPE

PK

type_id




type_name

tbIEQUIP_CAT

PK

equip cat id


FK1

FK2



category_id

equipment_id

tbICALENDAR

PK

calendar_id


FK1

FK2

calendar_date

project_hr_id

project_equip_id

invoice_id

calendar_date_confimed

tbIPROJECT_HR

PK

project hr id


FK1


project_id

project_testimonial

tbIPROJECTS

PK

project_id







FK1

Project_name

project_description

project_start_date

project_end_date

project_owner_id

contact_id

tbIEQUIPMENT

PK

equipment id





FK1

equipment_name

equipment_description

equipment_status_id

status_id

tbIEQUIP_HIRE_RATES

PK

equip_hire_rate_id


FK1

FK2

equipment_id

hire_rate_id

tbIPROJECT_EQUIPMENT

PK

project_equip_id


FK2

FK1

project_id

equipment_id

proj_equip_booking_rate

tbIHIRE_RATES

PK

hire rate id

hire_rate_rate

hire_rate_period

tbISTATUS

PK

status_id

status_name

status_notes

1
0
0
publish time: 2021-06-04
Viro

A booking equipment system is a tool that allows one to reserve individual items in advance to ensure they are available when one needs them. The Entity-Relationship diagram for the booking equipment system streamlines the activities and relationships that all the modules have with one another. Use EdrawMax or EdrawMax Online to create the booking equipment system entity-relationship (ER) diagram to understand the activities and how it works. The below booking equipment system ER model adopts the more realistic view that the actual consists of entities and relationships. It should be noted here that a double line indicates a participation constraint, an arrow from entity set to relationship set indicates a key condition, a thick line indicates bijectivity, an underlined name of an attribute indicates that it is a key.

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
22
0
0
DILSHAN SACHINDRA