db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From xecutor <pkere...@freemail.hu>
Subject Re: What cause this?
Date Sun, 14 Dec 2008 07:42:28 GMT

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.


Mime
View raw message