Splitting Membership Users Into 3 Groups (Design)

Get Started
1

Hi,

I am trying to build a site in which people can join but there are 3 different membership categories. For example, it might teacher, student, parent. I am struggling to come up with a free flowing design which is also functional.

Does anyone have any suggestions or can think of any examples of sites that do this?

2

You could do this.

tblMemberType

fldID (Primary Key)
fldMemberType

tblMembers

fldID (PK)
fldFname
fldLname
fldType (FK)

where fldType is a Foreign Key (FK) linked to the tblMemberType’s fldID (PK)

Add records for each member type in tblMemberType and then assign the appropriate member type ID to each member’s record in tblMembers.

3

You’ll also want to have:

Group Permissions: Stores what each group is and isn’t allowed to do and/or access
Permissions: Stores each permissible action
Group Membership: Stores who is a member of what groups(s), one entry for each group that a user is a member of