SchemaSpy - Table zfindb.public.feature_group

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Auto	Default
fgm_group_id	int8	19
fgm_member_name	text	2147483647	√		null
fgm_member_id	text	2147483647	√		null
fgm_genotype_id	text	2147483647	√		null
fgm_significance	int4	10	√		null
fgm_feature_type	text	2147483647	√		null
fgm_pk_id	bigserial	19		√	nextval('feature_group_member_fgm_pk_id_seq'::regclass)

Table contained 391,336 rows at Wed Sep 15 00:41 PDT 2021

Indexes:

Column(s)	Type	Sort	Constraint Name
fgm_pk_id	Primary key	Asc	feature_group_member_primary_key
fgm_genotype_id	Performance	Asc	feature_group_member_genotype_id_index
fgm_group_id	Performance	Asc	feature_group_member_group_id_index
fgm_member_id	Performance	Asc	feature_group_member_id_index