Outbox

OutboxItem
    outbox    OutboxId
    activity  PersistJSONObject
    published UTCTime

Person

Project
    ident      PrjIdent
    sharer     Int64
    name       Text          Maybe
    desc       Text          Maybe
    workflow   Int64
    nextTicket Int
    wiki       RepoId        Maybe
    collabUser RoleId        Maybe
    collabAnon RoleId        Maybe
    inbox      Int64
    outbox     OutboxId
    followers  Int64

Repo
    ident      RpIdent
    sharer     Int64
    vcs        VersionControlSystem
    project    ProjectId            Maybe
    desc       Text                 Maybe
    mainBranch Text
    collabUser RoleId               Maybe
    collabAnon RoleId               Maybe
    inbox      Int64
    outbox     OutboxId
    followers  Int64

Role



Collab



CollabRoleLocal
    collab CollabId
    role   RoleId

    UniqueCollabRoleLocal collab

CollabTopicLocalRepo
    collab CollabId
    repo   RepoId

    UniqueCollabTopicLocalRepo collab

CollabTopicLocalProject
    collab  CollabId
    project ProjectId

    UniqueCollabTopicLocalProject collab



CollabSenderLocal
    collab   CollabId
    activity OutboxItemId

    UniqueCollabSenderLocal collab
    UniqueCollabSenderLocalActivity activity



CollabRecipLocal
    collab CollabId
    person PersonId

    UniqueCollabRecipLocal collab



RepoCollab
    repo   RepoId
    person PersonId
    role   RoleId   Maybe

    UniqueRepoCollab repo person

ProjectCollab
    project ProjectId
    person  PersonId
    role    RoleId    Maybe

    UniqueProjectCollab project person