Member Directory:2011 Spring:UML Class Diagram

From Openitware
Revision as of 13:41, 11 May 2011 by Callahan82 (Talk | contribs)

Jump to: navigation, search

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