Project

General

Profile

Actions

Feature #1563

closed

OpenAtlas model to database

Added by Alexander Watzinger over 2 years ago. Updated over 2 years ago.

Status:
Closed
Priority:
Normal
Category:
Backend
Target version:
Start date:
2021-08-20
Estimated time:
16.00 h

Description

Currently the OpenAtlas model, which is closely connected to the CIDOC CRM, is described in openatlas/models/model.py.
  • Move the model to the database to e.g. guarantee data integrity on the database level
  • The OpenAtlas classes will be "aware" of their standard type, possibility to add types, reference systems, aliases and many other (at the moment hard-coded) properties
  • Views for OpenAtlas classes to display their properties and count of entities using it

Database changes

Beside the new table model.openatlas_class (see above) there were many other structural changes to be aware of, especially if you depend on other systems using the database directly.

Removed

Table web.form was removed. Historical we used it to track form related information which is now replaces with information about classes. Forms are now related to the classes in model.openatlas_class which is much more straightforward.

Renamed

  • Table model.class -> model.cidoc_class
  • Table model.class_i18n -> model.cidoc_class_i18n
  • Table model.class_inheritance -> model.cidoc_class_inheritance
  • Table web.hierarchy_form -> web.hierarchy_openatlas_class (with foreign key openatlas_class_name to model.openatlas_class.name)
  • Field entity.class_code to cidoc_class_code
  • Field entity.system_class to openatlas_class_name

Restructuring of table web.hierarchy

Joining of the fields standard, value_type and locked to category with possible values:
  • Standard
  • Custom
  • Value
  • System (e.g. external reference match)
Actions #1

Updated by Alexander Watzinger over 2 years ago

  • Description updated (diff)
  • Estimated time set to 16.00 h
Actions #2

Updated by Alexander Watzinger over 2 years ago

  • Description updated (diff)
  • Status changed from Assigned to In Progress
Actions #3

Updated by Alexander Watzinger over 2 years ago

  • Subject changed from Move OpenAtlas model to database and create views to OpenAtlas model to database and create views
Actions #4

Updated by Alexander Watzinger over 2 years ago

  • Target version changed from 6.5.0 to 6.6.0
Actions #5

Updated by Alexander Watzinger over 2 years ago

  • Subject changed from OpenAtlas model to database and create views to OpenAtlas model to database
  • Description updated (diff)
Actions #6

Updated by Alexander Watzinger over 2 years ago

  • Description updated (diff)
Actions #7

Updated by Alexander Watzinger over 2 years ago

  • Description updated (diff)
Actions #8

Updated by Alexander Watzinger over 2 years ago

  • Description updated (diff)
Actions #9

Updated by Alexander Watzinger over 2 years ago

  • Status changed from In Progress to Closed
Actions

Also available in: Atom PDF