Difference between revisions of "Member Directory:2011 Spring:UML Class Diagram"

From Openitware
Jump to: navigation, search
m (Relational Model Entities and Attributes Definitions)
(Relational Model Entities and Attributes Definitions)
Line 1: Line 1:
 
==Relational Model Entities and Attributes Definitions==
 
==Relational Model Entities and Attributes Definitions==
====MEMBER COMMITTEE==== - A list of each committee that any Member wishes to belong.
+
====MEMBER COMMITTEE====
 
*'''MemberId''' - MemberId is the composite key that keeps the Member Committee table records unique.
 
*'''MemberId''' - MemberId is the composite key that keeps the Member Committee table records unique.
 
*'''Committee''' - No sure what this one does. Still under construction.
 
*'''Committee''' - No sure what this one does. Still under construction.

Revision as of 13:41, 11 May 2011

Contents

Relational Model Entities and Attributes Definitions

MEMBER COMMITTEE

  • MemberId - MemberId is the composite key that keeps the Member Committee table records unique.
  • Committee - No sure what this one does. Still under construction.

MEMBER

  • MemberId - MemberId is the primary key for the member table. It helps keep duplicate records from happening.
  • ContactID - ContactId is the ID given to the Member who signs up to NHHTC.
  • MemberType - MemberType is the type of status for the Member when they sign up.
  • JoinReason - JoinReason is the Members reason for joining.
  • ReferralInfo - ReferralInfo is the Members referral information.
  • ExpirationDate - ExpirationDate is the date the Membership is out of date.

CONTACT

  • ContactId - ContactId is the unique number given to the contact of the Member.
  • LastName - LastName is the last name of the contact person for the Member.
  • FirstName - FirstName is the first name of the contact person for the Member.
  • Address1 - Address1 is the Member's primary contact address.
  • Address2 - Address2 is the Member's secondary contact address.
  • State - State is the Member's contact state.
  • Zip - Zip is the zip code for the Members contact.
  • Email - Email is the Member's contact email address.
  • Phone - Phone is the primary contact phone number for the Member.
  • Ext - Ext is for the number that the Member can be contacted that uses extensions.
  • Website - Website is the Member's website address.

SECONDARY CONTACT

  • MemberId - MemberId is the composite key for the Other Contact table.
  • ContactId -ContactId is the contact unique number for other contacts for the Member.

INDIVIDUAL MEMBER

  • MemberId - MemberId is the unique number given to Members in this table, it is also a composite key.
  • EmploymentStatus - The Members employment status.

ORGANIZATION MEMBER

  • MemberId - MemberId is the unique number given to the Members in this table, it is also a composite key.
  • TypeId - TypeId is the number given for the type of member the Member is at time of sign up.
  • SalesLevelId - SalesLevelId is the number given to the category of sales the Member makes on a yearly basis.
  • EmploymentStatus - EmploymentStatus is the status of employment for the Member.
  • NumberofEmployees - NumberofEmployees is the number of employees the member currently has employed.

ORGANIZATION TYPE

  • TypeId - TypeId is the unique number given to the type of Member the Member signs up as, at the time of sign up.
  • Name - Name is the name of type of membership.

SALES LEVEL

  • SalesLevelId - SalesLevelId is the unique number given to the amount of sales the Member currently makes yearly.
  • LevelDescription - LevelDescription is the description of the different sales levels for the Member.

MEMBER COMMITTEE

  • MemberId - MemberId is the ID given to the Member at sign up.
  • CommitteeId - CommitteeID is the ID given for the Members Committee at sign up.

COMMITTEE

  • CommitteeId - CommitteeID is the ID given for the Members Committee at sign up.
  • Name - Name is the name of the Committee.

Relational Model Diagram

NHHTC 1.png