I hope this post is in the right section.
I am designing a new application and I am after some advice in regards to designing the database structure. The application is being built in ASP.NET 3.5, SQL SERVER 2005 Express and using the built in membership/profiling tables.
The website will allow a user to login and verify their account with a link in an email they will be sent. I have got this working fine using the createUserWizard control, but I also need them to select the type of membership they want when creating an account and I am a bit stumped at what stage this should be put in.
Do I put this in when creating the user before they verify their account? or do I have it listed when they first login to allow them to change their membership status from a free account to a paying account?
They will have four options list below:
The bronze, silver and gold accounts will be a monthly subscription which the user can signup to.
The second part to this post is the main bit in how do I design my database for monthly subscriptions? I was thinking something along the lines below.
UserID, SubscriptionID, StartDate, EndDate
12345, 1, 10-10-201
View Complete Post