From: | Michelle Konzack <linux4michelle(at)tamay-dogan(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Redefining an existing Table Schema for Foreign Key Constraint - Question |
Date: | 2008-11-06 21:37:36 |
Message-ID: | 20081106213736.GB25016@tamay-dogan.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hallo Harald,
Am 2008-11-03 13:41:52, schrieb Harald Fuchs:
> In article <20294223(dot)post(at)talk(dot)nabble(dot)com>,
> Brian714 <bndang(at)uci(dot)edu> writes:
> > Customers Table
> > id:integer -- primary key
> > first_name:varchar(50)
> > last_name:varchar(50)
> > cc_id:integer references Creditcards.id
> > address:varchar(200)
> > email:varchar(50)
> > password:varchar(20)
> This is the usual 1:n relationship, but I think you got it backwards.
> There are two questions to ask:
> 1. Are there customers with more than one credit card?
This could be a problem for the above table...
> 2. Are there credit cards owned by more than one customer?
CreditCards are personaly and sometimes (in France) I need an ID card to
prove, that I am the holder...
So how can one credit card can have more then one owner?
Thanks, Greetings and nice Day/Evening
Michelle Konzack
Systemadministrator
24V Electronic Engineer
Tamay Dogan Network
Debian GNU/Linux Consultant
--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack Apt. 917 ICQ #328449886
+49/177/9351947 50, rue de Soultz MSN LinuxMichi
+33/6/61925193 67100 Strasbourg/France IRC #Debian (irc.icq.com)
From | Date | Subject | |
---|---|---|---|
Next Message | Michelle Konzack | 2008-11-06 21:43:18 | How to design a "customer" TABLE which hold credit card infos and other payments? |
Previous Message | Michelle Konzack | 2008-11-06 21:27:07 | Database access over the Internet... |