stockcollectionprop

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

stockcollectionprop_id

serial

10

√

nextval('stockcollectionprop_stockcollectionprop_id_seq'::regclass)

stockcollection_id

int4

10

null

stockcollection.stockcollection_id

stockcollectionprop_stockcollection_id_fkey

C

type_id

int4

10

null

cvterm.cvterm_id

stockcollectionprop_type_id_fkey

R

The cv for the type_id is “stockcollection property type”.

value

text

2147483647

√

null

rank

int4

10

0

Showing 1 to 5 of 5 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
stockcollectionprop_pkey	Primary key	Asc	stockcollectionprop_id
stockcollectionprop_c1	Must be unique	Asc/Asc/Asc	stockcollection_id + type_id + rank
stockcollectionprop_idx1	Performance	Asc	stockcollection_id
stockcollectionprop_idx2	Performance	Asc	type_id

Showing 1 to 4 of 4 entries

Description

Columns

Indexes

Relationships

Close relationships within degrees of separation