so, so far i have a user table as such.
fields are: user_id, first_name, last_name, address, city_id, date_of_birth and time, email address.
list is quite big their are only 5 people here.
1 Tama Rakete 29 Shipton St. 1 1992-09-04 00:00:00 firstname.lastname@example.org
2 Hine Rangi 18c Point Road 2 1992-06-21 00:00:00 email@example.com
3 Mike Tupou 95 Collins Crescent 1 1992-02-12 00:00:00 firstname.lastname@example.org
4 Iosefe Johnson 2 Henson Street 3 1991-11-12 00:00:00 email@example.com
5 Fiona Cobber 43 Karamatta Street 5 1993-04-17 00:00:00 firstname.lastname@example.org
the city_id links to my City table which i have created. what i need here is to make a new link called activity_id which will link to my Activities table which will hold a list of many activities lets say will never be more than 100,000. the issue i am having is some of the users will link to the same activity, but also some users will link to multiple activities.
So i was thinking maybe having activity_id as an enum or SET field, but not sure if this will work as in my Activities table acticity_id will be a auto-incrementing INT.
can someone please help me with step by step instructions.
So far i have created the Activites table with an INT activity_id and a varchar(80) activity fields. no other fields in this table. The table is currently empty, and will be populated after the link has been established correctly.