I'm just trying to make sure that I understand how foreign key relationships
should be set up in MapBuilders, so I can determine if the NGMBT is setting
them up properly.
I have a table created using:
CREATE TABLE TASKMASTER_TASK(
TASK_ID INTEGER NOT NULL,
OWNER_ID INTEGER NOT NULL,
TASK_NAME VARCHAR(255) NOT NULL,
TASK_DESC VARCHAR(255) NOT NULL,
PARENT_TASK_ID INTEGER,
TASK_STATUS VARCHAR(1),
PRIMARY KEY (TASK_ID),
FOREIGN KEY (PARENT_TASK_ID)
REFERENCES TASKMASTER_TASK(TASK_ID)
)
;
In the resulting TaskMapBuilder.java generated by NGMBT, I see:
tMap.addForeignKey ( getTask_ParentTaskId(), integer,
TaskMapBuilder.getTable(),
TaskMapBuilder.getTask_ParentTaskId() );
I'm not sure about the semantics of each of the arguments to the addForeignKey
method. Should the last two arguments be the table name and column name in
the table being referenced, or of the table that the foreign key is declared
in? If the former, then I think the code generated by NGMBT should be:
tMap.addForeignKey ( getTask_ParentTaskId(), integer,
TaskMapBuilder.getTable(),
TaskMapBuilder.getTask_TaskId() );
(note the difference to the last line).
-Greg-
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
