ManyToMany Assocation script generation
Posted: Mon 14 Feb 2011 16:06
I have a many to many relation, where the two primary keys have the same name (ID).
Entity developer generates the following manytomany link table:
which is invalid, obviously.
In the manytomany associations dialog, at the bottom, i specified values for the Column field, which i thought would rename these fields, but it didn't.
Any way to fix this automatically, or do i need to manually add these entities or rename my PK's?
Code: Select all
CREATE TABLE FLASH(
ID NUMBER
)
CREATE TABLE REGION(
ID NUMBER
)
Code: Select all
CREATE TABLE "flash"."Regions_Flashes" (
ID NUMBER(9) NOT NULL,
ID NUMBER(9) NOT NULL,
CONSTRAINT "PrimaryKey" PRIMARY KEY (ID, ID),
CONSTRAINT "FK_Regions_Flashes_Regions" FOREIGN KEY (ID) REFERENCES "Regions" (ID),
CONSTRAINT "FK_Regions_Flashes_Flashes" FOREIGN KEY (ID) REFERENCES "Flashes" (ID)
);
In the manytomany associations dialog, at the bottom, i specified values for the Column field, which i thought would rename these fields, but it didn't.
Any way to fix this automatically, or do i need to manually add these entities or rename my PK's?