I am designing a real estate website and wanted feedback from some professionals about the database schema that I came up with.
I created a property table that would have each house. Each house can be listed for sale multiple times over the years, which be under the property_listings table.
I created the database diagram over at dbdiagram.io so you can view it here: https://dbdiagram.io/d/603fc91ffcdcb6230b226f4a
I'm wondering if anything looks like a miss or if I'm doing anything wrong. I don't typically design databases. Thank you in advance for the feedback.
images.property_listing_id
,property.community_id
-> bigint. Prices, taxes and fees asint
, suggestdecimal
maybe. otherwise generally looks ok.