On Mar 30, 2013, at 3:38, Modulok wrote:
> List,
>
> I have a data modeling problem. That much, I know. The question is how do I
> model this? (Below.)
>
> I'm making a database which will store pseudo-genetic data. It's a basic
> many-to-many setup::
>
>create table person(
>name
Hi,
If I have understood well
You have two options:
1. Person_gene (person_id pk, gene_id int)
Genes (gene_id serial pk, gene_type int)
Then for each gene_type separate table with gene_id int what is pk and
relates to genes... And other columns what describe that type...
Person_
> Everything should have an id, and combination tables like person-gene should
> have the person id + the gene id.
> You might look at this tool to make your life easier:
> https://github.com/pgmodeler/pgmodeler
>
> First, read up on this:
> http://en.wikipedia.org/wiki/Entity%E2%80%93relationship_
, March 29, 2013 11:45 PM
To: 'Modulok'; pgsql-general@postgresql.org
Subject: RE: [GENERAL] data modeling genes and alleles... help!
Everything should have an id, and combination tables like person-gene should
have the person id + the gene id.
You might look at this tool to make your l
, it will be obvious how to use the tool.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Modulok
Sent: Friday, March 29, 2013 7:39 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] data modeling genes and alleles
List,
I have a data modeling problem. That much, I know. The question is how do I
model this? (Below.)
I'm making a database which will store pseudo-genetic data. It's a basic
many-to-many setup::
create table person(
name varchar(32) primary key
);
create table gene(
