Table zfindb.public.lab 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
zdb_id text 2147483647
int_person_lab.target_id int_person_lab_target_id_foreign_key C
lab_address_update_tracking.laut_lab_zdb_id laut_lab_zdb_id_foreign_key C
zebrashare_submission_metadata.zsm_lab_of_origin_zdb_id zem_lab_fk C
zdb_active_source.zactvs_zdb_id lab_zdb_id_foreign_key C
name text 2147483647
phone text 2147483647  √  null
fax text 2147483647  √  null
email text 2147483647  √  null
url text 2147483647  √  null
owner text 2147483647  √  null
person.zdb_id lab_owner_foreign_key R
contact_person text 2147483647  √  null
person.zdb_id lab_contact_person_foreign_key R
bio text 2147483647  √  null
status text 2147483647  √  null
entry_time timestamp 29,6  √  now()
address text 2147483647  √  null
country text 2147483647  √  null
image text 2147483647  √  null

Table contained 1,335 rows at Fri Oct 04 14:43 PDT 2019

Indexes:
Column(s) Type Sort Constraint Name
zdb_id Primary key Asc lab_primary_key
contact_person Performance Asc lab_contact_person_fk_index
owner Performance Asc lab_owner_fk_index

Close relationships  within of separation: