project

31 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
project_id serial 10 √ nextval('project_project_id_seq'::regclass)
project_md_image.project_id project_md_image_project_id_fkey R
project_owner.project_id project_owner_project_id_fkey R
accessionsxgenotyping_projects.genotyping_project_id Implied Constraint R
breeding_programsxgenotyping_projects.genotyping_project_id Implied Constraint R
genotyping_projects.genotyping_project_id Implied Constraint R
genotyping_projectsxgenotyping_protocols.genotyping_project_id Implied Constraint R
genotyping_projectsxlocations.genotyping_project_id Implied Constraint R
genotyping_projectsxplants.genotyping_project_id Implied Constraint R
genotyping_projectsxplots.genotyping_project_id Implied Constraint R
genotyping_projectsxseedlots.genotyping_project_id Implied Constraint R
genotyping_projectsxtrait_components.genotyping_project_id Implied Constraint R
genotyping_projectsxtraits.genotyping_project_id Implied Constraint R
genotyping_projectsxtrial_designs.genotyping_project_id Implied Constraint R
genotyping_projectsxtrial_types.genotyping_project_id Implied Constraint R
genotyping_projectsxtrials.genotyping_project_id Implied Constraint R
genotyping_projectsxyears.genotyping_project_id Implied Constraint R
materialized_genoview.genotyping_project_id Implied Constraint R
nd_experiment_project.project_id nd_experiment_project_project_id_fkey C
project_contact.project_id project_contact_project_id_fkey C
project_dbxref.project_id fkey_project_id C
project_pub.project_id project_pub_project_id_fkey C
project_relationship.object_project_id project_relationship_object_project_id_fkey C
project_relationship.subject_project_id project_relationship_subject_project_id_fkey C
projectprop.project_id projectprop_project_id_fkey C
name varchar 255 null
description text 2147483647 null
create_date timestamp 29,6 √ now()
type_id int8 19 √ null
cvterm.cvterm_id project_type_id_fkey N

An optional cvterm_id that specifies what type of project this record is. Prior to 1.4, project type was set with an projectprop.

Indexes

Constraint Name Type Sort Column(s)
project_pkey Primary key Asc project_id
project_c1 Must be unique Asc name
project_idx1 Performance Asc type_id

Relationships

Close relationships within degrees of separation