enriched_additional_number¶
Info¶
Data contract for the Additional Number table of the dna domain of the Biocloud. Contains additional identifiers and reference numbers associated with material entities. - name: Additional Number - version: 0.0.1 - status: active
Terms of Use¶
Purpose¶
Data contract for the Additional Number table of the dna domain of the Biocloud. Contains additional identifiers and reference numbers associated with material entities.
Servers¶
| Name | Type | Attributes |
|---|---|---|
| production | databricks | No description. • environment: production • roles: [{'role': 'Admins', 'description': 'Access to all the data and settings'}] • catalog: dna_production • host: dbc-2030845a-6c3b.cloud.databricks.com • schema_: enriched |
| development | databricks | No description. • environment: development • roles: [{'role': 'Admins', 'description': 'Access to all the data and settings'}] • catalog: dna_development • host: dbc-03ed8bbb-c0ec.cloud.databricks.com • schema_: enriched |
Schema¶
additional_number¶
The additional number table contains supplementary identifiers and reference numbers associated with material entities. Specimens often have multiple catalog numbers, field numbers, or other identifiers from different systems.
| Field | Type | Attributes |
|---|---|---|
| additional_number_id | bigint | Biocloud generated identifier for the additional number record. • primaryKey• primaryKeyPosition: 1 • required |
| material_entity_id | bigint | Foreign key to the material entity table, linking this additional number to a specimen. |
| number_type | string | Type or category of the additional number (e.g., field number, collector number, museum number). • examples: ['field number', 'GenBank accession', 'BOLD ID', 'museum catalog number'] |
| number_value | string | The actual value of the additional number/identifier. • examples: ['ABC123', 'MK123456', 'BOLD:AAA1234'] |
| number_comment | string | Additional comments or context about this number. |
| source_id | string | The ID of this record in the source system. • required |
| source | string | The name of the source system used to create this record in the table. • required• examples: ['sampling-sheet', 'ada'] |
| inserted_ts_utc | timestamp | UTC timestamp when record was inserted. |
| updated_ts_utc | timestamp | UTC timestamp when record was last updated. |