Hi, As you correctly noted, the latest schema diagram we have is for DSpace 6: https://wiki.lyrasis.org/display/DSDOC7x/Storage+Layer This diagram is "semi-accurate" for DSpace 7, as v7 uses the same general table structure as v6... with a few new tables added to v7 to specifically support Configurable Entities & other new features in v7.
Unfortunately, we've not had a volunteer to help us regenerate that fancy diagram in the documentation (the previous v6 diagram was created with a paid tool). If anyone is interested in helping generate a pretty diagram for v7, we'd appreciate volunteers. In the meantime, there are many free database tools which can generate an interactive ERD (Entity Relationship Diagram) if you just point it at your database. One I've used in the past is pgAdmin 4 (https://www.pgadmin.org/docs/pgadmin4/6.18/erd_tool.html). To get a dynamically built diagram for DSpace 7, you could point pgAdmin 4 against a DSpace 7 (Postgres) database, and use its built in ERD Tool. The advantage to this is that you no longer are dealing with a static image file, the diagram is interactive & you can easily zoom in to get as much detail on each table as you wish. Tim On Wednesday, January 25, 2023 at 5:30:28 AM UTC-6 jorge...@gmail.com wrote: > Hi. > Could I please get the db schema/ data model for Dspace 7 ? > > Why ? > > We are a large institution with various departments and are required to > provide quarterly updates per departments. To this end we run SQL queries > against the database. > We have preset queries which we used in Dspace 4 , which , with a press of > a button spew out the required information. > These queries/selects obviously no longer work after our migration to > dspace 7. > To assist in the "correction" of the queries I was asked to provide the > schema ... the relationships between the tables in the actual database and > what they hold. > > I did attempt to find this on my own , but on the wiki the closest I found > was dspace 6 schema . > Are they the same ? > > -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/43e9ad2e-99e4-4234-8241-c3d95518b810n%40googlegroups.com.
