SchemaSpy Analysis of cxgn.genomic_bt - Columns

 Generated by
SchemaSpy
Generated by SchemaSpy on Thu Jun 21 23:00 EDT 2007
Legend: SourceForge.net
Primary key columns
Columns with indexes
Please support this project 

Related columns Constraint names Comments Legend
cxgn.genomic_bt contains 123 columns:
Column Table Type Size Nulls Auto Default Children Parents Comments
accession_id library int8 19  √  null
align_end blast_hit int8 19  √  null
align_start blast_hit int8 19  √  null
bad_clone clone varchar 32  √  null
basecaller gss varchar 32  √  null
blast_db_id blast_db serial 10  √  nextval('blast_db_blast_db_id_seq'::regclass)
blast_query.blast_db_id blast_query_blast_db_id_fkey
blast_db_id blast_defline int4 10  √  null
blast_db_id blast_query int4 10  √  null
blast_db.blast_db_id blast_query_blast_db_id_fkey
blast_db_id library_annotation_db int8 19 (0)::bigint
blast_defline_id blast_defline serial 10  √  nextval('blast_defline_blast_defline_id_seq'::regclass)
blast_defline_id blast_hit int4 10  √  null
blast_hit_id blast_hit serial 10  √  nextval('blast_hit_blast_hit_id_seq'::regclass)
blast_program blast_db varchar 8  √  null
blast_query_id blast_hit int4 10  √  null
blast_query.blast_query_id blast_hit_blast_query_id_fkey
blast_query_id blast_query serial 10  √  nextval('blast_query_blast_query_id_seq'::regclass)
blast_hit.blast_query_id blast_hit_blast_query_id_fkey
call_positions gss text 2147483647  √  null
censor_id chromat int4 10  √  null
chromat_id chromat bigserial 19  √  nextval('chromat_chromat_id_seq'::regclass)
gss.chromat_id gss_chromat_id_fkey
chromat_id gss int8 19  √  null
chromat.chromat_id gss_chromat_id_fkey
class_name read_class varchar 40  √  null
clone_id chromat int8 19  √  null
clone.clone_id chromat_clone_id_fkey
clone_id clone serial 10  √  nextval('clone_clone_id_seq'::regclass)
chromat.clone_id chromat_clone_id_fkey
clone_type_id clone int2 5 (0)::smallint
clone_type.clone_type_id clone_clone_type_id_fkey
clone_type_id clone_type serial 10  √  nextval('clone_type_clone_type_id_seq'::regclass)
clone.clone_type_id clone_clone_type_id_fkey
library.clone_type_id library_clone_type_id_fkey
clone_type_id library int8 19 (0)::bigint
clone_type.clone_type_id library_clone_type_id_fkey
cloning_host library_detail varchar 80  √  null
cloning_kit library_detail varchar 255  √  null
comments library_detail text 2147483647  √  null
cxgn_production_visible blast_db bool 1  √  false
cxgn_production_visible blast_defline bool 1  √  false
cxgn_production_visible blast_hit bool 1  √  false
cxgn_production_visible blast_query bool 1  √  false
cxgn_production_visible chromat bool 1  √  false
cxgn_production_visible clone bool 1  √  false
cxgn_production_visible clone_type bool 1  √  false
cxgn_production_visible genbank_submission bool 1  √  false
cxgn_production_visible gss bool 1  √  false
cxgn_production_visible gss_submitted_to_genbank bool 1  √  false
cxgn_production_visible library bool 1  √  false
cxgn_production_visible library_annotation_db bool 1  √  false
cxgn_production_visible library_detail bool 1  √  false
cxgn_production_visible qc_report bool 1  √  false
cxgn_production_visible query_source_type bool 1  √  false
cxgn_production_visible read_class bool 1  √  false
date chromat timestamp 29,6 ('now'::text)::timestamp(6) with time zone
date gss timestamp 29,6 ('now'::text)::timestamp(6) with time zone
date_generated genbank_submission timestamp 29,6  √  null
date_sent genbank_submission timestamp 29,6  √  null
db_title blast_db varchar 80  √  null
defline blast_defline text 2147483647  √  null
direction chromat bpchar 1  √  null
entropy qc_report float4 8,8  √  null
estimated_length clone int8 19  √  null
evalue blast_hit float8 17,17  √  null
expected_error qc_report float4 8,8  √  null
file_basename blast_db varchar 80  √  null
filename chromat varchar 50 ''::character varying
flags gss int4 10  √  null
genbank_accession clone varchar 32  √  null
genbank_dbgss_id gss_submitted_to_genbank int8 19  √  null
genbank_identifier gss_submitted_to_genbank varchar 80  √  null
genbank_submission_id genbank_submission serial 10  √  nextval('genbank_submission_genbank_submission_id_seq'::regclass)
gss_submitted_to_genbank.genbank_submission_id gss_submitted_to_genbank_genbank_submission_id_fkey
genbank_submission_id gss_submitted_to_genbank int4 10 0
genbank_submission.genbank_submission_id gss_submitted_to_genbank_genbank_submission_id_fkey
gss_id gss serial 10  √  nextval('gss_gss_id_seq'::regclass)
gss_submitted_to_genbank.gss_id gss_submitted_to_genbank_gss_id_fkey
qc_report.gss_id qc_report_gss_id_fkey
gss_id gss_submitted_to_genbank int4 10 0
gss.gss_id gss_submitted_to_genbank_gss_id_fkey
gss_id qc_report int8 19 (0)::bigint
gss.gss_id qc_report_gss_id_fkey
gss_submitted_to_genbank_id gss_submitted_to_genbank serial 10  √  nextval('gss_submitted_to_genbank_gss_submitted_to_genbank_id_seq'::regclass)
hqi_length qc_report int4 10  √  null
hqi_start qc_report int4 10  √  null
identifier blast_defline varchar 255  √  null
identifier blast_hit varchar 255  √  null
identifier_defline_fulltext blast_defline tsvector 2147483647  √  null
identity_percentage blast_hit float8 17,17  √  null
iend qc_report int4 10  √  null
is_contaminant library_annotation_db int2 5 (0)::smallint
istart qc_report int4 10  √  null
last_updated blast_query timestamp 29,6 ('now'::text)::timestamp(6) with time zone
library_annotation_db_id library_annotation_db serial 10  √  nextval('library_annotation_db_library_annotation_db_id_seq'::regclass)
library_detail_id library int8 19  √  null
library_detail.library_detail_id library_library_detail_id_fkey
library_detail_id library_detail serial 10  √  nextval('library_detail_library_detail_id_seq'::regclass)
library.library_detail_id library_library_detail_id_fkey
library_id clone int8 19  √  null
library.library_id clone_library_id_fkey
library_id library serial 10  √  nextval('library_library_id_seq'::regclass)
clone.library_id clone_library_id_fkey
library_id library_annotation_db int8 19 (0)::bigint
lookup_url blast_db varchar 120  √  null
name clone_type varchar 40  √  null
name library varchar 80  √  null
name query_source_type varchar 255  √  null
ncbi_reply_date genbank_submission timestamp 29,6  √  null
platenum clone int4 10  √  null
primer chromat varchar 50  √  null
qc_report_id qc_report serial 10  √  nextval('qc_report_qc_report_id_seq'::regclass)
qend qc_report int4 10  √  null
qstart qc_report int4 10  √  null
qual gss text 2147483647  √  null
qual_trim_threshold qc_report float4 8,8  √  null
query_source_type_id blast_query int4 10  √  null
query_source_type.query_source_type_id blast_query_query_source_type_id_fkey
query_source_type_id query_source_type serial 10  √  nextval('query_source_type_query_source_type_id_seq'::regclass)
blast_query.query_source_type_id blast_query_query_source_type_id_fkey
read_class_id chromat int8 19  √  null
read_class_id read_class serial 10  √  nextval('read_class_read_class_id_seq'::regclass)
rs1 library_detail varchar 12  √  null
rs2 library_detail varchar 12  √  null
score blast_hit float8 17,17  √  null
seq gss text 2147483647  √  null
shortname clone_type varchar 12  √  null
shortname library varchar 16 ''::character varying
shortname query_source_type varchar 15  √  null
source_id blast_query int4 10  √  null
source_url blast_db varchar 255  √  null
status gss int4 10  √  null
stored_hits blast_query int4 10  √  null
subclone_of library int8 19  √  null
subdir blast_db varchar 80  √  null
submitted_by genbank_submission varchar 20  √  null
subpath chromat text 2147483647
total_hits blast_query int4 10  √  null
vector library_detail varchar 80  √  null
vector_ligation_1 library_detail int4 10  √  null the string index in sgn.cloning_vector.seq after which inserts are ligated
vector_ligation_2 library_detail int4 10  √  null the string index in sgn.cloning_vector.seq before which inserts are ligated
vector_tokens qc_report varchar 40  √  null
version gss int2 5  √  null
vs_status qc_report int2 5  √  null
wellcol clone int2 5  √  null
wellrow clone bpchar 2  √  null