How to design a "customer" TABLE which hold credit card infos and other payments?

From: Michelle Konzack <linux4michelle(at)tamay-dogan(dot)net>
To: pgSQL - General <pgsql-general(at)postgresql(dot)org>
Subject: How to design a "customer" TABLE which hold credit card infos and other payments?
Date: 2008-11-06 21:43:18
Message-ID: 20081106214318.GC25016@tamay-dogan.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

************************************************************************
* Do not Cc: me, because I READ THIS LIST, if I write here *
* Keine Cc: am mich, ich LESE DIESE LISTE wenn ich hier schreibe *
************************************************************************

Hello,

I am coding a new OnlineStore (the existing ones fit not my needs, are
to complicate to use or simply closed source and too expensive e.g.
InterShop) with an integrated powerful ledger.

So now it comes to infos about Credit Cards, PayPal and friends...

Does someone have an experience with it

1) how I should store it
2) how the TABLE fields should look like

And yes, I would use a reference to external tables instead of puting
those data in the main "customer" TABLE...

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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brent Wood 2008-11-06 22:09:49 Defining string to represent null values in select
Previous Message Michelle Konzack 2008-11-06 21:37:36 Re: Redefining an existing Table Schema for Foreign Key Constraint - Question