Table topp.deprecated.tblsharkcontactinfo 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
tkey serial 10  √  nextval('deprecated.tblsharkcontactinfo_tkey_seq'::regclass)
passwords.tkey Implied Constraint R
investid int4 10  √  null
tblcontactinfo.investid Implied Constraint R
lastname text 2147483647  √  null
firstname text 2147483647  √  null
salutation text 2147483647  √  null
title text 2147483647  √  null
organization text 2147483647  √  null
address text 2147483647  √  null
city text 2147483647  √  null
stateprovince text 2147483647  √  null
zipcode text 2147483647  √  null
country text 2147483647  √  null
phone text 2147483647  √  null
fax text 2147483647  √  null
email text 2147483647  √  null
weburl text 2147483647  √  null
comments text 2147483647  √  null

Table contained 12 rows at Wed Dec 27 13:21 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
tkey Primary key Asc tblsharkcontactinfo_pkey

Close relationships: