Database Structure

There will be 6 tables - tables for Redeem gift points needs to be made....

1. tbl_partner - This table will contain the necessary partner information like

partnerid
email
pwd
companyname
Address
City
State
Zipcode
ContactPerson1
ContactPerson2
Tel1
Tel2
FaxNo
IsActive
CreatedBy
CreatedOn
ModifiedBy
ModifiedOn

tbl_offer - This table will contain the scheme details

Offerid
Points
Product
Machines
IsActive
CreatedOn
CreatedBy
ModifiedOn
ModifiedBy

tbl_SerialMaster - This table will contain all the Serial numbers of a Product

serialId
SerialNo
MachineName
IsBlock
IsActive

tbl_claim - this table will contain the Claims of a Partner

claimId
ProductName
PartnerId
NoofMachines
T1InvoiceDate
T2InvoiceNo
ClaimDate
IsApproved

tbl_ClaimMachineSerial - This table will will stored the SerialNo;s Against a particulat Claim Registeration along with partner Id

ID
ClaimId
PartnerId
MachineSerial

tbl_Points _ this Table will contain the Points of a particulat Partner

PointId
PartnerId
PointsEarned
PointsRedeemed