Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.all_cellline_derivation
A record in this table represents the Derivation of a Cell Line. See ALL_CellLine.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
_derivation_key serial 10  √  nextval('all_cellline_derivation_seq'::regclass)
all_cellline._derivation_key all_cellline__derivation_key_fkey R
primary key
name text 2147483647  √  null Cell Line Library Name
description text 2147483647  √  null longer name
_vector_key int4 10
voc_term._term_key all_cellline_derivation__vector_key_fkey R
foreign key to VOC_Term where _Vocab_key = = 72 (Cell Line Vector Name)
_vectortype_key int4 10
voc_term._term_key all_cellline_derivation__vectortype_key_fkey R
foreign key to VOC_Term where _Vocab_key = 64 (Cell Line Vector Type)
_parentcellline_key int4 10
all_cellline._cellline_key all_cellline_derivation__parentcellline_key_fkey R
foreign key to ALL_CellLine
_derivationtype_key int4 10
voc_term._term_key all_cellline_derivation__derivationtype_key_fkey R
foreign key to VOC_Term where _Vocab_key = 38 (Allele Type)
_creator_key int4 10
voc_term._term_key all_cellline_derivation__creator_key_fkey R
foreign key to VOC_Term where _Vocab_key = 62 (Cell Line Creator)
_refs_key int4 10  √  null
bib_refs._refs_key all_cellline_derivation__refs_key_fkey R
foreign key to BIB_Refs
_createdby_key int4 10 1001
mgi_user._user_key all_cellline_derivation__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key all_cellline_derivation__modifiedby_key_fkey R
user who last modified the record
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 3,152 rows at Mon Sep 11 06:12 EDT 2023

Indexes:
Column(s) Type Sort Constraint Name
_derivation_key Primary key, Used to cluster data Asc all_cellline_derivation_pkey
_createdby_key Performance Asc all_cellline_derivation_idx_createdby_key
creation_date Performance Asc all_cellline_derivation_idx_creation_date
_creator_key Performance Asc all_cellline_derivation_idx_creator_key
_derivationtype_key + _parentcellline_key + _creator_key Performance Asc/Asc/Asc all_cellline_derivation_idx_derivationtype_key
modification_date Performance Asc all_cellline_derivation_idx_modification_date
_modifiedby_key Performance Asc all_cellline_derivation_idx_modifiedby_key
name + _derivation_key Performance Asc/Asc all_cellline_derivation_idx_name
_parentcellline_key + _derivation_key Performance Asc/Asc all_cellline_derivation_idx_pcl
_refs_key Performance Asc all_cellline_derivation_idx_refs_key
_vector_key Performance Asc all_cellline_derivation_idx_vector_key
_vectortype_key Performance Asc all_cellline_derivation_idx_vectortype_key

Close relationships  within of separation: