I have: tbl_UserDeposit
DepositID int
ApplicationId uniqueidentifier
UserId uniqueidentifier
TransactionAmount float
TransactionStatus bit
TransactionDate datetime
TransactionType int
CurrencyCode varchar(50)
tbl_UserWithdrawal:
WizhdrawalID int
ApplicationId uniqueidentifier
UserId uniqueidentifier
TransactionAmount float
TransactionStatus bit
TransactionDate datetime
TransactionType int
CurrencyCode varchar(50)
tbl_UserBonuses:
BonusID int
ApplicationId uniqueidentifier
UserId uniqueidentifier
TransactionAmount float
TransactionStatus bit
TransactionDate datetime
TransactionType int
CurrencyCode varchar(50)
tbl_RegisteredUser:
UserId uniqueidentifier
ApplicationId uniqueidentifier
IsMale bit
FirstName varchar(150)
Surname varchar(150)
Street varchar(150)
StreetNumber nvarchar(20)
ZipCode nvarchar(50)
City nvarchar(50)
Country nvarchar(50)
Region nvarchar(50)
Currency varchar(3)
DateOfBirth date
Telephone nvarchar(30)
Mobile nvarchar(30)
BonusCode nvarchar(30)
AffiliateId int
ChangeUserStatusNote nvarchar(500)
IsApprovedDocument bit
My balance: 0,00 €
I deposit 10,00 €.
My balance: 10,00 €
I again deposit 25,00 €
My balance: 35,00 €
Withdrawal: 8,00 €
My balance: 27,00 € - amount column in table tbl_registeredusers?
My question:
Is it necessary to make a new column "Amount" in the table tbl_registeredusers?
programercek
Participant
1510 Points
2244 Posts
Re: deposit/withdraw
Apr 21, 2011 08:15 PM|LINK
I have: tbl_UserDeposit
DepositID int
ApplicationId uniqueidentifier
UserId uniqueidentifier
TransactionAmount float
TransactionStatus bit
TransactionDate datetime
TransactionType int
CurrencyCode varchar(50)
tbl_UserWithdrawal:
WizhdrawalID int
ApplicationId uniqueidentifier
UserId uniqueidentifier
TransactionAmount float
TransactionStatus bit
TransactionDate datetime
TransactionType int
CurrencyCode varchar(50)
tbl_UserBonuses:
BonusID int
ApplicationId uniqueidentifier
UserId uniqueidentifier
TransactionAmount float
TransactionStatus bit
TransactionDate datetime
TransactionType int
CurrencyCode varchar(50)
tbl_RegisteredUser:
UserId uniqueidentifier
ApplicationId uniqueidentifier
IsMale bit
FirstName varchar(150)
Surname varchar(150)
Street varchar(150)
StreetNumber nvarchar(20)
ZipCode nvarchar(50)
City nvarchar(50)
Country nvarchar(50)
Region nvarchar(50)
Currency varchar(3)
DateOfBirth date
Telephone nvarchar(30)
Mobile nvarchar(30)
BonusCode nvarchar(30)
AffiliateId int
ChangeUserStatusNote nvarchar(500)
IsApprovedDocument bit
My balance: 0,00 €
I deposit 10,00 €.
My balance: 10,00 €
I again deposit 25,00 €
My balance: 35,00 €
Withdrawal: 8,00 €
My balance: 27,00 € - amount column in table tbl_registeredusers?
My question:
Is it necessary to make a new column "Amount" in the table tbl_registeredusers?