Table topp.atn.download_product_urls_test 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
idx serial 10  √  nextval('atn.download_product_urls_idx_seq'::regclass)
download_product_urls.idx Implied Constraint R
eventid int4 10
filetype text 2147483647
accepted_filetypes.filetype validfiletype R
product text 2147483647
accepted_products.product validproduct R
publish int4 10
url text 2147483647

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

Indexes:
Column(s) Type Sort Constraint Name
idx Primary key Asc download_product_urls_test_pkey
eventid + filetype + product + publish + url Must be unique Asc/Asc/Asc/Asc/Asc download_product_urls_test_eventid_filetype_product_publish_key

Close relationships  within of separation: