nd_experiment_phenotype

3502 rows


Description

Linking table: experiments to the phenotypes they produce. There is a one-to-one relationship between an experiment and a phenotype since each phenotype record should point to one experiment. Add a new experiment_id for each phenotype record.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
nd_experiment_phenotype_id serial 10 √ nextval('nd_experiment_phenotype_nd_experiment_phenotype_id_seq'::regclass)
nd_experiment_id int4 10 null
nd_experiment.nd_experiment_id nd_experiment_phenotype_nd_experiment_id_fkey C
phenotype_id int4 10 null
phenotype.phenotype_id nd_experiment_phenotype_phenotype_id_fkey C

Indexes

Constraint Name Type Sort Column(s)
nd_experiment_phenotype_pkey Primary key Asc nd_experiment_phenotype_id
nd_experiment_phenotype_c1 Must be unique Asc/Asc nd_experiment_id + phenotype_id

Relationships

Close relationships within degrees of separation