SchemaSpy Analysis of topp.atn - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Wed Dec 27 13:21 PST 2017
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

topp.atn contains 84 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
deployment animal_name text 2147483647  √  null
deployment data_wrangler_email text 2147483647  √  null
deployment deployment_date timestamptz 35,6  √  null
deployment deployment_id serial 10  √  nextval('atn.deployment_deployment_id_seq'::regclass)
deployment deployment_latitude numeric 131089  √  null
deployment deployment_longitude numeric 131089  √  null
deployment genus text 2147483647  √  null
deployment local_deployment_name text 2147483647  √  null
deployment principal_investigator_email text 2147483647  √  null
deployment species text 2147483647  √  null
deployment species_code int4 10  √  null
deployment species_year_serial int4 10  √  null
deployment toppid int4 10  √  null
deployment userid int4 10  √  null
deployment_bak animal_name text 2147483647  √  null
deployment_bak data_wrangler_email text 2147483647  √  null
deployment_bak deployment_date timestamptz 35,6  √  null
deployment_bak deployment_id serial 10  √   √  nextval('atn.deployment_id_seq'::regclass)
deployment_bak deployment_latitude numeric 131089  √  null
deployment_bak deployment_longitude numeric 131089  √  null
deployment_bak genus text 2147483647  √  null
deployment_bak local_deployment_name text 2147483647  √  null
deployment_bak principal_investigator_email text 2147483647  √  null
deployment_bak species text 2147483647  √  null
deployment_bak species_code int4 10  √  null
deployment_bak species_year_serial int4 10  √  null
deployment_bak userid int4 10  √  null
download_product_urls eventid int4 10
download_product_urls filetype text 2147483647
download_product_urls idx serial 10  √  nextval('atn.download_product_urls_idx_seq'::regclass)
download_product_urls product text 2147483647
download_product_urls publish int4 10
download_product_urls url text 2147483647
download_product_urls_test eventid int4 10
download_product_urls_test filetype text 2147483647
download_product_urls_test idx serial 10  √  nextval('atn.download_product_urls_idx_seq'::regclass)
download_product_urls_test product text 2147483647
download_product_urls_test publish int4 10
download_product_urls_test url text 2147483647
event deployment_id int4 10  √  null
event event_id serial 10  √  nextval('atn.event_event_id_seq'::regclass)
event multi_tag_serial int4 10  √  null
event portal_username text 2147483647  √  null
event ptt int4 10  √  null
event tag_manufacturer text 2147483647  √  null
event tag_model text 2147483647  √  null
event tag_serial_number text 2147483647  √  null
event testingnote text 2147483647  √  null
hints contact text 2147483647  √  null
hints owner text 2147483647  √  null
hints personname text 2147483647  √  null
hints speciescode int4 10  √  null
new_users authcode text 2147483647  √  null
new_users authorized int4 10  √  null
new_users date text 2147483647  √  null
new_users defperm int4 10  √  null
new_users email text 2147483647  √  null
new_users firstname varchar 2147483647  √  null
new_users lastname varchar 2147483647  √  null
new_users lowercase_email text 2147483647  √  null
new_users organization text 2147483647  √  null
new_users password text 2147483647  √  null
new_users regcite text 2147483647  √  null
new_users userdir text 2147483647  √  null
new_users username text 2147483647  √  null
new_wc eventid int4 10  √  null
new_wc wc_id text 2147483647  √  null
owner eventid int4 10
owner ownerid int4 10
users authcode text 2147483647  √  null
users authorized int4 10  √  null
users date text 2147483647  √  null
users defperm int4 10  √  null
users email text 2147483647  √  null
users firstname varchar 255  √  null
users id serial 10  √  nextval('atn.users_id_seq'::regclass)
users lastname varchar 255  √  null
users organization text 2147483647  √  null
users password text 2147483647  √  null
users regcite text 2147483647  √  null
users userdir text 2147483647  √  null
users username text 2147483647  √  null
wc eventid int4 10
wc wc_id text 2147483647  √  null