database design

virtex

I have a table "account" that stores my users accounts.
Each user may add one or multiple paypals, bank account, credit card, and so on. Let's name the tables "paypalAccount", "bankAccount", "creditcards"

The tricky point is that I need to store their ID's in a column (linkID) of a table (in this case the table "deposits").

What is the best way to link theses tables?

bogu

If the "paypalAccount", "bankAccount" and "deposit" dont have any relations (and I see they dont have) then is ok how u link the tables.

geek_girl_2020

You shouldn't be storing ANY credit card numbers in your database - that is just asking for trouble - if you are using PAY PAL etc then you there is no need to store credit card numbers.

I can't stress enough that storing credit card numbers in your mySQl database - particularly if you are not a unix and mySQL security guru - is a very very bad idea.

virtex

My question is how to link the deposit table to DIFFERENT tables (like the table bankAccounts and so on ).
Because a deposit might be a credit card as well as a bank account...

laserlight

My question is how to link the deposit table to DIFFERENT tables (like the table bankAccounts and so on ).

How are the tables related? What is the relationship type between the tables?

virtex

account and deposit is a 1:n identifiing relationship
deposit and bankAccount / paypalAccount is a 1:1 identifiying relationship

bogu

Your all tables are linked by account_id that should be enough, because all other tables have no relations with each other only with accounts table ...