Menu

#4 More fields for Member table

open
nobody
None
5
2003-03-14
2003-03-14
Rick Hall
No

Fully implement birthdate (and switch from Date type to
Calendar type)

Add fields for Sex, Height, US Rowing ID.

Think about MembershipCategory (Regular, Junior,
Summer, Fall, Non-Rowing, Newsletter)

CRC column. The CRC would be calculated for all data
within a row of the Member table and any associated
rows within the MemberRole table. A CRC stamp would
allow remote clients (PDA's) to work offline,
synchronize efficiently and resolve update conflicts.

Lock column. The lock column would allow a remote
client to query the database for changes, then lock
specific rows for updates. The lock should be tied to
specific client and should include some sort of
timestamp so that it could expire after a finite amount
of time (e.g. a lock might be a text string like
"timestamp-client"). Look at how other apps (e.g. CVS)
handle updating by remote clients. Speak to Yuri M
about his design for locking.

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.