[sqlite] How to manage Table inside Table scenarios

[Guillaume Saumure]

Hello everyone,

I have to create a small program to track changes done on multiple 
machines. The data structure look like :

Structure Notice
    PrimaryKeyID.l
    Type.l
    Date.l
    ExecutedBy.s
    RequestedBy.s
    Description.s
EndStructure

Structure Machine
    PrimaryKeyID.l
    Name.s
    Location.s
    List Notices.Notice()
EndStructure

Structure Assets
    ...
    ...
    DatabaseFileName.s
    List Machines.Machine()
EndStructure

To make a long story short, I have a Linked list nested inside Linked 
list but I really don't know how to manage a scenarios like this using 
Database recording system. Any suggestions ?

Thanks beforehand and best regards.
Guillaume Saumure

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users