Hi, On 31/01/13 14:02, Lighton Phiri wrote: > Thank you for this. Would been nice if there was a database lookup > table or is there?
There is a diagram -- it's a little outdated, but the core tables don't tend to change all that much. It's here: http://www.dspace.org/1_5_2Documentation/image/db-schema.gif and linked from http://www.dspace.org/1_5_2Documentation/ch06.html Is this the kind of thing you're after? It wouldn't have helped you with the resource_type_id though; there, you just have to know that (AFAIK) wherever there's a resource_id column in a DSpace table, there'll be a resource_type_id column to go with it -- it's the same in the resourcepolicy table for example, I don't know if there are others. cheers, Andrea -- Dr Andrea Schweer IRR Technical Specialist, ITS Information Systems The University of Waikato, Hamilton, New Zealand ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_jan _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

