sqlite: Object relationship representation in database for nested objects

mardi 5 avril 2016

I have classes A, B, C and D. Class A, B and C have a list of D. eg:-

class A{
    int id;
    String nameA;
    List<D> listOfDs;
}

class D{
    int id;
    String name;
}

So that means A has a list of Ds, B has a list of Ds and C has a list of Ds

How am I supposed to represent this in a database. I am developing the client side on Android and iOS and the backend on ASP.Net.

So how do I represent this in structure on all these platforms so that they can be saved in the database?

sqlite