SchemaSpy Analysis of cxgn.physical - Columns

 Generated by
SchemaSpy
Generated by SchemaSpy on Wed May 20 01:39 EDT 2009
Legend: SourceForge.net
Primary key columns
Columns with indexes
Please support this project 

Related columns Constraint names Comments Legend
cxgn.physical contains 148 columns:
Column Table Type Size Nulls Auto Default Children Parents Comments
alias bac_marker_matches text 2147483647  √  null
arizona_clone_name bac_marker_matches varchar 32  √  null
arizona_clone_name bacs varchar 32 ''::character varying
association_type bac_marker_matches text 2147483647  √  null
bac_assoc_id ba_plausibility int8 19  √  null
bac_assoc_id bac_associations serial 10  √  nextval('bac_associations_bac_assoc_id_seq'::regclass)
bac_assoc_id plausible_bacs_in_all_contigs int4 10  √  null
bac_contig_id bac_associations int8 19 (0)::bigint
bac_contig_id bac_contigs serial 10  √  nextval('bac_contigs_bac_contig_id_seq'::regclass)
fpc_data.bac_contig_id_left fpc_data_bac_contig_id_left_fkey
fpc_data.bac_contig_id_right fpc_data_bac_contig_id_right_fkey
bac_contig_id contig_sizes int8 19  √  null
bac_contig_id plausible_bacs_in_all_contigs int4 10  √  null
bac_contig_id_left fpc_data int4 10  √  null
bac_contigs.bac_contig_id fpc_data_bac_contig_id_left_fkey
bac_contig_id_right fpc_data int4 10  √  null
bac_contigs.bac_contig_id fpc_data_bac_contig_id_right_fkey
bac_id bac_associations int8 19 (0)::bigint
bac_id bac_consensus_sequences int8 19 (0)::bigint
bac_id bac_marker_matches int4 10  √  null
bac_id bacs serial 10  √  nextval('bacs_bac_id_seq'::regclass)
bac_id fpc_data int8 19 (0)::bigint
bac_id overgo_associations int8 19  √  null
bac_id overgo_results int8 19  √  null
bac_id plausible_bacs_in_all_contigs int8 19  √  null
bac_id tentative_overgo_associations int8 19  √  null
bac_map plausible_bacs_in_all_contigs int8 19  √  null
bac_name fpc_data varchar 32 ''::character varying
bac_plausible plausible_bacs_in_all_contigs int2 5  √  null
bad_clone bacs int2 5 (0)::smallint
bap_id ba_plausibility bigserial 19  √  nextval('ba_plausibility_bap_id_seq'::regclass)
clone_id computational_associations int4 10
clone_id manual_associations int4 10
col_max overgo_plates int8 19 (0)::bigint
comment manual_associations text 2147483647  √  null
comments fpc_version text 2147483647  √  null
comments overgo_version text 2147483647  √  null
computational_assoc_id computational_associations serial 10  √  nextval('computational_associations_computational_assoc_id_seq'::regclass)
confidence_id bac_marker_matches int4 10  √  null
conflict_group_id tentative_association_conflict_groups int8 19  √  null
consensus_seq_id bac_consensus_sequences serial 10  √  nextval('bac_consensus_sequences_consensus_seq_id_seq'::regclass)
consensus_seq_name bac_consensus_sequences varchar 32  √  null
contig_name bac_contigs varchar 16 ''::character varying
contig_name bac_marker_matches varchar 16  √  null
contig_name plausible_bacs_in_all_contigs varchar 16  √  null
contig_size contig_sizes float8 17,17  √  null
contig_size_id contig_sizes bigserial 19  √  nextval('contig_sizes_contig_size_id_seq'::regclass)
cornell_clone_name bac_marker_matches varchar 16  √  null
cornell_clone_name bacs varchar 16 ''::character varying
creation_date fpc_data date 13  √  null
current fpc_version int2 5  √  null
current overgo_version int2 5  √  null
dp_id deprecated_probes serial 10  √  nextval('deprecated_probes_dp_id_seq'::regclass)
e_value computational_associations float8 17,17  √  null
empty_wells overgo_plates int8 19 (0)::bigint
end_id bac_end_sequences int2 5 (0)::smallint
end_seq_id bac_end_sequences serial 10  √  nextval('bac_end_sequences_end_seq_id_seq'::regclass)
estimated_length bac_marker_matches int8 19  √  null
estimated_length bacs int8 19  √  null
fasta_sequence bac_consensus_sequences text 2147483647
fasta_sequence bac_end_sequences text 2147483647
fpc_datum_id fpc_data serial 10  √  nextval('fpc_data_fpc_datum_id_seq'::regclass)
fpc_version bac_contigs int8 19 (0)::bigint
fpc_version bac_marker_matches int8 19  √  null
fpc_version fpc_version serial 10  √  nextval('fpc_version_fpc_version_seq'::regclass)
fpc_version plausible_bacs_in_all_contigs int8 19  √  null
fpcfile fpc_version varchar 32  √  null
full_name users varchar 64 ''::character varying
gel_number fpc_data varchar 16  √  null
genbank_accession bacs varchar 32  √  null
identity computational_associations float8 17,17  √  null
includes_sp6_end bac_consensus_sequences int2 5  √  null
includes_t7_end bac_consensus_sequences int2 5  √  null
length bac_consensus_sequences int8 19 (0)::bigint
length bac_end_sequences int8 19 (0)::bigint
lg_id bac_marker_matches int4 10  √  null
lg_name bac_marker_matches text 2147483647  √  null
lg_order bac_marker_matches int4 10  √  null
library_id bacs int4 10  √  null
long_name species varchar 64  √  null
manual_assoc_id manual_associations serial 10  √  nextval('manual_associations_manual_assoc_id_seq'::regclass)
map_ctg_left fpc_data varchar 16  √  null
map_ctg_right fpc_data varchar 16  √  null
map_ends_left fpc_data float8 17,17  √  null
map_ends_right fpc_data float8 17,17  √  null
map_id ba_plausibility int8 19  √  null
map_id oa_plausibility int8 19  √  null
marker_id bac_marker_matches int4 10  √  null
marker_id computational_associations int4 10
marker_id manual_associations int4 10
marker_id probe_markers int8 19  √  null
marker_seq probe_markers text 2147483647  √  null
modification_date fpc_data date 13  √  null
net_id users varchar 16 ''::character varying
number_of_bacs bac_marker_matches int8 19  √  null
oap_id oa_plausibility bigserial 19  √  nextval('oa_plausibility_oap_id_seq'::regclass)
overgo_assoc_id oa_plausibility int8 19  √  null
overgo_assoc_id overgo_associations serial 10  √  nextval('overgo_associations_overgo_assoc_id_seq'::regclass)
overgo_assoc_id plausible_bacs_in_all_contigs int4 10  √  null
overgo_map plausible_bacs_in_all_contigs int8 19  √  null
overgo_plate_col probe_markers int8 19  √  null
overgo_plate_id overgo_results int8 19  √  null
overgo_plate_id probe_markers int8 19  √  null
overgo_plate_row probe_markers varchar 4  √  null
overgo_plausible plausible_bacs_in_all_contigs int2 5  √  null
overgo_pool overgo_results bpchar 2  √  null
overgo_probe_id deprecated_probes int8 19  √  null
overgo_probe_id overgo_associations int8 19  √  null
overgo_probe_id plausible_bacs_in_all_contigs int8 19  √  null
overgo_probe_id probe_markers serial 10  √  nextval('probe_markers_overgo_probe_id_seq'::regclass)
overgo_probe_id tentative_overgo_associations int8 19  √  null
overgo_seq_a probe_markers varchar 30  √  null
overgo_seq_ab probe_markers varchar 30  √  null
overgo_seq_b probe_markers varchar 30  √  null
overgo_version deprecated_probes int8 19  √  null
overgo_version overgo_associations int8 19  √  null
overgo_version overgo_version serial 10  √  nextval('overgo_version_overgo_version_seq'::regclass)
overgo_version plausible_bacs_in_all_contigs int8 19  √  null
overgo_version tentative_overgo_associations int8 19  √  null
parameters computational_associations text 2147483647  √  null
plate_id overgo_plates serial 10  √  nextval('overgo_plates_plate_id_seq'::regclass)
plate_number overgo_plates int8 19 (0)::bigint
plate_size overgo_plates int8 19  √  null
plausible ba_plausibility int2 5 (0)::smallint
plausible bac_associations int2 5 (0)::smallint
plausible oa_plausibility int2 5 (0)::smallint
plausible overgo_associations int2 5 (0)::smallint
position bac_marker_matches numeric 8,5  √  null
pubmed_id manual_associations int4 10  √  null
q_end computational_associations int8 19  √  null
q_start computational_associations int8 19  √  null
result_id overgo_results serial 10  √  nextval('overgo_results_result_id_seq'::regclass)
row_max overgo_plates varchar 4 ''::character varying
s_end computational_associations int8 19  √  null
s_start computational_associations int8 19  √  null
score computational_associations float8 17,17  √  null
short_name species varchar 32  √  null
sp6_end_seq_id bacs int8 19  √  null
sp_person_id manual_associations int4 10  √  null
species_id bacs int8 19 (0)::bigint
species_id species serial 10  √  nextval('species_species_id_seq'::regclass)
t7_end_seq_id bacs int8 19  √  null
tacg_id tentative_association_conflict_groups serial 10  √  nextval('tentative_association_conflict_groups_tacg_id_seq'::regclass)
tentative_assoc_id tentative_association_conflict_groups int8 19  √  null
tentative_assoc_id tentative_overgo_associations serial 10  √  nextval('tentative_overgo_associations_tentative_assoc_id_seq'::regclass)
tracefile bac_consensus_sequences varchar 64 ''::character varying
tracefile bac_end_sequences varchar 64 ''::character varying
updated_by fpc_version int8 19 (0)::bigint
updated_by overgo_version int8 19  √  null
updated_on fpc_version date 13 ('now'::text)::date
updated_on overgo_version timestamp 29,6 ('now'::text)::timestamp(6) with time zone
user_id users serial 10  √  nextval('users_user_id_seq'::regclass)