SchemaSpy - Table zfindb.public.gff3

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
gff_seqname	text	2147483647	√	null
gff_source	text	2147483647	√	null
gff_feature	text	2147483647	√	null
gff_start	int4	10	√	null
gff_end	int4	10	√	null
gff_score	text	2147483647	√	null
gff_strand	bpchar	1	√	null
gff_frame	bpchar	1	√	null
gff_id	text	2147483647
gff_name	text	2147483647	√	null
gff_parent	text	2147483647	√	null
gff_biotype	text	2147483647	√	null

Table contained 1,571,606 rows at Wed Sep 15 00:41 PDT 2021

Indexes:

Column(s)	Type	Sort	Constraint Name
gff_feature	Performance	Asc	ngff3_gff_feature_idx
gff_name	Performance	Asc	ngff3_gff_name_gff_idx
gff_parent	Performance	Asc	ngff3_gff_parent_idx
gff_source	Performance	Asc	ngff3_gff_source_idx