how to design db
From: ilochab <ilochab_at_gmail.com>
Date: Mon, 8 Dec 2008 09:42:48 -0800 (PST)
Message-ID: <c2aaf1a4-e2ac-4419-b679-a24207789e87_at_40g2000prx.googlegroups.com>
I'm using sqlite.
Date: Mon, 8 Dec 2008 09:42:48 -0800 (PST)
Message-ID: <c2aaf1a4-e2ac-4419-b679-a24207789e87_at_40g2000prx.googlegroups.com>
I'm using sqlite.
I need a DB that contains:
- a set of general tables
- a variable number of sets of users tables.
The first set is accessed by every-one.
Each of the users' set 'is identical in structure to the others,
I can manage authentication through my application. What I don't know how to do in a suitable way is the design of a group of identical tables repeated for each user.
Could anyone help?
Thanks