Table cxgn.phenome.individual_allele

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

individual_allele_id

serial

√

nextval('individual_allele_individual_allele_id_seq'::regclass)

individual_id

int8

individual.individual_id

individual_allele_individual_id_fkey

allele_id

int8

allele.allele_id

individual_allele_allele_id_fkey

sp_person_id

int8

√

null

create_date

timestamptz

35,6

√

now()

modified_date

timestamptz

35,6

√

null

obsolete

bool

√

false

Table contained 4,150 rows at Wed May 20 01:35 EDT 2009

Indexes:

Column(s)	Type	Sort	Constraint Name
individual_allele_id	Primary key	Asc	individual_allele_pkey
individual_id + allele_id	Must be unique	Asc/Asc	individual_allele_ukey