SchemaSpy Analysis of topp.refactor - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Wed Dec 27 13:27 PST 2017 |
| ||||||
|
topp.refactor contains 40 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
fast_max_datetime | actualpopupdate | date | 13 | √ | null | ||
fast_max_datetime | enddate | date | 13 | √ | null | ||
fishgroup_popups_diag | enddate | date | 13 | √ | null | ||
sharkgroup_popups_diag | enddate | date | 13 | √ | null | ||
fast_max_datetime | est_end_date | date | 13 | √ | null | ||
fast_max_datetime | startdate | date | 13 | √ | null | ||
fishgroup_popups_diag | startdate | date | 13 | √ | null | ||
sharkgroup_popups_diag | startdate | date | 13 | √ | null | ||
fishgroup_popups_diag | tagdate | date | 13 | √ | null | ||
sharkgroup_popups_diag | tagdate | date | 13 | √ | null | ||
fast_max_datetime | eventid | int4 | 10 | √ | null | ||
fishgroup_popups_diag | eventid | int4 | 10 | √ | null | ||
sharkgroup_popups_diag | eventid | int4 | 10 | √ | null | ||
fast_max_datetime | pttnumber | int4 | 10 | √ | null | ||
fishgroup_popups_diag | pttnumber | int4 | 10 | √ | null | ||
sharkgroup_popups_diag | pttnumber | int4 | 10 | √ | null | ||
fast_max_datetime | satdeploymentid | int4 | 10 | √ | null | ||
fast_max_datetime | comment | text | 2147483647 | √ | null | ||
fast_max_datetime | contact | text | 2147483647 | √ | null | ||
fast_max_datetime | las | text | 2147483647 | √ | null | ||
fast_max_datetime | modelname | text | 2147483647 | √ | null | ||
fishgroup_popups_diag | modelname | text | 2147483647 | √ | null | ||
sharkgroup_popups_diag | modelname | text | 2147483647 | √ | null | ||
fast_max_datetime | owner | text | 2147483647 | √ | null | ||
fast_max_datetime | projectname | text | 2147483647 | √ | null | ||
fast_max_datetime | speciesname | text | 2147483647 | √ | null | ||
fishgroup_popups_diag | successful | text | 2147483647 | √ | null | ||
fishgroup_popups_diag | tagcode | text | 2147483647 | √ | null | ||
sharkgroup_popups_diag | tagcode | text | 2147483647 | √ | null | ||
fast_max_datetime | tagnumber | text | 2147483647 | √ | null | ||
fishgroup_popups_diag | tagnumber | text | 2147483647 | √ | null | ||
sharkgroup_popups_diag | tagnumber | text | 2147483647 | √ | null | ||
fast_max_datetime | testingnote | text | 2147483647 | √ | null | ||
fast_max_datetime | toppid | text | 2147483647 | √ | null | ||
fast_max_datetime | endtime | time | 15,6 | √ | null | ||
fast_max_datetime | starttime | time | 15,6 | √ | null | ||
fast_max_datetime | max_datetime | timestamp | 29,6 | √ | null | ||
fishgroup_popups_diag | max_datetime | timestamp | 29,6 | √ | null | ||
sharkgroup_popups_diag | max_datetime | timestamp | 29,6 | √ | null | ||
fast_max_datetime | tagcode | varchar | 50 | √ | null |