| |
|
Line 26
|
Parallel
|
Line 26
|
Parallel
|
| 26 |
version NUMBER (18) default 1, |
26 |
version NUMBER (18) default 1, |
| 27 |
primary key (filterid) , |
27 |
primary key (filterid) , |
| 28 |
foreign key (filtertypeid) references FILTERTYPE (filtertypeid), |
28 |
foreign key (filtertypeid) references FILTERTYPE (filtertypeid), |
| 29 |
foreign key (userid) references USERDETAILS (userid) ); |
29 |
foreign key (userid) references USERDETAILS (userid) on delete cascade ); |
| 30 |
|
30 |
|
| 31 |
create table FILTERGROUP ( filtergroupid NUMBER(15) NOT NULL, |
31 |
create table FILTERGROUP ( filtergroupid NUMBER(15) NOT NULL, |
| 32 |
filterid NUMBER(15) NOT NULL, |
32 |
filterid NUMBER(15) NOT NULL, |
| |