SchemaSpy - Table zfindb.public.marker_relationship

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

mreltype_name

text

2147483647

construct_marker_relationship.conmrkrrel_relationship_type	conmrkrrel_relationship_type_foreign_key R
marker_relationship.mrel_type	mrel_type_foreign_key R

mreltype_mrkr_type_group_1

text

2147483647

mreltype_mrkr_type_group_1_foreign_key R

mreltype_mrkr_type_group_2

text

2147483647

mreltype_mrkr_type_group_2_foreign_key R

mreltype_1_to_2_comments

text

2147483647

mreltype_2_to_1_comments

text

2147483647

Table contained 32 rows at Tue Sep 15 16:40 PDT 2020

Indexes:

Column(s)	Type	Sort	Constraint Name
mreltype_name	Primary key	Asc	marker_relationship_type_primary_key
mreltype_mrkr_type_group_1	Performance	Asc	mreltype_mrkr_type_group_1_index
mreltype_mrkr_type_group_2	Performance	Asc	mreltype_mrkr_type_group_2_index