Oh, sorry maybe I should gave you all the scripts of the tables referenced by
the CLAIM table.
Here are the missing parts:
create table TYPE(
ID int generated by default as identity,
NAME varchar(20) not null,
constraint type_pk primary key(ID)
);
create table RESOURCE(
ID int generated by default as identity ,
NAME varchar(50) not null,
TYPE int,
TTVALUE numeric(3,2),
constraint resource_pk primary key(ID),
constraint resource_fk_type foreign key(TYPE) references TYPE(ID)
);
create table CONTINENT(
ID int generated by default as identity ,
NAME varchar(20) not null,
REAL_WIDTH numeric(5) not null,
REAL_HEIGHT numeric(5) not null,
WIDTH double not null,
HEIGHT double not null,
SCALE double,
DEF_ZOOM double,
IMAGE varchar(255) not null,
constraint continent_pk primary key (ID)
);
The result of the script you gave me:
CONSTRAINTNAME TABLENAME
---------------------------------------
FINDER_FK_TYPE FINDER
FINDER_AMP_FK_TYPE FINDER_AMP
RESOURCE_FK_TYPE RESOURCE
CLAIM_FK_CONTINENT CLAIM
CLAIM_FK_RESOURCE CLAIM
CLAIM_FK_TYPE CLAIM
CLAIM_FK_FINDER CLAIM
CLAIM_FK_FINDER_AMP CLAIM
Btw I use the Netbean's 6.5 embedded graphical tool.
--
View this message in context:
http://www.nabble.com/What-cause-this--tp20994381p20998034.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
