Releation between entity types

[chkaufmann 17]

We built our own framework where we can define different entity types. Each Entity Type has 1-n values. Then we allow different relation between entity types:
- Parent / Child
- Reference
- Link (m:n relation)

 

At first glance a parent/child relation is the same as a mandatory reference. But somehow it feels, it's not and I try to find the rules when to choose parent/child and when to choose reference.

 

Can someone point me to appropriate reading?

 

Thanks

Christian
 

[egroups 2]

Own framework?Do you trying Spring4d ORM?

[chkaufmann 17]

No. In my approach is I have only two tables in the SQL database: ENTITY and ENTITYVALUE. Basically each object has one record in ENTITY with general values (id, guid, ownerid, created, modified) and then it has one record for each value in ENTITYVALUE. Like this, the database is very generic and the meta information is in the code only.

 

Christian