SchemaSpy Analysis of cxgn.genomic - Columns

Generated by SchemaSpy on Wed Sep 13 17:06 EDT 2006

Legend:

Primary key columns

Columns with indexes

Please support this project

cxgn.genomic contains 105 columns:

Column	Table	Type	Size	Nulls	Default
accession_id	library	int8	8	√	null
align_end	blast_hit	int8	8	√	null
align_start	blast_hit	int8	8	√	null
bad_clone	clone	varchar	32	√	null
basecaller	gss	varchar	32	√	null
blast_db_id	blast_db	int4	4	√	null
blast_db_id	blast_defline	int4	4	√	null
blast_db_id	blast_query	int4	4	√	null
blast_db_id	library_annotation_db	int8	8	√	null
blast_defline_id	blast_defline	int4	4	√	null
blast_defline_id	blast_hit	int4	4	√	null
blast_hit_id	blast_hit	int4	4	√	null
blast_program	blast_db	varchar	8	√	null
blast_query_id	blast_hit	int4	4	√	null
blast_query_id	blast_query	int4	4	√	null
call_positions	gss	text	-1	√	null
censor_id	chromat	int4	4	√	null
chromat_id	chromat	int4	4	√	null
chromat_id	gss	int8	8	√	null
class_name	read_class	varchar	40	√	null
clone_id	chromat	int8	8	√	null
clone_id	clone	int4	4	√	null
clone_type_id	clone	int2	2	√	null
clone_type_id	clone_type	int4	4	√	null
clone_type_id	library	int8	8	√	null
cloning_host	library_detail	varchar	80	√	null
cloning_kit	library_detail	varchar	255	√	null
comments	library_detail	text	-1	√	null
date	chromat	timestamp	8,6	√	null
date	gss	timestamp	8,6	√	null
date_generated	genbank_submission	timestamp	8,6	√	null
date_sent	genbank_submission	timestamp	8,6	√	null
db_title	blast_db	varchar	80	√	null
defline	blast_defline	text	-1	√	null
direction	chromat	bpchar	1	√	null
entropy	qc_report	float4	4	√	null
estimated_length	clone	int8	8	√	null
evalue	blast_hit	float8	8	√	null
expected_error	qc_report	float4	4	√	null
file_basename	blast_db	varchar	80	√	null
filename	chromat	varchar	50	√	null
flags	gss	int4	4	√	null
genbank_accession	clone	varchar	32	√	null
genbank_dbgss_id	gss_submitted_to_genbank	int8	8	√	null
genbank_identifier	gss_submitted_to_genbank	varchar	80	√	null
genbank_submission_id	genbank_submission	int4	4	√	null
genbank_submission_id	gss_submitted_to_genbank	int4	4	√	null
gss_id	gss	int4	4	√	null
gss_id	gss_submitted_to_genbank	int4	4	√	null
gss_id	qc_report	int8	8	√	null
gss_submitted_to_genbank_id	gss_submitted_to_genbank	int4	4	√	null
hqi_length	qc_report	int4	4	√	null
hqi_start	qc_report	int4	4	√	null
identifier	blast_defline	varchar	255	√	null
identifier	blast_hit	varchar	255	√	null
identifier_defline_fulltext	blast_defline	tsvector	-1	√	null
identity_percentage	blast_hit	float8	8	√	null
iend	qc_report	int4	4	√	null
is_contaminant	library_annotation_db	int2	2	√	null
istart	qc_report	int4	4	√	null
last_updated	blast_query	timestamp	8,6	√	null
library_annotation_db_id	library_annotation_db	int4	4	√	null
library_detail_id	library	int8	8	√	null
library_detail_id	library_detail	int4	4	√	null
library_id	clone	int8	8	√	null
library_id	library	int4	4	√	null
library_id	library_annotation_db	int8	8	√	null
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	8,6	√	null
platenum	clone	int4	4	√	null
primer	chromat	varchar	50	√	null
qc_report_id	qc_report	int4	4	√	null
qend	qc_report	int4	4	√	null
qstart	qc_report	int4	4	√	null
qual	gss	text	-1	√	null
qual_trim_threshold	qc_report	float4	4	√	null
query_source_type_id	blast_query	int4	4	√	null
query_source_type_id	query_source_type	int4	4	√	null
read_class_id	chromat	int8	8	√	null
read_class_id	read_class	int4	4	√	null
rs1	library_detail	varchar	12	√	null
rs2	library_detail	varchar	12	√	null
score	blast_hit	float8	8	√	null
seq	gss	text	-1	√	null
shortname	clone_type	varchar	12	√	null
shortname	library	varchar	16	√	null
shortname	query_source_type	varchar	15	√	null
source_id	blast_query	int4	4	√	null
source_url	blast_db	varchar	255	√	null
status	gss	int4	4	√	null
stored_hits	blast_query	int4	4	√	null
subclone_of	library	int8	8	√	null
subdir	blast_db	varchar	80	√	null
submitted_by	genbank_submission	varchar	20	√	null
subpath	chromat	text	-1	√	null
total_hits	blast_query	int4	4	√	null
vector	library_detail	varchar	80	√	null
vector_tokens	qc_report	varchar	40	√	null
version	gss	int2	2	√	null
vs_status	qc_report	int2	2	√	null
wellcol	clone	int2	2	√	null
wellrow	clone	bpchar	2	√	null