SQL tables help

[12938172]

Hey guys,

I am working on my table structure and am alittle stuck on what to do. The user has the ability to reg himself, and if he doesnt then his details wont be saved but his transaction will. Now, when I store the transactions for regged and unregged users should I store them in different tables ? See the tables below:

User Table
UserID
Name
Contact
Email
Gender
Registered
username
password
moderator

Event Table
EventID
EventName
MaxNoTickets
SingleTicketPrice

Purchase Table
PurchaseID
UserID
EventID
NoOfTicketsPurchased
TotalPrice

As you can see, the following table would only work if the user was registered. But now the question is how I should store events for unregistered users. So far it looks like I will need to create a seperate table.

 

[r937]

if the user is unregistered, how do you know who he is?

i don't understand how "his details wont be saved but his transaction will" is supposed to work

this does not require a separate purchase table

you could insert a row into the purchase table with a user_id of NULL

this would correspond to a number of tickets being sold but you don't know who you sold them to

if that makes sense to you...

r937.com | rudy.ca