User:Trapa/Registration System/db/Registrant events attended
From WikiFur, the furry encyclopedia.
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.
|