has · 1:N
tagged · M:N
authored by · 0,N:1
Label
idpk
nametext
colortext
Issue
numberpk
titletext
stateenum
author_idfk
PullRequest
numberpk
issue_numfk
stateenum
User
idpk
logintext
roleenum
pk = primary key · fk = foreign key · crow's-foot markers indicate cardinality