From: | "Kevin Crenshaw" <kcrenshaw(at)tiewireinc(dot)com> |
---|---|
To: | <operationsengineer1(at)yahoo(dot)com> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Revision Control |
Date: | 2005-02-16 13:54:32 |
Message-ID: | D8439C286CD66D4EBD89F853EBCE6E210F7A8F@ccs1.tiewireinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I'm no DB guru, but on the projects that I've worked on in the past,
this approach has served me well. I have also seen it recommended in my
reference books for managing users and groups ie...
Table1: Users
Table2: Groups
Table3: UsersGroups
HTH,
kevin
-----Original Message-----
From: operationsengineer1(at)yahoo(dot)com
[mailto:operationsengineer1(at)yahoo(dot)com]
Sent: Tuesday, February 15, 2005 10:14 AM
To: Mike G.; Deepblues
Cc: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] Revision Control
i'm working with data that requires revisions.
the easiest way to think about it is a product by
revision. for example,
product A, rev 1
product A, rev 2
product A, rev 3
where is revision is potentially a viable product to
some customer. iow, customer blue may order product
A, rev 3 and customer green may want product A, rev 1.
i have put some thought into this and developed the
following scheme...
three tables (T=table, C=column in table, PK=primary
key, FK=foreign key):
T product_base
C PK product_base_id
C product_number
C product_name
C product_description
T revision
C PK revision_id
C revision_number
C revision_description
T product_revision
C PK product_revision_id
C FK product_base_id
C FK revision_id
does this seem like a reasonable approach to solving
this problem? please let me know if you have a better
approach or more information to improve this approach.
__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
From | Date | Subject | |
---|---|---|---|
Next Message | Keith Worthington | 2005-02-16 16:47:46 | CASTING in JOIN or WHERE |
Previous Message | brew | 2005-02-16 07:07:03 | Re: Revision Control |