SchemaSpy - Table zfindb.public.affected_gene_group

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Auto	Default
afgm_group_id	int8	19
afgm_member_name	text	2147483647	√		null
afgm_member_id	text	2147483647
afgm_pk_id	bigserial	19		√	nextval('affected_gene_group_member_afgm_pk_id_seq'::regclass)

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

Indexes:

Column(s)	Type	Sort	Constraint Name
afgm_pk_id	Primary key	Asc	affected_gene_group_member_primary_key
afgm_group_id	Performance	Asc	affected_gene_group_member_group_id_index
afgm_member_id	Performance	Asc	affected_gene_group_member_id_index