Re: [sqlite] How to manage Table inside Table scenarios

Guillaume Saumure wrote: 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

Re: [sqlite] How to manage Table inside Table scenarios

If you're talking about multiple Notices for each Machine, then your schema would be something like this: create table Machine ( ID integer primary key not null , Name text , Location text ) ; create table Notice ( ID integer primary key not null , Machine integer

[sqlite] How to manage Table inside Table scenarios

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