pub_curator - cxgn_breedbase.phenome

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

pub_curator_id

serial

10

√

nextval('phenome.pub_curator_pub_curator_id_seq'::regclass)

pub_id

int4

10

√

null

pub.pub_id

pub_curator_pub_id_fkey

R

sp_person_id

int4

10

√

null

sp_person.sp_person_id

pub_curator_sp_person_id_fkey

R

status

varchar

32

√

null

date_stored

timestamptz

35,6

√

now()

date_curated

timestamptz

35,6

√

null

curated_by

int4

10

√

null

sp_person.sp_person_id

pub_curator_curated_by_fkey

R

assigned_to

int4

10

√

null

sp_person.sp_person_id

pub_curator_assigned_to_fkey

R

Showing 1 to 8 of 8 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
pub_curator_pkey	Primary key	Asc	pub_curator_id
pub_curator_pub_id_key	Must be unique	Asc	pub_id

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation

One
Two degrees