library

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
library_id serial 10 √ nextval('sgn.library_library_id_seq'::regclass)
clone.library_id library_id_fk R
type int8 19 √ null
types.type_id type_fkey R
submit_user_id int4 10 √ null
submit_user.submit_user_id Implied Constraint R
library_name varchar 80 √ null
library_shortname varchar 16 √ null
authors varchar 255 √ null
organism_id int4 10 √ null
organism.organism_id Implied Constraint R
cultivar varchar 255 √ null
accession varchar 255 √ null
tissue varchar 255 √ null
development_stage varchar 255 √ null
treatment_conditions text 2147483647 √ null
cloning_host varchar 80 √ null
vector varchar 80 √ null
rs1 varchar 12 √ null
rs2 varchar 12 √ null
cloning_kit varchar 255 √ null
comments text 2147483647 √ null
contact_information text 2147483647 √ null
order_routing_id int8 19 √ null
sp_person_id int4 10 √ null
sp_person.sp_person_id library_sp_person_id_fkey R
forward_adapter varchar 2147483647 √ null
reverse_adapter varchar 2147483647 √ null
obsolete bool 1 √ null
modified_date timestamptz 35,6 √ null
create_date timestamptz 35,6 √ null
chado_organism_id int4 10 √ null
organism.organism_id library_chado_organism_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
library_pkey Primary key Asc library_id
library_shortname_idx Must be unique Asc library_shortname
organism_id_idx Performance Asc organism_id
submit_user_id_idx2 Performance Asc submit_user_id

Relationships

Close relationships within degrees of separation