| SchemaSpy Analysis of topp.atn - Columns | Generated by SchemaSpy |
| Generated by SchemaSpy on Wed Dec 27 13:21 PST 2017 |
| ||||||
|
| |||||||
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_bak | animal_name | text | 2147483647 | √ | null | ||
| new_users | authcode | text | 2147483647 | √ | null | ||
| users | authcode | text | 2147483647 | √ | null | ||
| new_users | authorized | int4 | 10 | √ | null | ||
| users | authorized | int4 | 10 | √ | null | ||
| hints | contact | text | 2147483647 | √ | null | ||
| deployment | data_wrangler_email | text | 2147483647 | √ | null | ||
| deployment_bak | data_wrangler_email | text | 2147483647 | √ | null | ||
| new_users | date | text | 2147483647 | √ | null | ||
| users | date | text | 2147483647 | √ | null | ||
| new_users | defperm | int4 | 10 | √ | null | ||
| users | defperm | int4 | 10 | √ | null | ||
| deployment | deployment_date | timestamptz | 35,6 | √ | null | ||
| deployment_bak | deployment_date | timestamptz | 35,6 | √ | null | ||
| deployment | deployment_id | serial | 10 | √ | nextval('atn.deployment_deployment_id_seq'::regclass) | ||
| deployment_bak | deployment_id | serial | 10 | √ | √ | nextval('atn.deployment_id_seq'::regclass) | |
| event | deployment_id | int4 | 10 | √ | null | ||
| deployment | deployment_latitude | numeric | 131089 | √ | null | ||
| deployment_bak | deployment_latitude | numeric | 131089 | √ | null | ||
| deployment | deployment_longitude | numeric | 131089 | √ | null | ||
| deployment_bak | deployment_longitude | numeric | 131089 | √ | null | ||
| new_users | text | 2147483647 | √ | null | |||
| users | text | 2147483647 | √ | null | |||
| event | event_id | serial | 10 | √ | nextval('atn.event_event_id_seq'::regclass) | ||
| download_product_urls | eventid | int4 | 10 | ||||
| download_product_urls_test | eventid | int4 | 10 | ||||
| new_wc | eventid | int4 | 10 | √ | null | ||
| owner | eventid | int4 | 10 | ||||
| wc | eventid | int4 | 10 | ||||
| download_product_urls | filetype | text | 2147483647 | ||||
| download_product_urls_test | filetype | text | 2147483647 | ||||
| new_users | firstname | varchar | 2147483647 | √ | null | ||
| users | firstname | varchar | 255 | √ | null | ||
| deployment | genus | text | 2147483647 | √ | null | ||
| deployment_bak | genus | text | 2147483647 | √ | null | ||
| users | id | serial | 10 | √ | nextval('atn.users_id_seq'::regclass) | ||
| download_product_urls | idx | serial | 10 | √ | nextval('atn.download_product_urls_idx_seq'::regclass) | ||
| download_product_urls_test | idx | serial | 10 | √ | nextval('atn.download_product_urls_idx_seq'::regclass) | ||
| new_users | lastname | varchar | 2147483647 | √ | null | ||
| users | lastname | varchar | 255 | √ | null | ||
| deployment | local_deployment_name | text | 2147483647 | √ | null | ||
| deployment_bak | local_deployment_name | text | 2147483647 | √ | null | ||
| new_users | lowercase_email | text | 2147483647 | √ | null | ||
| event | multi_tag_serial | int4 | 10 | √ | null | ||
| new_users | organization | text | 2147483647 | √ | null | ||
| users | organization | text | 2147483647 | √ | null | ||
| hints | owner | text | 2147483647 | √ | null | ||
| owner | ownerid | int4 | 10 | ||||
| new_users | password | text | 2147483647 | √ | null | ||
| users | password | text | 2147483647 | √ | null | ||
| hints | personname | text | 2147483647 | √ | null | ||
| event | portal_username | text | 2147483647 | √ | null | ||
| deployment | principal_investigator_email | text | 2147483647 | √ | null | ||
| deployment_bak | principal_investigator_email | text | 2147483647 | √ | null | ||
| download_product_urls | product | text | 2147483647 | ||||
| download_product_urls_test | product | text | 2147483647 | ||||
| event | ptt | int4 | 10 | √ | null | ||
| download_product_urls | publish | int4 | 10 | ||||
| download_product_urls_test | publish | int4 | 10 | ||||
| new_users | regcite | text | 2147483647 | √ | null | ||
| users | regcite | text | 2147483647 | √ | null | ||
| deployment | species | text | 2147483647 | √ | null | ||
| deployment_bak | species | text | 2147483647 | √ | null | ||
| deployment | species_code | int4 | 10 | √ | null | ||
| deployment_bak | species_code | int4 | 10 | √ | null | ||
| deployment | species_year_serial | int4 | 10 | √ | null | ||
| deployment_bak | species_year_serial | int4 | 10 | √ | null | ||
| hints | speciescode | 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 | ||
| deployment | toppid | int4 | 10 | √ | null | ||
| download_product_urls | url | text | 2147483647 | ||||
| download_product_urls_test | url | text | 2147483647 | ||||
| new_users | userdir | text | 2147483647 | √ | null | ||
| users | userdir | text | 2147483647 | √ | null | ||
| deployment | userid | int4 | 10 | √ | null | ||
| deployment_bak | userid | int4 | 10 | √ | null | ||
| new_users | username | text | 2147483647 | √ | null | ||
| users | username | text | 2147483647 | √ | null | ||
| new_wc | wc_id | text | 2147483647 | √ | null | ||
| wc | wc_id | text | 2147483647 | √ | null |