locus_owner - cxgn_breedbase.phenome

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

locus_owner_id

serial

10

√

nextval('phenome.locus_owner_locus_owner_id_seq'::regclass)

locus_id

int4

10

null

locus.locus_id

locus_owner_locus_id_fkey

C

sp_person_id

int4

10

null

sp_person.sp_person_id

locus_owner_sp_person_id_fkey

R

granted_by

int4

10

√

null

sp_person.sp_person_id

locus_owner_granted_by_fkey

R

obsolete

bool

1

√

false

create_date

timestamptz

35,6

√

now()

modified_date

timestamptz

35,6

√

null

Showing 1 to 7 of 7 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
locus_owner_pkey	Primary key	Asc	locus_owner_id
locus_owner_key	Must be unique	Asc/Asc	locus_id + sp_person_id

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation

One
Two degrees