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
 tables structure

Author  Topic 

programer
Posting Yak Master

221 Posts

Posted - 2012-01-12 : 08:43:54
Hi,

I have table:

tbl_Payment:
Id, PaymentType
1, bank
2, paypal
3, credit card


tbl_PaymentBlockedDeleted:
Id, PaymentTypeId, IsDeleted, IsBlocked
1, 1, false, false

I want to blocked the way of deposit/withdrawal.

This requires a new table or one table is enough?

One table is:
tbl_Payment:
Id, PaymentType, IsDeleted, IsBlocked
1, bank, false, false
2, paypal
3, credit card

What do you mean?

X002548
Not Just a Number

15586 Posts

Posted - 2012-01-12 : 11:36:05
Is this by an individual..or just for the type itself?

In any case, I probably would use a date



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page
   

- Advertisement -