Table zfindb.public.amsterdam_file Generated by
SchemaSpy
Legend: SourceForge.net
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
af_pk_id bigserial 19  √  nextval('amsterdam_file_af_pk_id_seq'::regclass)
af_feature_zdb_id text 2147483647
feature.feature_zdb_id af_feature_zdb_id_fk C
af_file_location text 2147483647
af_is_overlapping_file text 2147483647  √  null

Table contained 464 rows at Fri Oct 04 14:43 PDT 2019

Indexes:
Column(s) Type Sort Constraint Name
af_feature_zdb_id + af_file_location Must be unique Asc/Asc af_ak_index
af_pk_id Must be unique Asc af_pk_id_index

Close relationships  within of separation: