Table `ss` should reference `ili` as foreign key

globalwordnet / OMW

The Open Multilingual Wordnet

http://compling.hss.ntu.edu.sg/omw/

MIT License

57 stars 9 forks source link

Table `ss` should reference `ili` as foreign key #79

Closed jmccrae closed 4 years ago

jmccrae commented 4 years ago

This could lead to constraint issues

CREATE TABLE ss
       (id INTEGER PRIMARY KEY ASC,
        ili_id INTEGER,
        pos_id INTEGER NOT NULL,
        u INTEGER NOT NULL,
        t TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        FOREIGN KEY(pos_id) REFERENCES pos(id));

Should have

FOREIGN KEY(ili_id) REFERENCES ili(id)