SQLite foreign key can't be recognized

Dec 26, 2013 at 3:38 AM
It's good tool. BUT when I test on sqlite db, it can't recognize foreign key.
My test tables are:

CREATE TABLE [Author] (
[id] integer NOT NULL PRIMARY KEY AUTOINCREMENT, 
[name] nvarchar(50) NOT NULL, 
[age] integer
)
GO

CREATE TABLE [Book] (
[isbn] integer NOT NULL PRIMARY KEY AUTOINCREMENT, 
[authorId] integer NOT NULL, 
[bookName] nvarchar(50) NOT NULL, 
FOREIGN KEY ([authorId])
    REFERENCES [Author] ([id])
    ON UPDATE CASCADE ON DELETE CASCADE
)
GO

The tool generate book class with authorId but not Author class reference.