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
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
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,252 rows at Mon Sep 03 04:09 PDT 2018

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: