Schema Version: 1.3

library


Columns

Column Type Size Foreign Key Nullable Default Comments
library_id bigserial 19
nextval('chado.library_library_id_seq'::regclass)
organism_id int8 19
organism.organism_id library_organism_id_fkey R
null
name varchar 255
null
uniquename text 2147483647
null
type_id int8 19
cvterm.cvterm_id library_type_id_fkey R
null

The type_id foreign key links to a controlled vocabulary of library types. Examples of this would be: "cDNA_library" or "genomic_library"

is_obsolete int4 10
0
timeaccessioned timestamp 29,6
now()
timelastmodified timestamp 29,6
now()

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
library_pkey Primary key Asc library_id
library_c1 Must be unique Asc/Asc/Asc organism_id + uniquename + type_id
library_contact_idx1 Performance Asc library_id
library_idx1 Performance Asc organism_id
library_idx2 Performance Asc type_id
library_idx3 Performance Asc uniquename
library_name_ind1 Performance Asc name

Relationships