Morning requirements
Data Requirements: Meetings Schedule: place, time, Date,speakers, subject, duration, Meeting minutes: participants (all the above), minutes, Topics to Follow up, results, Meetup: meetup place, time, Date, participants, speakers, subject, duration, contact, post date, member who posted Members: MemberId, name, email, member since, leadership role Posting: event Resources and Tutorials: member who posted, Post date, subject, URL, description, rating General Announcements: who posted, topic, Date Posted, Text Discussion Board: Topic, who posted, discussion, comments Login information-- Report inappropriate data--member reporting, post id, what is inappropriate, reviewed by, date, discussion Reporting Requirements Users: Officers, Members, public, Database Admin Views do you need--security Members, email list, List events, Upcoming events, history of events List of meetings with minutes List of Resources List of Analytics Advertizing Security Officers : what can they do Post meetings, Add members, Delete members, remove posts, post minutes, Post events, post resources, discussions Post meet ups, (Insert, update and delete in any table) Manage member interactions to keep them legal and civil View anything Roles members: Post events, discussion, announcements, add resources Edit their own posts, but no one elses view anything (question on member names and emails) member has option to make email public or not Members can report inappropriate content, only view own reports and discussion Non members View most things, not member emails, not reports on inappropriate material.
Afternoon list
Data Requirements: Meetings: time, location, subject, speaker, Date, RSVP, Description, email, Minutes: who attended, questions, Recap, comments,start and end time of meeting, Date time for post, Who posted it Members: names, emails, phone, Whether or not they is an officer, Category, date added Discussion or blog: date, time, topic, Text of blog, member who posted, comments, title, Public comment --registration Events, Presentations: time, Date, location, (city state zip), speaker, contact about, what member posted, topic, Description, fee, age restriction, sponsor. signup sheet Announcements: date time topic member who posted, content, appropriate: flag announcements, events, member who objects and reason for objecting which announcement or event or other. Resources name, url, date and time posted, Who posted it, comments, who posted it, rating List of persons who express interest in the club ( Stake holders: Members Officers Web site developers-- Public Database Admin Reporting Requirements Track members Calendar of events See who joined recently See meetings and minutes List of resources sorted by rating Contacts report Security Officers What permissions should they have (roles) Add remove members, Add remove most anything, change updating most everything, (probably through stored procedures) Select anything and veiw anything. members: add resources, add blog entries, discussions, events, Update what they post, but nothing else. Remove, but store Public view most things, view member (no, flag it yes or no)
No comments:
Post a Comment