Import attributes table

[dlebauer]

Summary

BETYdb has a table named 'attributes' with columns:

• id (int): unique id for table
• container_id (int): unique id for container (row that attribute belongs to)
• container (text): name of table that the attribute belongs to
• value (jsonb): these are the attributes.

Steps:

• review the contents of the attributes table
• determine whether there is useful data to import
• if yes to above, decide whether to
  • keep the attributes table, possibly as a json text file
  • append records to existing tables
    • as a generic 'attributes' or 'attributes_json' column or
    • a new column (e.g. if all attributes.value records from tableX have the same, limited set of keys)

Completion Criteria

• decision on whether to import
• import if necessary
• update docs
• update tests

[ANAMASGARD]

Sir @dlebauer, I’d like to work on this issue please could you assign me this , Thank You .