I notice there are a smallish number of `entries` records (1499) where `genretype_id` is `null`
Does this suggest:
1) Those entries in reality do have a genre, but it is not yet known/recorded?
2) Those entries in reality do have a genre, but it isn't one of the existing ones in `genretypes` table?
3) The entry really doesn't have a genre at all (whatever that means) and `null` is the correct value.
I am asking because a few of those entries chosen at random seem to have reasonably obvious genres to me. If the answer is (1), perhaps I will find time to make suggestions for some of the missing values.
It would be nice if ultimately all entries had a genre.
A question about entries without a genre
Moderator: druellan
-
- Drutt
- Posts: 6
- Joined: Thu Jan 18, 2024 2:15 pm
- Einar Saukas
- Bugaboo
- Posts: 3185
- Joined: Wed Nov 15, 2017 2:48 pm
Re: A question about entries without a genre
Option 1.martingzzz wrote: ↑Thu Jan 18, 2024 5:39 pm I notice there are a smallish number of `entries` records (1499) where `genretype_id` is `null`
Does this suggest:
1) Those entries in reality do have a genre, but it is not yet known/recorded?
2) Those entries in reality do have a genre, but it isn't one of the existing ones in `genretypes` table?
3) The entry really doesn't have a genre at all (whatever that means) and `null` is the correct value.
Most of them are ZX81 titles imported from Martijn's old WoS, that didn't store much detailed information about the ZX81.
Please go ahead! You can submit your suggestions using the HELP form.martingzzz wrote: ↑Thu Jan 18, 2024 5:39 pm I am asking because a few of those entries chosen at random seem to have reasonably obvious genres to me. If the answer is (1), perhaps I will find time to make suggestions for some of the missing values.
Agreed!