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

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 comment text 2147483647  √  null
fast_max_datetime contact text 2147483647  √  null
fast_max_datetime enddate date 13  √  null
fast_max_datetime endtime time 15,6  √  null
fast_max_datetime est_end_date date 13  √  null
fast_max_datetime eventid int4 10  √  null
fast_max_datetime las text 2147483647  √  null
fast_max_datetime max_datetime timestamp 29,6  √  null
fast_max_datetime modelname text 2147483647  √  null
fast_max_datetime owner text 2147483647  √  null
fast_max_datetime projectname text 2147483647  √  null
fast_max_datetime pttnumber int4 10  √  null
fast_max_datetime satdeploymentid int4 10  √  null
fast_max_datetime speciesname text 2147483647  √  null
fast_max_datetime startdate date 13  √  null
fast_max_datetime starttime time 15,6  √  null
fast_max_datetime tagcode varchar 50  √  null
fast_max_datetime tagnumber text 2147483647  √  null
fast_max_datetime testingnote text 2147483647  √  null
fast_max_datetime toppid text 2147483647  √  null
fishgroup_popups_diag enddate date 13  √  null
fishgroup_popups_diag eventid int4 10  √  null
fishgroup_popups_diag max_datetime timestamp 29,6  √  null
fishgroup_popups_diag modelname text 2147483647  √  null
fishgroup_popups_diag pttnumber int4 10  √  null
fishgroup_popups_diag startdate date 13  √  null
fishgroup_popups_diag successful text 2147483647  √  null
fishgroup_popups_diag tagcode text 2147483647  √  null
fishgroup_popups_diag tagdate date 13  √  null
fishgroup_popups_diag tagnumber text 2147483647  √  null
sharkgroup_popups_diag enddate date 13  √  null
sharkgroup_popups_diag eventid int4 10  √  null
sharkgroup_popups_diag max_datetime timestamp 29,6  √  null
sharkgroup_popups_diag modelname text 2147483647  √  null
sharkgroup_popups_diag pttnumber int4 10  √  null
sharkgroup_popups_diag startdate date 13  √  null
sharkgroup_popups_diag tagcode text 2147483647  √  null
sharkgroup_popups_diag tagdate date 13  √  null
sharkgroup_popups_diag tagnumber text 2147483647  √  null