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.

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,
but it is specific in content respect to the owner.

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

Ciao, Licia. Received on Mon Dec 08 2008 - 18:42:48 CET

Original text of this message