how to setup composite key in database
Hi
I am planning to use a mysql table having a composite key. How to setup composite key in data-dictionary.xml. For example , if I have a table like this: CREATE TABLE track(
album CHAR(10),
disk INTEGER,
posn INTEGER,
song VARCHAR(255),
PRIMARY KEY (album, disk, posn)
)
, how would we map it in data-dictionary.
Thanks
Palash