erDiagram
    POLICY {
        PeoplePostedTo String
        AmountOfAgreements Int32
        DepartmentsPostedTo String
        Id Guid
        Title String
        CompletedBy DateTimeOffset
    }
    POLLVOTE {
        VotedOptionOrder Int32
        VotedDateTime DateTimeOffset
        VotedOption String
        PollId Guid
        VotedBy String
        Id Guid
    }
    POLLOPTION {
        PollId Guid
        OptionOrder Int32
        Votes Int32
        Id Guid
        OptionText String
        VotesPercentage Double
    }
    POLL {
        PostedBy String
        ClosingDateTime DateTimeOffset
        PeoplePostedTo String
        TotalVotes Int32
        Anonymous String
        DepartmentsPostedTo String
        Id Guid
        PostId Guid
        Title String
        GroupsPostedTo String
    }
    POLICIESAGREEMENT {
        PersonName String
        DateAgreed DateTimeOffset
        PolicyId Guid
        Id Guid
    }
    POST {
        PeoplePostedTo String
        ResourceId Guid
        LastModifiedDateTime DateTimeOffset
        CreatedDateTime DateTimeOffset
        DepartmentsPostedTo String
        Description String
        Title String
        Type String
        GroupsPostedTo String
        PostedBy String
        LikesCount Int32
        CommentsCount Int32
        Id Guid
    }
    Resource_Paths {
        policies URL
        posts URL
        policiesAgreements URL
        pollOptions URL
        polls URL
        pollVotes URL
    }
    POLLVOTE o{--|| POLL : Poll
    POLLOPTION o{--|| POLL : Poll
    POLICIESAGREEMENT o{--|| POLICY : Policy