Member Directory:2011 Spring:UML Class Diagram

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

Jump to: navigation, search

Contents

Relational Model Entities and Attributes Definitions

MEMBER COMMITTEE

  • MEMBER COMMITEE - A listing of each committee that any Member wishes to belong.
  • 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

  • MEMBER - An organization or an individual whom has paid and is current with all NHHTC member fees.
  • 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

  • CONTACT - A person that which represents either an Individual’s or an Organization’s behalf, and to whom NHHTC can contact regarding member services.
  • 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

  • SECONDARY CONTACT - A person for whom a member contact has designated to be an additional point of contact for NHHTC.
  • 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

  • INDIVIDUAL MEMBER - A type of Member that wishes to have himself or herself (and not the organization to which he/she works) affiliated with NHHTC services.
  • 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

  • ORGANIZATION MEMBER - A non-profit or for-profit institution that has a desire to belong on the NHHTC directory.
  • 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

  • ORGANIZATION TYPE - A characterization of an Organization, I.E. telecommunications, agriculture, legal, education, etc..
  • 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

  • SALES LEVEL - The amount, in dollars, of annual sales, indicated by levels of less than $1 million, less than $5 million, less than $10 million, and greater than $10 million.
  • 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

  • MEMBER COMMITTEE - A list of each committee that any Member wishes to belong.
  • 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

  • COMMITTEE - The names of available committees of NHHTC.
  • 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