I am a complete newcomer to working with databases, and the idea of setting one up for my project is a bit scary. But here’s what I need to accomplish, as it’s intended for an app. So I guess:

Login details / identifier (I don’t know how that works as yet for Apple or Android)

So when someone has logged in, they should be able to create their own entries. Those entries are going to be split into sections. So I’ll use the example with random fields from different uses, as the functions are the most similar to my project.

So the details that will need to be added are (we’ll pretend this is a Washing Machine that’s sentient and has a birthday and gender. I know, it’s weird. Bear with me…):

Name

DOB (Perhaps even working out age from DOB if that’s possible?)

Gender

Then a couple of simple yes/no questions

Option to go to sub-category - (an example would be entering details of a warranty, for example)

Brand

Type Of Product

Serial Number

Warranty From:

Warranty To: (Perhaps even turning red or creating a warning or push notification as you come up to, or pass the warranty expired date)

Additional Notes:

(this section may be repeated if there’s more than one warranty, like Manufacturer, Extended, and 3rd party)

Sub Category: Contacts:

Name:

Address:

Phone Number:

etc.

Sub Category: Emergency Contacts:

Name

Address

Phone Number

Plus some fixed details which are the same for every user.

User Journal (Entries dated and searchable)

They’re the basics for now, but I simply have no experience, but very willing to learn. I’m also very aware that getting the structure right to start off with is really really important, and I may need to expand details in the future as more features are required.

At some point I’d like to add location functionality to mark areas on a map with dates and details, for example.

And then, perhaps even make (with permission) users the option to share or transfer details of individual details as they need to (if they want to send details of this fictional warranty to a repairer, etc) Or even send all the details to someone if they buy

I’m not sure if it’s simple and I’m a bit dim in working it out, or it’s complex and I’m biting off more than I can chew…

I hope that all makes sense, there are no screenshots because I haven’t started it yet!

Any help and advice would be very much appreciated.