Use multiple fields for primary key on default mol table

User d8da4712c1

13-05-2013 09:05:25

Greetings everyone,


We have our own id that we'll keep after migration to our new systeme that will be using Jchem tech. ,and after creating the molecule table wich contains other costum field like (struct_id: our old varchar identifier) ,I'm thinking about adding this:


 


CONSTRAINT structure_pk PRIMARY KEY (cd_id, struct_id);

 


Looking for your advice, thanks.

ChemAxon aa7c50abf8

13-05-2013 09:59:24

Halló,


Within the about 45 minutes I spent dealing with your post so far, I couldn't think of anything which would prevent this from working. Not on Oracle at least.


Peter

User d8da4712c1

13-05-2013 10:04:25










pkovacs wrote:

Halló,


Within the about 45 minutes I spent dealing with your post so far, I couldn't think of anything which would prevent this from working. Not on Oracle at least.


Peter



Thank you very much Peter,kind of you, we really appreciate that and it's important for us too to keep the old primary key. we use oracle too, thanks again peter.


Kind regards,


Idris.