[Index] of Committee Reports
[1/10/01 DB Wish List Spec] [1/19/01 Committee Report & DB Tables]

Web Site Development Committee Meeting Report
from meeting held on 1/19/06

Volunteers met at Casey Rodgers house for the second meeting of the Web Site Development Committee
Present were:
Casey Rodgers,  IS Director
Tom Truax
Tom Beidler

The wish list was reviewed
Capability, Economics, and Strategy were discussed

Conclusions:
Casey will build the data base and Tom Beidler will work on the ASP web connection

Access to some query pages would require log in
Registration required prior successful log in
Log in with Last Name & USHGA Number
Log in as Non Member, Member, or Administrator
Permission to access some query pages would depend on log in category
Optional password input required to access pages that edit member info

I'm not clear weather validation and defaults would be handled by the Data Base or the Web Forms
Still not clear on validation of Priorities

The Data Base would initially contain 6 Tables as follows

Table Name	Relationships
Member	One to One	Admin
	One to Many	Address	Phone	Email	Payments
Address	Many to One	Members
Phone	Many to One	Members
E-mail	Many to One	Members
Admin	One to One	Members
Payments	Many to One	Members
Activity Calendar ?	Future addition

Member Table
Field	Required	Default	Unique	Data Type	Validation
USHGA Number	Yes		Yes	Integer	5 digits
Last Name	Yes		No	Text	< 1 character, alphabet only
First Name	Yes		No	Text	< 1 character, alphabet only
Birth Date	No	Null	No	Date
Sex	No	Null		Boolean
Password	No	Null	No	Text	< 10 characters
Public Viewing	No	Yes		Boolean
Member Viewing	No	Yes		Boolean
USHGA Exp Date	Yes		No	Date
Comments / News	No	Null	No	Multi-Line Text Box
Last Edit Date	Auto			Date

Address Table
Field	Required	Default	Unique	Data Type	Validation
Unique ID	Auto		Yes	Default
USHGA Number	Auto	Look Up	No	Integer
Address Line 1	Yes		No	Text	> 5 characters
Address Line 2	No		No	Text
City	Yes		No	Text	> 1 character,  alphabet only
State	Yes	CA	No	Text	2 characters, alphabet only
Zip Code	Yes		No	Integer	5 digits
Comments	No	Null	No	One Line Text Box
Public Viewing	No	Yes		Boolean
Member Viewing	No	Yes		Boolean
Priority	No	1	to ID?	Integer ?

Phone Table
Field	Required	Default	Unique	Data Type	Validation
USHGA Number	Auto	Look Up	Each No Yes Group	Integer	5 Digits
Area Code	Yes	805		Integer	3 Digits
Phone Number	Yes			Text	xxx-xxxx
Extension	No			Text
Type	No		No	Select from Drop down list or Type in other	< 21 Characters
Comments	No		No	One Line Text Box
Public Viewing	No	Yes		Boolean
Member Viewing	No	Yes		Boolean
Priority	No	1	to ID?	Integer ?

Email Address Table
Field	Required	Default	Unique	Data Type	Validation
USHGA Number	Auto	Look Up	Yes	Integer	5 Digits
Email	Yes			One Line Text Box	< 60 characters
Comments	No		No	One Line Text Box
Public Viewing	No	Yes		Boolean
Member Viewing	No	Yes		Boolean
Priority	No	1	to ID?	Integer ?

Admin Table
Field	Required	Default	Unique	Data Type	Validation	Notes
USHGA Number	Auto	Look Up	Yes	Integer	5 Digits
SCPA Member	Yes	No		Boolean		All Current  & Non-Current Members
Current Member	Yes	No		Boolean		Dues Current
Administrator	Yes	No		Boolean

Payments Table
Field	Required	Default	Unique	Data Type	Validation
USHGA Number	Auto	Look Up	Yes	Integer	5 Digits
Payment Date	Yes		No	Date
Payment Amount	Yes		No	Currency
Payment Method	Yes		No	Text	> 1 Character