RoR conceptual / information model

The Register of Register model can be splitted in 3 main items: the Registries, the Registers and the relation between them.

The Registry table contains the information related to the federated registries; it acts as a kind of container for the registers. The Register table contains the information related to each of the federated registers. The relation table contains the links between the registers.

The detailed information model is attached as PDF.

YOu can find below a description of the main entities of the system.

Registry

The Registry could be seen as the container for the registers and telations. Each registry makes reference to an organization (like a member state or an European organization). The registry is an information system on which a register is mantained (eg. the German theme register is registered in the federation under the  "German INSPIRE registry" registry).

Table name: registry

Field name	Field type	Required	Foreign key	Description
uuid	string
uri	string			The uri of the registry
label	string			The name of the registry
definition	string			The definition of the registry
publishername	string			The name of the publisher
publisheremail	string			The email of the publisher
publisheruri	string			The URI of the publisher
publisherhomepage	string			The homepage of the publisher
descriptor	string		descriptor [uuid]	The reference to the Registry descriptor
updatefile	string			The URL of the registry exchange file
updatefrequency	string			The harvesting frequency
dbcreationdate	date			The date when the entry has been inserted in the DB
dblasteditdate	date			The date when the entry has been last edited on the DB

Register

The register is an element in the federation. For example it could be a Register or a Hierarchical Register

Table name: register

Field name	Field type	Required	Foreign key	Description
uuid	string
uri	string			The uri of the register
registry	string		registry [uuid]	The registry containing this register
label	string			The label of the register
definition	string			The definition of the register
publishername	string			The name of the publisher
publisheremail	string			The email of the publisher
publisheruri	string			The URI of the publisher
publisherhomepage	string			The homepage of the publisher
descriptor	string		descriptor [uuid]	The reference to the Register descriptor
updatefrequency	string			The harvesting frequency
dbcreationdate	date			The date when the entry has been inserted in the DB
dblasteditdate	date			The date when the entry has been last edited on the DB

Relation

The relation table contains the relations between registers.

Table name: relation

Field name	Field type	Required	Foreign key	Description
uuid	string
subjectasset	string		register [uuid]	The URI of the main register (subject)
objectassert	string		register [uuid]	The URI of the related register (object)
predicate	string			The type of the relation (predicate)
status	string			The status of the relation
dbcreationdate	date			The creation date
dblasteditdate	date			The date of last modification