Table cxgn.physical.fpc_data

Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
fpc_datum_id serial 10  √  nextval('fpc_data_fpc_datum_id_seq'::regclass)
bac_id int8 19 (0)::bigint
bac_name varchar 32 ''::character varying
gel_number varchar 16  √  null
map_ctg_left varchar 16  √  null
map_ctg_right varchar 16  √  null
map_ends_left float8 17,17  √  null
map_ends_right float8 17,17  √  null
creation_date date 13  √  null
modification_date date 13  √  null
bac_contig_id_left int4 10  √  null
bac_contigs.bac_contig_id fpc_data_bac_contig_id_left_fkey
bac_contig_id_right int4 10  √  null
bac_contigs.bac_contig_id fpc_data_bac_contig_id_right_fkey

Table contained 88,396 rows at Wed May 20 01:39 EDT 2009

Indexes:
Column(s) Type Sort Constraint Name
fpc_datum_id Primary key Asc fpc_data_pkey
bac_id + bac_name + gel_number + creation_date + modification_date Performance Asc/Asc/Asc/Asc/Asc bac_id_idx3

Close relationships: