SchemaSpy Analysis of cxgn.pheno_population - Columns

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

Legend:

Primary key columns

Columns with indexes

Please support this project

cxgn.pheno_population contains 45 columns:

Column	Table	Type	Size	Nulls	Auto	Default
annotation	genotypes	varchar	128	√		null
annotation	images	varchar	128	√		null
annotation	locations	varchar	128	√		null
annotation	populations	varchar	128	√		null
annotation	properties	varchar	200	√		null
annotation	samples	varchar	128	√		null
author	sources	varchar	32	√		null
dp_id	data_points	serial	10		√	nextval('data_points_dp_id_seq'::regclass)
environment	locations	varchar	32	√		null
filepath	images	varchar	128	√		null
gen_id	genotypes	serial	10		√	nextval('genotypes_gen_id_seq'::regclass)
gen_id	plants	int8	19	√		null
gen_name	genotypes	varchar	32	√		null
image_id	data_points	int8	19	√		null
image_id	images	serial	10		√	nextval('images_image_id_seq'::regclass)
institution	locations	varchar	32	√		null
loc_id	locations	serial	10		√	nextval('locations_loc_id_seq'::regclass)
loc_id	plants	int8	19	√		null
location	sources	varchar	32	√		null
organ_id	organs	serial	10		√	nextval('organs_organ_id_seq'::regclass)
organ_id	properties	int8	19			(0)::bigint
organ_id	samples	int8	19			(0)::bigint
organ_name	organs	varchar	32			''::character varying
pedigree	populations	varchar	32	√		null
plant_id	plants	serial	10		√	nextval('plants_plant_id_seq'::regclass)
plant_id	samples	int8	19			(0)::bigint
plant_name	plants	varchar	32	√		null
pop_id	genotypes	int8	19	√		null
pop_id	populations	serial	10		√	nextval('populations_pop_id_seq'::regclass)
prop_id	data_points	int8	19			(0)::bigint
prop_id	properties	serial	10		√	nextval('properties_prop_id_seq'::regclass)
prop_name	properties	varchar	64			''::character varying
sample_group	samples	varchar	32	√		null
sample_id	data_points	int8	19			(0)::bigint
sample_id	images	int8	19	√		null
sample_id	samples	serial	10		√	nextval('samples_sample_id_seq'::regclass)
sample_name	samples	varchar	32	√		null
source_date	sources	varchar	32	√		null
source_id	data_points	int8	19	√		null
source_id	images	int8	19	√		null
source_id	sources	serial	10		√	nextval('sources_source_id_seq'::regclass)
unit_name	properties	varchar	16			''::character varying
unit_precision	properties	int8	19			(0)::bigint
value	data_points	varchar	128	√		null
year	locations	int8	19	√		null