User:Trapa/Registration System/db/Registrant events attended

This table is for linking registrants to the events they attended. This table should hold the registrants uid, the events uid, and the time the link was created (the time the registrant first registered) as well as the most current membership code type. This will also record the rl_first, and rl_last and fan_name that was used for that event. (For archival purposes)

The table should look like this:

Field	Type	Other	Purpose
user_uid	int 10	NOT NULL	Links this line to the users uid
event_id	VarChar 10	NOT NULL	Links the user to the event
reg_num	Int 4	NOT NULL	The number of this registration (starts counting from 1 every event)
membership_type	VarChar 6	NOT NULL	Shows which membership the user has (most recent) used for printing.
badge_display_code	VarChar 4	NULL	Which Badge Display Code the User wished to use
linked_to_membership	int 10	NULL	This membership is linked to linked_to_membership. This is used for dealers assistants and children
rl_first	Varchar 30	NULL	This is the Rl_first name that was given when this fur registered for this event. It can be changed in the registrants table so we keep this here for archival purposes.
rl_last	Varchar 30	NULL	This is the Rl_last name that was given when this fur registered for this event. It can be changed in the registrants table so we keep this here for archival purposes.
fan_name	Varchar 40	NULL	This is the fan_name name that was given when this fur registered for this event. It can be changed in the registrants table so we keep this here for archival purposes.