raw_crs_ncrs_specimen¶
Info¶
Data contract for the CRS ncrs_specimen table data from the landing zone into raw. - name: crs_ncrs_specimen - version: 0.0.7 - status: active
Terms of Use¶
Purpose¶
Data contract for the CRS ncrs_specimen table data from the landing zone into raw.
Servers¶
| Name | Type | Attributes |
|---|---|---|
| production | databricks | No description. • environment: production • roles: [{'role': 'Admins', 'description': 'Access to all the data and settings'}] • catalog: raw_production • host: dbc-2030845a-6c3b.cloud.databricks.com • schema_: crs |
| development | databricks | No description. • environment: development • roles: [{'role': 'Admins', 'description': 'Access to all the data and settings'}] • catalog: raw_development • host: dbc-03ed8bbb-c0ec.cloud.databricks.com • schema_: crs |
Schema¶
ncrs_specimen¶
Table storing the specimen data in the raw layer of the Biocloud.
| Field | Type | Attributes |
|---|---|---|
| xmlbeschrijvingid | bigInt | Unique identifier of a CRS record • primaryKey• primaryKeyPosition: 1 |
| registrationnumber | string | Almost unique number of the specimens |
| verwijderd | int | Flag indicating if a record is moved to the recycling bin |
| datum | string | numbered representation of the date the record was created or updated (20260113) |
| tijd | string | the timestamp of the exact time the record was created or updated (13:05:11) |
| inserted_ts_utc | timestamp | UTC timestamp when record was inserted |
| updated_ts_utc | timestamp | UTC timestamp when record was last updated |