PREPARATION
Contents: paleontoloogilised preparaadid
Description: Siia kantakse kõi preparaadid, sh. need mis tulenevad kindlatest proovidest kui ka näidispreparaadid jms. mis võivad sisaldada eri proovidest pärinevat materjali.
Referencing tables: attachment_link | preparation_taxa | taxon_list |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | User who first saved record | |
| date_added | datetime | Timestamp when record was created | |
| user_changed | varchar | User who last saved record | |
| date_changed | datetime | ||
| preparation_number | varchar | preparaadi unikaalne number | |
| sample_number | varchar | proovi number | |
| sample | int | proovi unikaalne number | sample |
| sample_palaeontology_id | int | ||
| analysis | int | analysis | |
| taxon | int | objektide hierarhiline kuuluvus | taxon |
| agent | int | agent | |
| agent_txt | varchar | ||
| date_prepared | date | ||
| date_prepared_txt | varchar | ||
| identification_agent | int | agent | |
| identification_date | date | ||
| identification_remarks | varchar | ||
| location | varchar | preparaadi asukoht | |
| storage | int | location | |
| remarks | text | lisainfo vabas vormis | |
| owner | int | agent | |
| public | tinyint | ||
| is_private | tinyint | ||
| id | int(auto increment) | Automatically generated unique sequential primary key (record ID) | |
| database | int | database | |
| timestamp | datetime | ajatempel, mis kajastab samuti andmete viimast muutmist, sisestab andmebaasimootor | |
| attachments | int | attachment |
