Schema Version: 1.3

nd_experiment


Description

This is the core table for the natural diversity module, representing each individual assay that is undertaken (this is usually not an entire experiment). Each nd_experiment should give rise to a single genotype or phenotype and be described via 1 (or more) protocols. Collections of assays that relate to each other should be linked to the same record in the project table.

Columns

Column Type Size Foreign Key Nullable Default Comments
nd_experiment_id bigserial 19
nextval('chado.nd_experiment_nd_experiment_id_seq'::regclass)
nd_geolocation_id int8 19
nd_geolocation.nd_geolocation_id nd_experiment_nd_geolocation_id_fkey C
null
type_id int8 19
cvterm.cvterm_id nd_experiment_type_id_fkey C
null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
nd_experiment_pkey Primary key Asc nd_experiment_id
nd_experiment_idx1 Performance Asc nd_geolocation_id
nd_experiment_idx2 Performance Asc type_id

Relationships

The following entity relationship (ER) diagram shows the relationships involving the nd_experiment table.

Show relationships within degrees of separation