snp

0 rows

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

snp_id

serial

10

√

nextval('sgn.snp_snp_id_seq'::regclass)

snp_file.snp_id	snp_file_snp_id_fkey	R
snpprop.snp_id	snpprop_snp_id_fkey	R

marker_id

int4

10

√

null

marker.marker_id

snp_marker_id_fkey

R

reference_nucleotide

varchar

4

√

null

snp_nucleotide

varchar

4

null

confirmed

bool

1

√

false

sequence_left_id

int4

10

√

null

sequence.sequence_id

snp_sequence_left_id_fkey

R

sequence_right_id

int4

10

√

null

sequence.sequence_id

snp_sequence_right_id_fkey

R

reference_stock_id

int4

10

√

null

stock.stock_id

snp_reference_stock_id_fkey

R

stock_id

int4

10

null

stock.stock_id

snp_stock_id_fkey

R

metadata_id

int4

10

√

null

md_metadata.metadata_id

snp_metadata_id_fkey

R

Indexes

Constraint Name	Type	Sort	Column(s)
snp_pkey	Primary key	Asc	snp_id

Relationships

Close relationships within degrees of separation