Help with creating a table for my DB

[Maoriboy]

First off sorry if theres already a post here about this i just didn't know how to word it and everything so i couldn't search SORRY.




I have this:




and wanting to put it into my DB. and don't know how to do it. i have tried just doing this:




which worked alright till i wanted to do queries for exact time and days. could anyone help me with this issue please? Much appreciated in advance.

[John_G]

How is the data getting into the Time/Day preferred field? It doesn't appear to be automated, as there are a number of spelling mistakes.

It looks as if that field is just a character string; that will make it "difficult" - to say the least - to search (as you are finding out). My suggestion is to make a separate "Preferred_Times" table, something like this:

PSN_Tag (FK to Overwatch NZ Players)
DayOfWeek (could be text or numeric, but numeric makes range selection easier. used "DayOfWeek" because "Day" is a reserved word)
Start_Time
End_Time

Entries here could match the selections made on your form shown above, which allows for different time ranges on different days. (Surely you don't expect one time on say, Monday, and then a second time on, say, Thursday?). That would make no sense, IMO.

[Maoriboy]

Thank you will try it out.

[Maoriboy]

How is the data getting into the Time/Day preferred field? It doesn't appear to be automated, as there are a number of spelling mistakes.

It looks as if that field is just a character string; that will make it "difficult" - to say the least - to search (as you are finding out). My suggestion is to make a separate "Preferred_Times" table, something like this:

PSN_Tag (FK to Overwatch NZ Players)
DayOfWeek (could be text or numeric, but numeric makes range selection easier. used "DayOfWeek" because "Day" is a reserved word)
Start_Time
End_Time

Entries here could match the selections made on your form shown above, which allows for different time ranges on different days. (Surely you don't expect one time on say, Monday, and then a second time on, say, Thursday?). That would make no sense, IMO.

What do you mean by "FK to Overwatch NZ Players"

[John_G]

"FK" is short for "Foreign Key". It refers to a field in one table containing values which correspond to the PK (Primary Key) in another table. Put another way, they "point to" a record in another table. Very often there is a defined relationship between the two tables, but there doesn't have to be. FK - PK links are often used in multi-table queries to "look up" data to be included in the query results.

Now that I look at your table Overwatch NZ Players again, PSN_Tag is not a good field to use to relate the two tables, because it is blank in a lot of records. What is the Primary Key of Overwatch NZ Players? Does it even have one? If it doesn't, how can you uniquely identify a record? You have to be able to uniquely identify records in order to relationships and queries to work properly.

I should have mentioned that if you make a separate table for Preferred_Times, then you would remove the field Time/Day Prefered field from the players table.