SchemaSpy - Table pub.mgd.bib_workflow

A record in this table represents the Relevance of a Reference by User over time

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

_assoc_key

serial

√

nextval('bib_workflow_relevance_seq'::regclass)

seq_source_assoc._assoc_key

Implied Constraint R

primary key

_refs_key

int4

bib_refs._refs_key

bib_workflow_relevance__refs_key_fkey C

foreign key to BIB_Refs

_relevance_key

int4

voc_term._term_key

bib_workflow_relevance__relevance_key_fkey R

foreign key to VOC_Term where _Vocab_key = 149 (Workflow Relevance)

iscurrent

int2

if 1, then current Relevance for this Reference

confidence

float8

17,17

√

null

confidence values of the predicted relevance classifier

version

text

2147483647

√

null

version of relevance classifier

_createdby_key

int4

1001

mgi_user._user_key

bib_workflow_relevance__createdby_key_fkey R

user who created the record

_modifiedby_key

int4

1001

mgi_user._user_key

bib_workflow_relevance__modifiedby_key_fkey R

user who last modified the record

creation_date

timestamp

29,6

now()

date record was created

modification_date

timestamp

29,6

now()

date record was last modified

Table contained 0 rows at Mon Sep 11 06:12 EDT 2023

Indexes:

Column(s)	Type	Sort	Constraint Name
_assoc_key	Primary key, Used to cluster data	Asc	bib_workflow_relevance_pkey
confidence	Performance	Asc	bib_workflow_relevance_idx_confidence
_createdby_key	Performance	Asc	bib_workflow_relevance_idx_createdby_key
creation_date	Performance	Asc	bib_workflow_relevance_idx_creation_date
iscurrent	Performance	Asc	bib_workflow_relevance_idx_iscurrent
modification_date	Performance	Asc	bib_workflow_relevance_idx_modification_date
_modifiedby_key	Performance	Asc	bib_workflow_relevance_idx_modifiedby_key
_refs_key	Performance	Asc	bib_workflow_relevance_idx_refs_key
_relevance_key	Performance	Asc	bib_workflow_relevance_idx_relevance_key