[Wplug-web] Stuff I Wrote at the Meeting

[Robert Dale]

On Sat, 24 Mar 2001, Evan DiBiase wrote:

WPLUG-Web Meeting Notes
Faithfully Transcribed by FlipEvan


To-Do (Wishlist)
----------------
wplug.org look/feel for mailman
wplug.org intercept for mailman (wplug.org frontend, mailman backend)
Limited members personal information page
	Screenshots
	Bio
	Picture
News
	Expire dates
	If no relevant events, display last three news items

------------------------------------------------------------------------------

Event table
       Name
       Location_id -> references location table location_id
       Date
       event_id | serial primary key
       minutes_id -> references minutes table minutes_id
       contact_id -> references user table user_id
       topic
       event_type_id -> references event_type table event_type_id

event_type table
	    event_type_id
	    event_type_name

Location table
	 Address
	 City
	 State
	 Zip
	 Phone number
	 Directions
	 Map
	 User_id -> References user_id in other table
	 Location_id | serial primary key


Minutes
	Author -> references user table user_id
	Attendees
	minutes_id | serial primary key
	Subject
	Body

User table
     user_id
     First_name
     Last_name
     email
     password
     url
     home_phone
     work_phone
     city
     state
     preference_id -> references preference table preference_id
     

Confirm table
	confirm_id
	user_id -> references from user table user_id
	hash
	expire_date

Presentation table
	  presentation_id
	  user_id -> references from user table user_id
	  topic
	  presentation_url
	  
events_presentation_map table
		     presentation_id -> references presentation table presentation_id
		     event_id -> references event table event_id

session table
	session_id
	session_hash
	ip_addr
	user_id -> references users table user_id
	expire_time

news table
     news_id
     date
     expire_date
     topic
     user_id -> references users table user_id
     event_type_id -> references event_type table event_type_id
     body

------------------------------------------------------------------------
Coding Style|
------------
- Uses engines like RIMPS
- Forms are their own entities  
-- 
Robert Dale

wplug member since 1998