EPrints Technical Mailing List Archive

Message: #02210

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

[EP-tech] Re: Database Relation


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.




From: eprints-tech-bounces@ecs.soton.ac.uk [mailto:eprints-tech-bounces@ecs.soton.ac.uk] On Behalf Of MOHD IZAMRI, ISMAIL
Sent: 20 September 2013 04:37
To: eprints-tech@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@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.