Say I have a table called
listing and it has the following columns:
id | name | description | price | created_date| 0 | iPhone | A phone | 1000 | 7/4/2020 |
Since I want to track when a listing is sold, I'm considering adding a
My concern is that this would cause a bunch of rows in the
listing table to have a null in the
sold_date column since every listing wouldn't be considered sold. Would having null values be okay in this case, or should I create another table that would contain the
sold_date column and references a listing?