Table topp.junk.satdeployments_test Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ptt int4 10  √  null
t timestamp 29,6  √  null
satdeploymentid int4 10  √  null
toppid text 2147483647  √  null
pttnumber int4 10  √  null
speciesname text 2147483647  √  null
startdate date 13  √  null
enddate date 13  √  null
actualpopupdate date 13  √  null
tagnumber text 2147483647  √  null
comment text 2147483647  √  null
contact text 2147483647  √  null
projectname text 2147483647  √  null
modelname text 2147483647  √  null
testingnote text 2147483647  √  null
owner text 2147483647  √  null
eventid int4 10  √  null
las text 2147483647  √  null
tagcode varchar 50  √  null
starttime time 15,6  √  null
endtime time 15,6  √  null
est_end_date date 13  √  null

Table contained 4,551 rows at Wed Dec 27 13:25 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
ptt Performance Asc satdeployments_test_index
ptt + t Performance Asc/Asc satdeployments_test_ptt_t_index