· 8 years ago · Apr 10, 2018, 09:58 AM
1CREATE TABLE IF NOT EXISTS MERENJE_UVERENJE_PIPETE
2(
3 ID INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT,
4 UVERENJE_PIPETE_ID INTEGER NOT NULL,
5 TACKA_PROVERE INTEGER NOT NULL,
6 SISTEMATSKA_GRESKA REAL NOT NULL,
7 SLUCAJNA_GRESKA REAL NOT NULL,
8 FOREIGN KEY(UVERENJE_PIPETE_ID) REFERENCES UVERENJE_PIPETE(ID) ON DELETE CASCADE
9)