Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
programer
Posting Yak Master
221 Posts |
 Posted - 2010-07-30 : 16:49:26
|
| Hi,I work a payment system such as a credit card, Moneybookers, Neteller, etc ...I am interested in suggestions on how would you create a table.All information about payment systems I want to save in one table tbl_DetailsPayment:Currently:tbl_DetailsPayment:Unique UserIdCardId varcharAttributeName varcharValue varcharIn the table "AttributeName", save the data:Credit card numberCredit on meMoneybookersPaypalNetelleretc ...Example:UserId | CardId | AttributeName | Value543534 | 555555 |Credit card num | 32131231231231231543534 | 555555 |name on Credit | jiodsajiodias543534 | 555555 |Moneybookers | dsuiaidasu@gmail.com 543534 | 555555 |Paypal | iodasjidasio@gmail.com 543534 | 555555 |Neteller | iodasjio@gmail.com I ask for suggestions, or the foregoing proposal is good and what would you do this.Thanks |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-08-02 : 19:07:29
|
| whatever you do, keep your data and tables normalized. for any additional help, post your current DLL, table schema and what are you striving for. |
 |
|
|
konark
Yak Posting Veteran
60 Posts |
Posted - 2010-08-02 : 20:25:10
|
| It all depends on the business logic and what the table is meant to contain.Chandragupta MouryaTakhyashila |
|
|
|
fdtoo
Starting Member
28 Posts |
Posted - 2011-01-05 : 22:47:40
|
| Where is your primary key field in tbl_DetailsPayment? You need an identifier. You also need a common field to reference your payment transaction to your customer table and merchant table. Have you determined the type of report you'll need to generate from your payment system? Identify the report requirement and add in the fieldname in your tables. |
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2011-01-06 : 11:39:29
|
quote:
Originally posted by programer
<snip>I ask for suggestions, or the foregoing proposal is good and what would you do this.
From what I understand by your post, I'd have to say that, unfortunately, it's not so good.As Slimt mentioned, you need to learn about normalization (among other things). I doubt a forum is the right place to get you up to speed on all that you need to know. You can probably learn a lot by doing some searching. But, if you really want to learn the fundamental basics you need to start at the classical beginning:http://www.amazon.com/Introduction-Database-Systems-C-Date/dp/0201385902 |
|
|
|
|
|
|
|
|
Table of the payment system.