Software

The database looks flat. One of the more common relational database examples could be a sales database. You have the person you sold to noted in the sales database but the person's information in another so you don't duplicate the person's address and such in each sales entry.

Maybe you didn't tell all but hey, as it stands it looks flat from here.

One of the DIY relationals databases is MS Access, part of the MS Office suite. It's not only a database, but you can make forms for data entry and maintenance, and have a drop down list of architects to choose from. And a drop-down list of styles, building type etc.

If you're afraid of building it yourself, use MS Excel. You can make forms with dropdown lists, and use filters for the fields to search specific records.

Thank you. I used Access about 20 years ago to create a large collections database for a museum collection. While it has no doubt moved on I am sure the principles are the same. Can I insert a thumbnail image and then link that to another place with a large image? Another database I have used which included images is Past Perfect. It works well and has sophisticated ways of grouping and searching but I would need to buy the software plus multimedia and in A$ it would be about $1300. Another option I suppose its to catalogue the images in Access and use that to generate a unique Accession number and to store the images by Accession no in Google photos. If I had a thumbnail in Access and wanted the high res image I could retrieve it from the Cloud in google images. Is this a good way to go or is it getting to complicated? Are there other better alternatives?

Google's storage policy is changing so I take it you know this and the cost involved or you will be buying a Pixel phone.

Even LibreOffice can house images. https://www.techrepublic.com/article/how-to-insert-an-image-into-a-libreoffice-base-database/

In your case, why the cloud? Folk I know that ask your question often regret it over cloud storage fees.

Hello, I had heard that Googl Photos will be charging later in 2021 but will honour up to 15GB in the system prior to this. I didn't know about Pixel phones. It opens another question which is what phone is best for pictures - one which gives faux digital SLR controls?
I agree the starting point is not the Cloud but the best system at a reasonable price. I suppose an external hard drive is an alternative but the Cloud provides access which id not dependant on having hardware with you. This forum does not seem to be answering my question but only raising more questions.

IMO not for primary storage. This is from decades of folk trying to use such as primary or their only copy of stuff they can't lose.

Is there more to the story above?

Is there any reason not to explore putting such information in the file's metadata and then use tools/commands such as noted at https://superuser.com/questions/1240555/command-line-to-return-image-properties to make a search tool?