Columns
| Table | Type | Column | Type | Size | Nulls | Default | Comments |
|---|---|---|---|---|---|---|---|
| libraryprop | Table | libraryprop_id | bigserial | 19 | nextval('library.libraryprop_libraryprop_id_seq'::regclass) | ||
| library_featureprop | Table | value | text | 2147483647 | √ | null | |
| library_pub | Table | pub_id | int8 | 19 | null | ||
| library_synonym | Table | library_synonym_id | bigserial | 19 | nextval('library.library_synonym_library_synonym_id_seq'::regclass) | ||
| libraryprop | Table | rank | int4 | 10 | 0 | ||
| library_pub | Table | library_pub_id | bigserial | 19 | nextval('library.library_pub_library_pub_id_seq'::regclass) | ||
| libraryprop_pub | Table | libraryprop_id | int8 | 19 | null | ||
| library | Table | timelastmodified | timestamp | 29 | now() | ||
| library_dbxref | Table | is_current | bool | 1 | true | ||
| library_contact | Table | library_id | int8 | 19 | null | ||
| library_relationship_pub | Table | library_relationship_id | int8 | 19 | null | ||
| library_expressionprop | Table | type_id | int8 | 19 | null | ||
| library_contact | Table | library_contact_id | bigserial | 19 | nextval('library.library_contact_library_contact_id_seq'::regclass) | ||
| library_contact | Table | contact_id | int8 | 19 | null | ||
| library | Table | is_obsolete | int4 | 10 | 0 | ||
| library_relationship | Table | type_id | int8 | 19 | null | ||
| library_relationship_pub | Table | library_relationship_pub_id | bigserial | 19 | nextval('library.library_relationship_pub_library_relationship_pub_id_seq'::regclass) | ||
| library_dbxref | Table | library_id | int8 | 19 | null | ||
| library | Table | library_id | bigserial | 19 | nextval('library.library_library_id_seq'::regclass) | ||
| library_dbxref | Table | dbxref_id | int8 | 19 | null | ||
| library_cvterm | Table | library_id | int8 | 19 | null | ||
| library | Table | name | varchar | 255 | √ | null | |
| library | Table | organism_id | int8 | 19 | null | ||
| libraryprop | Table | library_id | int8 | 19 | null | ||
| library_synonym | Table | is_current | bool | 1 | true | The is_current bit indicates whether the linked synonym is the current -official- symbol for the linked library. |
|
| library_synonym | Table | is_internal | bool | 1 | false | Typically a synonym exists so that somebody querying the database with an obsolete name can find the object they are looking for under its current name. If the synonym has been used publicly and deliberately (e.g. in a paper), it my also be listed in reports as a synonym. If the synonym was not used deliberately (e.g., there was a typo which went public), then the is_internal bit may be set to "true" so that it is known that the synonym is "internal" and should be queryable but should not be listed in reports as a valid synonym. |
|
| library_dbxref | Table | library_dbxref_id | bigserial | 19 | nextval('library.library_dbxref_library_dbxref_id_seq'::regclass) | ||
| libraryprop | Table | type_id | int8 | 19 | null | ||
| library | Table | timeaccessioned | timestamp | 29 | now() | ||
| library_relationship | Table | subject_id | int8 | 19 | null | ||
| library_feature | Table | library_id | int8 | 19 | null | ||
| library | Table | uniquename | text | 2147483647 | null | ||
| library_expressionprop | Table | library_expressionprop_id | bigserial | 19 | nextval('library.library_expressionprop_library_expressionprop_id_seq'::regclass) | ||
| library_synonym | Table | synonym_id | int8 | 19 | null | ||
| library_expressionprop | Table | value | text | 2147483647 | √ | null | |
| library_relationship | Table | object_id | int8 | 19 | null | ||
| library_cvterm | Table | library_cvterm_id | bigserial | 19 | nextval('library.library_cvterm_library_cvterm_id_seq'::regclass) | ||
| libraryprop | Table | value | text | 2147483647 | √ | null | |
| library_pub | Table | library_id | int8 | 19 | null | ||
| library_feature | Table | library_feature_id | bigserial | 19 | nextval('library.library_feature_library_feature_id_seq'::regclass) | ||
| library_synonym | Table | library_id | int8 | 19 | null | ||
| libraryprop_pub | Table | pub_id | int8 | 19 | null | ||
| library_expression | Table | expression_id | int8 | 19 | null | ||
| library | Table | type_id | int8 | 19 | null | The type_id foreign key links to a controlled vocabulary of library types. Examples of this would be: "cDNA_library" or "genomic_library" |
|
| library_featureprop | Table | rank | int4 | 10 | 0 | ||
| library_expressionprop | Table | rank | int4 | 10 | 0 | ||
| library_cvterm | Table | cvterm_id | int8 | 19 | null | ||
| library_expression | Table | library_expression_id | bigserial | 19 | nextval('library.library_expression_library_expression_id_seq'::regclass) | ||
| library_featureprop | Table | library_featureprop_id | bigserial | 19 | nextval('library.library_featureprop_library_featureprop_id_seq'::regclass) | ||
| library_feature | Table | feature_id | int8 | 19 | null | ||
| library_relationship | Table | library_relationship_id | bigserial | 19 | nextval('library.library_relationship_library_relationship_id_seq'::regclass) | ||
| library_synonym | Table | pub_id | int8 | 19 | null | The pub_id link is for relating the usage of a given synonym to the publication in which it was used. |
|
| library_expressionprop | Table | library_expression_id | int8 | 19 | null | ||
| libraryprop_pub | Table | libraryprop_pub_id | bigserial | 19 | nextval('library.libraryprop_pub_libraryprop_pub_id_seq'::regclass) | ||
| library_cvterm | Table | pub_id | int8 | 19 | null | ||
| library_expression | Table | pub_id | int8 | 19 | null | ||
| library_expression | Table | library_id | int8 | 19 | null | ||
| library_featureprop | Table | library_feature_id | int8 | 19 | null | ||
| library_featureprop | Table | type_id | int8 | 19 | null | ||
| library_relationship_pub | Table | pub_id | int8 | 19 | null |