Sqlite2CoreData icon indicating copy to clipboard operation
Sqlite2CoreData copied to clipboard

Can't achieve creation of relation to the same table

Open Crabman opened this issue 9 years ago • 0 comments

Hello ,

I like very much your tool as I will be using it to transform an SQLite database to the coredata model. However there is something I do not achieve, to create a "Parent/child" relationship from an entity to itself.

My SQLlite has a Foreign key but Sqlite2CoreData seems to ignore it, I would like to achieve something like this : capture d ecran 2015-10-20 a 16 26 12

For information this is my table

CREATE TABLE IMstructure (
  structureid integer PRIMARY KEY NOT NULL,
  descriptionkey integer,
  nameid integer NOT NULL,
  patronym text,
  parentid integer,
  iconid integer,
  FOREIGN KEY (parentid) REFERENCES IMstructure (structureid)
);
CREATE INDEX structure_name_id_idx ON IMstructure (nameid);
CREATE INDEX structure_parent_id_idx ON IMstructure (parentid);

Crabman avatar Oct 20 '15 14:10 Crabman