SchemaSpy - Table zfindb.public.feature

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

fp_pk_id

bigserial

√

nextval('feature_prefix_fp_pk_id_seq'::regclass)

feature.feature_lab_prefix_id	feature_lab_prefix_id_foreign_key C
source_feature_prefix.sfp_prefix_id	sfp_prefix_id_foreign_key C

fp_prefix

text

2147483647

fp_date_entered

timestamp

29,6

now()

fp_institute_display

text

2147483647

Table contained 458 rows at Mon Sep 03 04:09 PDT 2018

Indexes:

Column(s)	Type	Sort	Constraint Name
fp_pk_id	Primary key	Asc	feature_prefix_primary_key
fp_prefix	Must be unique	Asc	feature_prefix_alternate_key_index