Docstoc

TT380 Message Forums

Document Sample
TT380 Message Forums Powered By Docstoc
					    TT380
Message Forums
            Teaching Goals
•   Design case study
•   Minimal learning curve
•   Simple database design
•   Created with ColdFusion 4.5
•   Using MySQL RDBMS
•   Full-text searches
                                                   tblmessagehistory
                               tblroles
                                                  PK,FK1 MessageIDfk
tblannouncementattachments   PK RoleID
                                                  PK,FK2 ThreadIDfk
PK    AttachmentID                 RoleName       PK,FK3 UserIDfk

FK1 AnnouncementIDfk                                       DateRead
    AttachmentSize                                         HasRead
    AttachmentName                                         HasRated
                                     tblusers
    OriginalName                                                                tblthreads           tblconferences
                              PK    UserID
                                                                         PK     ThreadID        PK     ConferenceID
                              FK1 RoleIDfk               tblmessages
      tblannouncements            FirstName                              FK1 ConferenceIDfk     FK1 ConfTypeIDfk
                                  FamilyName        PK    MessageID          MessageCount           ArchiveID
     PK   AnnouncementID
                                  UserEmail                                  FirstMessageIDfk       DateCreated
     FK1 AuthorIDfk               UserNam           FK2 AuthorIDfk           LastPosting            ConferenceName
         DatePosted               UserPwd           FK1 ThreadIDfk           TArchived              Description
         AArchived                PreviousVisit         ParentIDfk           ThreadSubject
         HasAttachment            MsgRating             DatePosted
         MsgSubject               MsgFilter             ReplyLevel
         Content                  EmailHeader           HasAttachment         tblattachments     tblconferencetypes
                                  EmailAnnounce         Rating
                                  BaseFontSize          MArchived        PK     AttachmentID      PK ConfTypeID
                                  FontFamily            MDeleted
                                                        MsgSubject       FK1 MessageIDfk                TypeName
  tblannouncementhistory          UserSig
                                                        Content              AttachmentSize
                                  Photo
PK,FK2 AnnouncementIDfk                                                      AttachmentName
                                  Resume
PK,FK1 UserIDfk                                                              OriginalName

          DateRead
          HasRead                                  tblcuttingsmessages
                                tblcuttings
                                                   PK,FK1 CuttingIDfk
                              PK    CuttingID      PK,FK2 MessageIDfk
                              FK1 UserIDfk                   DateAdded
                                  DatePosted
                                  Topic
      Design Goals (Students)
•   Web-based
•   Everything in a single window
•   Message filtering
•   Message clipping
•   Message recommendations
•   Email announcements
•   Résumés (optional photo)
      Design Goals (Admin)
• Conference management
• User management
• Message management
  – Aging
  – Archiving
• Review student activity
Accessible Conferences
Threads within Conference
Messages within Thread
Selected Message

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:24
posted:4/8/2010
language:English
pages:10