Skip to content

ChEBI Backend | Create table structure_layers

Create a table called structure_layers, with the following columns:

  • structure_id: A foreign key to structures table
  • layers: This column stores the result from get_registration_layers. Verify the value returned by this function before deciding the column data type.
  • hash: This column stores the result from get_registration_hash. Verify the value returned by this function before deciding the column data type.

[Edit]: We can manage layers columns as a JSON type and hash column as a VARCHAR type

Edited by Carlos Andres Moreno Velez