Table zfindb.public.company 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
address text 2147483647  √  null
entry_time timestamp 29,6  √  now()
bio text 2147483647  √  null
status text 2147483647  √  null
contact_person text 2147483647  √  null
person.zdb_id company_contact_person_foreign_key R
owner text 2147483647  √  null
person.zdb_id company_owner_foreign_key R
url text 2147483647  √  null
email text 2147483647  √  null
fax text 2147483647  √  null
phone text 2147483647  √  null
zdb_id text 2147483647
int_person_company.target_id int_person_company_target_id_foreign_key C
mapped_marker.zdb_id Implied Constraint R
panels.zdb_id Implied Constraint R
primer_set.zdb_id Implied Constraint R
return_recs.zdb_id Implied Constraint R
tmp_pub2.zdb_id Implied Constraint R
zdb_active_source.zactvs_zdb_id cmpy_zdb_id_foreign_key C
name text 2147483647  √  null
country text 2147483647  √  null
image text 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
zdb_id Primary key Asc company_primary_key  
name Must be unique Asc cmpy_name_index This unique column is also nullable
contact_person Performance Asc company_contact_person_fk_index  
owner Performance Asc company_owner_fk_index  

Close relationships  within of separation: