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 | 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 | 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 | 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 |