Skip to content

Instantly share code, notes, and snippets.

@rveitch
Created October 6, 2021 21:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rveitch/846490797890b98a6d49002837a061bf to your computer and use it in GitHub Desktop.
Save rveitch/846490797890b98a6d49002837a061bf to your computer and use it in GitHub Desktop.
ShipLog
classDiagram
	class Organization
	class Team
		Team: +int organizationId
		Team: +array LabelsText
    class User
	    User: +int teamId
	class Repo
		Repo: +int organizationId
	class PullRequest
		PullRequest: +int organizationId
		PullRequest: +int repoId
		PullRequest: +int userId
		PullRequest: +int teamId
    class Issue
	    Issue: +int organizationId
		Issue: +int repoId
		Issue: +int userId
		Issue: +int teamId
		Issue: +int pullRequestId
	class Label
		Label: +int organizationId
		Label: +int repoId
	Organization --|> Team: organizationId
	Organization --|> Repo: organizationId
	Team --|> User: teamId
	Repo --|> Label: repoId
	Repo --|> PullRequest: repoId
	User --|> PullRequest: userId
	Team --|> PullRequest: teamId
	Repo --|> Issue: repoId
	User --|> Issue: userId
	Team --|> Issue: teamID
	PullRequest --|> Issue: pullRequestId
	Label --|> PullRequest: labelIds
	Label --|> Issue: labelIds

orgs: question repos :question


teams users (many) labels

pullRequests issues

Foreign Key: user.team_id

Link/Junction Table: team_member_users: { team_id: user_id }

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment