Basic columns
Deep Origin supports several types of basic columns.
Type | Description |
---|---|
ID | Unique auto-generated alphanumeric string for each row. IDs can be used to create references between rows. IDs are permanent. They cannot be changed. |
Date | Captures dates, such as when each sample was collected. |
Float | Captures decimal quantitative values, such as abundance measurements. |
File | Captures raw files such as sequence reads, microscopy images, processed results, and reports such as PDFs. Learn more. |
Integer | Captures integer quantitative values, such as numbers of raw sequence reads. |
Select | Captures one or more options from a list of options. One use case is to categorize rows. |
Text | Captures strings, such as names or descriptions. |
URL | Captures hyperlinks. When clicked, links are opened in new tabs. |
User | Captures users. One use case is to case the individual who signed off on an experiment. |
Yes/No | Capture binary values, such as "true/false" and "yes/no". |
Submission status | Choose between "Draft" and "Final". Useful to indicate finalized data for analysis |
Creation context | Records the context where the database row is created |
Date created | Captures the date when each row was created. This column is automatically created and its value it automatically set. Users cannot edit these columns. |
Date updated | Captures the date when each row was last updated. This column is automatically created and its value is automatically updated. Users cannot edit these columns. |
Created by | Capture the user who created each row. |
Edited by | Capture the user who last updated each row. |