This is the beginning of my thoughts about redesigning the SBS web site.
Data Diagram
Views
- Members by state (from map) 3-up grid view.
- Meetings by date
- Special meetings by date
- Meetings by state, city (location)
- Attendees for special meetings
- Member-in-waiting (MIW) list (status=0, meetings=0)
- MIW for how long
- Member status=3 list
- Unapproved meeting reports (status=0)
- Meetings by member
- Non-Members (status=-1) list
- Members achieving 25 for first time (maybe a monthly report)
Special Functions
- Add a new member
- Review members with status=-1 to become regular members
- Meeting_type maintenance
- Cluster maintenance
- State maintenance
- Meeting approval or request for more info
Rules
- To gain a credit, each meeting must be entered separately.
- One credit is given for a meeting unless a special meeting entry exists and is selected. [separate access permission?]
- Pictures will be organized by state, city, and date.
- User pictures go into members directory.
Workflow
Meeting
Member
- Member enters meeting information, attendees, pictures.
- If attendee is not found in members table, ask submitter to try again. [Show list?]
- If submitter says "accept anyway," add new member with status=-1.
- Save entry as unapproved.
Approvers
- Review meeting record.
- If all okay, approve. If not, contact submitter to fix.
Member Moves
- Membership Chair changes member's state.
New Member
Achievement Levels
Meeting Approval
- When meeting is approved, program saves current meeting count and gets new meeting count for each attendee.
- Check count against levels table.
- If the next achievement level has been reached (or exceeded), by this meeting, use text to create an announcement.
- Add announcement to achievements table.
Monthly
- Membership Chair publishes achievements [and clears achievements table?].
Special Meetings
- Webmistress (WM) verifies the settings.
- If special cluster award is to be used, create it and add it to cluster table.
- WM enters new record in meeting_type table.
Tables
Members
Field |
Type/Length |
Index |
Description |
bid |
autonumber |
primary |
member number |
first_name |
string/50 |
yes |
member's first name |
last_name |
string/50 |
yes |
member's last name |
state |
pointer |
yes |
to state table |
picture |
pointer |
no |
to files |
contact |
email address |
no? |
used on member page |
website |
url |
no |
member's web site url, used on member page |
create_date |
date |
no |
date member added |
Attendees
Comment: linking table between members and meetings
Field |
Type/Length |
Index |
Description |
aid |
autonumber |
primary |
attendee id |
mid |
pointer |
yes |
to meetings table |
bid |
pointer |
yes |
to members table |
Meetings
Field |
Type/Length |
Index |
Description |
mid |
autonumber |
primary |
meeting number |
type |
pointer |
no? |
to meeting_type table |
location |
pointer |
yes |
to location table |
date |
date |
yes |
date of the meeting |
summary |
long string |
no |
summary of the meeting |
status |
boolean |
no |
whether the meeting has been approved |
Meeting_Type
Comment: contains additional information about meetings
Field |
Type/Length |
Index |
Description |
tid |
autonumber |
primary |
type id |
name |
string/50 |
no |
they name of the type of meeting |
cluster |
pointer |
no |
to cluster table |
award |
integer/small |
no |
how many meeting credits to award for this type of meeting |
Pictures
Comment: linking table between meetings and pictures
Field |
Type/Length |
Index |
Description |
pid |
autonumber |
primary |
to files |
mid |
pointer |
yes |
to meetings table |
filename |
string/255 |
no |
name of file where picture is stored |
Location
Comment: table about meeting locations
Field |
Type/Length |
Index |
Description |
lid |
autonumber |
primary |
location id |
city |
string/100 |
yes / with state |
name of the city where the meeting was held |
state |
pointer |
yes / with city |
to state table |
State
Field |
Type/Length |
Index |
Description |
state |
string/50 |
primary |
name of the state or country |
Levels
Comment: used to produce achievement announcements
Field |
Type/Length |
Index |
Description |
level |
integer/small |
primary |
number of meetings attended |
text |
string/255 |
no |
text for achievements announcement |
Achievements
Comment: text of announcments to be published by webmistress
Field |
Type/Length |
Index |
Description |
id |
autonumber |
primary |
achievement id |
text |
string/255 |
no |
message to be published |
Potential Modules
- CCK<
- Contemplate
- Views
- Events
- Minutes?
- Actions
- Image
- Image Upload
- Image Path
- Organic Groups
- Location / Location API
- Date API
- MySite/PageBuilder?
Recent comments
11 years 43 weeks ago
11 years 43 weeks ago
12 years 3 weeks ago
12 years 8 weeks ago
12 years 30 weeks ago
12 years 41 weeks ago
12 years 47 weeks ago
12 years 48 weeks ago
13 years 1 week ago
13 years 5 weeks ago