DATABASE SCHEMA

Explore data model:

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 Database column Data type Description Referenced table
agent agent_id int agent
agent_txt agent_txt varchar
date_added date_added datetime Timestamp when record was created
date_changed date_changed datetime
date_prepared date_prepared date
date_prepared_txt date_prepared_txt varchar
id id int(auto increment) Automatically generated unique sequential primary key (record ID)
identification_agent identification_agent int agent
identification_date identification_date date
identification_remarks identification_remarks varchar
location location varchar preparaadi asukoht
owner owner int agent
preparation_number preparation_number varchar preparaadi unikaalne number
public public int
remarks remarks text lisainfo vabas vormis
sample sample int proovi unikaalne number sample
sample_number sample_number varchar proovi number
sample_palaeontology sample_palaeontology int sample_palaeontology
storage storage_id int location
taxon class_id int objektide hierarhiline kuuluvus taxon
timestamp timestamp datetime ajatempel, mis kajastab samuti andmete viimast muutmist, sisestab andmebaasimootor
user_added user_added varchar User who first saved record
user_changed user_changed varchar User who last saved record