Table cxgn.sgn_bt.rflp_markers

Generated by
SchemaSpy

Legend:

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

rflp_id

serial

10

√

nextval('rflp_markers_rflp_id_seq'::regclass)

marker_experiment.rflp_experiment_id

marker_experiment_rflp_experiment_id_fkey

marker_id

int8

19

(0)::bigint

marker.marker_id

marker_id_fk

rflp_name

varchar

64

''::character varying

library_name

varchar

64

√

null

clone_name

varchar

16

√

null

vector

varchar

32

√

null

cutting_site

varchar

32

√

null

forward_seq_id

int8

19

√

null

rflp_sequences.seq_id

forward_seq_id_fk

reverse_seq_id

int8

19

√

null

rflp_sequences.seq_id

reverse_seq_id_fk

insert_size

int8

19

(0)::bigint

drug_resistance

varchar

16

√

null

marker_prefix

varchar

8

√

null

marker_suffix

int2

5

√

null

cxgn_production_visible

bool

1

√

false

Table contained 665 rows at Thu Jun 21 23:03 EDT 2007

Indexes:

Column(s)	Type	Sort	Constraint Name
rflp_id	Primary key	Asc	rflp_markers_pkey
rflp_name + marker_id + library_name + marker_prefix + vector + cutting_site	Performance	Asc/Asc/Asc/Asc/Asc/Asc	rflp_name_idx