[EP-tech] Re: Database Relation

John Salter J.Salter at leeds.ac.uk
Mon Sep 23 10:20:42 BST 2013


Hi,
The table 'eprint_divisions' contains the divisions selected for an eprint.
The table 'subjects' contains the data for all subject trees. Divisions is a 'subject' field - so it should be in there.
When you save an eprint with one of your new divisions selected, you should then be able to see it in eprint_divisions.

Cheers,
John

From: eprints-tech-bounces at ecs.soton.ac.uk [mailto:eprints-tech-bounces at ecs.soton.ac.uk] On Behalf Of MOHD IZAMRI, ISMAIL
Sent: 20 September 2013 04:37
To: eprints-tech at ecs.soton.ac.uk
Subject: [EP-tech] Database Relation

Hi All,

I don't know if this is too much to ask, but do you have eprints database documentations? I want to know the database relation.

I check on MySQL database and see one of the tables there "eprint_divisions". Check on the data inside and found out that it contains the old divisions ID.
I already update my repository hierarchy (http://wiki.eprints.org/w/EPrints_3_Organisation_Hierarchy), but I cannot found the new divisions ID that I create.

Is this right or need to be corrected manually?

Thank you.

Best Regards,

Mohd Izamri Ismail (Izam)
Analyst Programmer
Management Information System (MIS)
HELP University, BZ-2, Pusat Bdr Damansara (Main Block),
50490 Kuala Lumpur, Malaysia.
Mobile: +6019 6690190
Email: izamri.ismail at help.edu.my<mailto:izamri.ismail at help.edu.my>
"University Of Achievers"

DISCLAIMER: We value your online privacy. This email including any attachments may contain confidential & privileged information and is intended solely for the use of the recipient(s). If you have received it in error, please notify the sender and delete all the contents permanently from all kinds of storage devices. Unauthorized distribution or dissemination of this email is strictly prohibited. Please be informed that views or opinions found in this email are solely that of the author and do not necessarily represent HELP University Sdn Bhd. HELP University Sdn Bhd disclaims all warranties to the content of this email and shall not be liable for any loss or damage to the person and /or their property caused by this email.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20130923/9ea8b806/attachment.html 


More information about the Eprints-tech mailing list