Design table for withdrawal - SQL Server Forums

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.

All Forums

General SQL Server Forums

Database Design and Application Architecture

Design table for withdrawal

Author

Topic

programer
Posting Yak Master

221 Posts

Posted - 2011-07-26 : 14:55:10

Hi,

I have table tbl_transaction:

SrNo int Unchecked
UserId uniqueidentifier Checked
TransactionAmount decimal(18, 2) Checked
TransactionType int Checked
TransactionDate datetime Checked
TransactionId nvarchar(1000) Checked
Pending bit Checked

and I have tbl_ tbl_BankDetails:

ID int Unchecked
UserId uniqueidentifier Checked
SWIFT nvarchar(30) Checked
IBAN nvarchar(50) Checked
BankName nvarchar(200) Checked
Country nvarchar(100) Checked
AccountOwner nvarchar(200) Checked
Address nvarchar(500) Checked

BankDetails table is to store bank details (SWIFT BANK NAME,...)

Which table I need for stored amount?

I create a new table tbl_withdrawal where store all the pay out (withdrawals)?
Like this:
SWIFT BANK NAME, IBAN, AMOUNT?

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2011-07-31 : 15:09:33

isn't th5s just a combination of data from bankdetails and transaction for a transaction type? Why does it need to be a table.
If needed it could be a view but I would just leave it as it is.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources