Examples
Here are some examples of entity relationship diagrams (ERDs) you can create in Eraser:
Chat App
users {
id string pk
displayName string
team_role string
teams string
}
teams {
id string pk
name string
}
workspaces {
id string
createdAt timestamp
folderId string
teamId string
}
folders {
id string
name string
}
chat {
duration number
startedAt timestamp
endedAt timestamp
workspaceId string
}
invite {
inviteId string
type string
workspaceId string
inviterId string
}
users.teams <> teams.id
workspaces.folderId > folders.id
workspaces.teamId > teams.id
chat.workspaceId > workspaces.id
invite.workspaceId > workspaces.id
invite.inviterId > users.id
Open in Eraser to duplicate.

Calendar Booking App
User {
id Int pk
username String
email String
avatar String
createdDate DateTime
}
Booking {
id Int pk
userId Int
eventtType eventtType
title String
startTime DateTime
endTime DateTime
location String
eventTypeId Int
destinationCalendarId Int
}
EventType {
id Int pk
userId Int
teamId Int
hidden Boolean
length Int
}
ApiKey {
id String pk
userId Int
appId String
hashedKey String
}
App {
slug String
dirName String
keys Json
createdAt DateTime
}
Webhook {
id String pk
userId Int
appId String
eventTypeId Int
active Boolean
}
DestinationCalender {
id Int pk
userId Int
integration String
eventTypeId Int
}
Booking.eventtType < EventType.id
Webhook.appId > App.slug
Webhook.userId > User.id
Webhook.eventTypeId > EventType.id
App.slug > ApiKey.appId
User.id < Booking.userId
EventType.userId <> User.id
User.id > ApiKey.userId
DestinationCalender.id > Booking.destinationCalendarId
DestinationCalender.userId < User.id
DestinationCalender.eventTypeId < EventType.id
Open in Eraser to duplicate.

Form Builder App
User {
id Int
firstname String
lastname String
email String
emailVerified DateTime
}
Form {
id String
ownerId Int
name String
formType FormType
createdAt DateTime
}
Pipeline {
id String
name String
formId String
events PipelineEvent
createdAt DateTime
}
SessionEvent {
id String
submissionSessionId String
type String
createdAt DateTime
}
SubmissionSession {
id String
formId String
createdAt DateTime
}
NoCodeForm {
id String
published Boolean
closed Boolean
formId String
}
User.id < Form.ownerId
Form.id < Pipeline.formId
Form.id < SubmissionSession.formId
Form.id < NoCodeForm.formId
SubmissionSession.id < SessionEvent.submissionSessionId
Open in Eraser to duplicate.

Updated 5 months ago