Hi Everybody
When I configured Geonetwork to use PostGIS as database, it create a lot of
tables (36 tables).
What is the purpose to have so many tables and what is stored in which one.
I figure it out that the metadata is stored in "metadata" table, this is
correct?
Kind Regards
Kanke, Rogerio.
Hello,
in the tables there is everything you configure / input via GUI.
metadata shows the inserted metadata
catergories shows the categories you use for the metadata
groups is for the sub-catalogues or "groups" in your installation
if regions is still there, it was necessary for the spatial search in former
times (now you use an rdf file for the regions)
users / usersgroups contains your users and the groups they belong to
...
I do not change anything about the tables, but if you put data into
geonetwork via GUI, then you may see what one or the other table is good
for.
The only table you may need concerning tables is metadata. "uuid" is the
fileIdentifier. This makes it easy looking up metadata for example if the
lucene index is not working properly and you have more metadata in the
database than you can see via GUI. "harvesteduuid" shows the harvesting-csw
from which the metadata originally comes from if you harvest metadata from
different csw. So you may address the admin of a special harvesting-csw, so
he has to change s.th. in the metadata, for example. Which "harvesteduuid"
belongs to which CSW you can see in a table called sources or in
harvesthistory, which gives the information on problems while harvesting.
Those can also be read in the gui for harvesting, off course.
Greetings,
Anja
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/PostGIS-Tables-tp5217885p5218434.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.