SchemaSpy Analysis of cxgn.insitu - Columns

Generated by SchemaSpy on Wed May 20 01:33 EDT 2009

Legend:

Primary key columns

Columns with indexes

Please support this project

cxgn.insitu contains 49 columns:

Column	Table	Type	Size	Nulls	Auto	Default
antibody	probe	text	2147483647	√		null
clone	probe	text	2147483647	√		null
common_name	is_organism	text	2147483647	√		null
date	experiment	date	13	√		null
dbxref_type_id	probe	int8	19	√		null
description	experiment	text	2147483647	√		null
description	image	text	2147483647	√		null
description	is_organism	text	2147483647	√		null
description	tag	text	2147483647	√		null
experiment_id	ex_tag	int8	19			(0)::bigint
experiment_id	experiment	serial	10		√	nextval('experiment_experiment_id_seq'::regclass)
experiment_id	image	int8	19			(0)::bigint
file_ext	image	text	2147483647	√		null
filename	image	text	2147483647
identifier	probe	text	2147483647	√		null
image_id	image	serial	10		√	nextval('image_image_id_seq'::regclass)
image_id	image_tag	int8	19			(0)::bigint
implied_id	tag_implication	int8	19			(0)::bigint
is_organism_id	experiment	int8	19			(0)::bigint
is_organism_id	is_organism	serial	10		√	nextval('is_organism_is_organism_id_seq'::regclass)
link	probe	text	2147483647	√		null
link_desc	probe	text	2147483647	√		null
name	experiment	text	2147483647	√		null
name	image	text	2147483647	√		null
name	is_organism	text	2147483647
name	probe	text	2147483647
name	tag	text	2147483647	√		null
obsolete	experiment	bool	1	√		null
obsolete	image	bool	1	√		null
obsolete	probe	bool	1	√		null
primer1	probe	text	2147483647	√		null
primer1_seq	probe	text	2147483647	√		null
primer2	probe	text	2147483647	√		null
primer2_seq	probe	text	2147483647	√		null
probe_id	experiment	int8	19	√		null
probe_id	probe	bigserial	19		√	nextval('probe_probe_id_seq'::regclass)
sequence	probe	text	2147483647	√		null
stage	experiment	text	2147483647	√		null
tag_id	ex_tag	int8	19			(0)::bigint
tag_id	image_tag	int8	19			(0)::bigint
tag_id	tag	bigserial	19		√	nextval('tag_tag_id_seq'::regclass)
tag_id	tag_implication	int8	19	√		null
tissue	experiment	text	2147483647	√		null
type	experiment	text	2147483647	√		null
user_id	experiment	int8	19	√		null
user_id	image	int8	19
user_id	is_organism	int8	19	√		null
user_id	probe	int8	19	√		null
user_id	tag	int8	19	√		null