I would like to have a unique Compound ID generated for each unique structure that is added to a database. The Compound ID should consist of a prefix (e.g. ABC) followed by 6 digits, starting at 000001. I believe this is described somewhere in the documentation but I cannot find it.
Yes, I would be very interested in knowing more about your fully integrated mini-reg system. I have tried working with triggers before but found this to complicated with the Derby-type databases.
Currently we don't have any particular information about this mini registration system on the website. Although we plan to publish it. Basically it is lightweight brother of full Compound Registration system (http://www.chemaxon.com/products/compound-registration/). And it's fully dependent on IJC on the other hand IJC is only requirement for Mini-reg. Among other functionalities it provides staging area, standardizer and unique compound handling, compound ID generation... and many more.
For the moment I'll send you full overview via email.