Actions
Feature #1563
closedOpenAtlas model to database
Start date:
2021-08-20
Estimated time:
16.00 h
Cooperation:
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)
Updated by Alexander Watzinger about 3 years ago
- Description updated (diff)
- Estimated time set to 16.00 h
Updated by Alexander Watzinger about 3 years ago
- Description updated (diff)
- Status changed from Assigned to In Progress
Updated by Alexander Watzinger about 3 years ago
- Subject changed from Move OpenAtlas model to database and create views to OpenAtlas model to database and create views
Updated by Alexander Watzinger almost 3 years ago
- Target version changed from 6.5.0 to 6.6.0
Updated by Alexander Watzinger almost 3 years ago
- Subject changed from OpenAtlas model to database and create views to OpenAtlas model to database
- Description updated (diff)
Updated by Alexander Watzinger almost 3 years ago
- Status changed from In Progress to Closed
Actions