Re: [GENERAL] schemas for organizing tables

2011-04-29 Thread fork
Seb gmail.com> writes: > The database stores information related to biological research. The > bulk of the tables describe things like individual ID, morphometrics, > and behavioural data on all the individuals in several studies. > However, there are a few tables that do not relate to the resea

Re: [GENERAL] schemas for organizing tables

2011-04-28 Thread Alban Hertroys
On 29 Apr 2011, at 5:03, Seb wrote: > So typically we have two types of uses: research and > preparation/logistics for the project. We wouldn't want to even see the > logistcs tables for research work, whereas we would like to see only > these ones for preparation/planning. As the project and nu

Re: [GENERAL] schemas for organizing tables

2011-04-28 Thread Darren Duncan
Seb wrote: Thanks for these thoughts. Perhaps I can describe a cartoon of this database to explain what I'm trying to accomplish. The database stores information related to biological research. The bulk of the tables describe things like individual ID, morphometrics, and behavioural data on al

Re: [GENERAL] schemas for organizing tables

2011-04-28 Thread Seb
On Thu, 28 Apr 2011 19:29:11 -0700, Darren Duncan wrote: > Seb wrote: >> A database I'm handling is becoming a bit large'ish (~ 30 tables), >> and I'd like to break them down into their natural units. Schemas >> for each of these natural units seems logical, but are they really >> meant for this

Re: [GENERAL] schemas for organizing tables

2011-04-28 Thread Darren Duncan
Seb wrote: A database I'm handling is becoming a bit large'ish (~ 30 tables), and I'd like to break them down into their natural units. Schemas for each of these natural units seems logical, but are they really meant for this? I'm also worried about how this would affect programs like Libreoffi

Re: [GENERAL] schemas for organizing tables

2011-04-28 Thread Seb
On Thu, 28 Apr 2011 18:15:05 -0700, John R Pierce wrote: > On 04/28/11 5:51 PM, Seb wrote: >> Hi, >> A database I'm handling is becoming a bit large'ish (~ 30 tables), >> and I'd like to break them down into their natural units. Schemas >> for each of these natural units seems logical, but are

Re: [GENERAL] schemas for organizing tables

2011-04-28 Thread John R Pierce
On 04/28/11 5:51 PM, Seb wrote: Hi, A database I'm handling is becoming a bit large'ish (~ 30 tables), and I'd like to break them down into their natural units. Schemas for each of these natural units seems logical, but are they really meant for this? I'm also worried about how this would affe

[GENERAL] schemas for organizing tables

2011-04-28 Thread Seb
Hi, A database I'm handling is becoming a bit large'ish (~ 30 tables), and I'd like to break them down into their natural units. Schemas for each of these natural units seems logical, but are they really meant for this? I'm also worried about how this would affect programs like Libreoffice (the