Database ERD

Jump to bottom

Joseph Curtis edited this page Apr 18, 2021 · 6 revisions

Entity Relationship Diagram

PERSON

PK_Person_ID
firstname
lastname
username
password_hash
email
role

TEMPLATE

PK_Template_ID
name
temp_subject
temp_body

MESSAGE

PK_Message_ID
FK_FromPerson_ID_from
- (1:1) PERSON sends (0:M) MESSAGE
FK_Template_ID
- (0:1) TEMPLATE constructs (0:M) MESSAGE
subject
textbody
datetime

RECIPIENT

PK_Recipient_ID
FK_ToPerson_ID
- (1:1) PERSON is (0:M) RECIPIENT
FK_Message_ID
- (1:1) MESSAGE has (0:M) RECIPIENT
to_email

Clone this wiki locally