RE: Foreign Keys

2008-10-08 Thread Ben A. Hilleli
--- >The table has to have a ParentID column (call it what you want) that points, in the case of a >Friend, to the "Friend Of Whom" UserID column -- Not sure what you mean as aren't you describing a 1 to 1 relation? I'll check the site

Normalization / Foreign Key Question

2008-07-14 Thread Ben A. Hilleli
relatively large database with approx 250,000+ users, not all will have referrerIDs, I would wager maybe 1-10% of these people will have been referred. Priorities for us are simplicity/scalability, efficiency (in that order) Ben A. Hilleli Programmer / Analyst

Multi-Language Web Content

2008-07-09 Thread Ben A. Hilleli
Hi, I am in the planning stages of a multi-language web-content & user management system. I may not be here to support this app forever so priority is on maintainability, scalability (pref. by less experienced programmers or laymen) We have a bunch of questionnaire type pages (name, add