i have been researching firebase alternative deprecated dropbox datastore api. read articles structuring data, i’m still little unclear.
i have bunch of users:
users - name - email
...and each user has 3 database “tables”, aircraft
, entries
, , customfields
.
aircraft - name - category - make entries - flightdate - departure - destination customfields - name - type
so firebase data structure this?
{ “users”: { “bob”: { “name”: … “email”: … }, “sally”: { “name”: … “email”: … } }, “aircraft”:{ ??? }, “entries”:{ ??? }, “customfields”:{ ??? } }
thanks in advance.
are familiar oop? each "table" object. follows. since don't understand you're trying achieve database , objects, may not correct:
{ "user": { "name": "bob", "aircraft": { "name": "name" }, "entries": { "flightdate": "27/05/2015" } } }
think in objects, not tables. think parent , child.
but in example, if each object (user, aircraft, entries etc.) plurals, can treat them "table", array of objects:
{ "aircrafts":[ { "id":1, "name": "name" }, { "id":2, "name": "name" } ] }
edit: first example if each user had aircraft, in retrospect silly, point still stands.