Data (Chemical Structure) hierarchy
DB_NO is the primary key for all records,
- Parent, Version and Preparation.
DB_NO is the link between Parent, Version and Preparation.
DB_NO is the primary key for linking Oracle and Daylight.
All keys are stored in a normalised form.
Database has been de-normalised for key look up