Table topp.public.tbltgspotprogsheet 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
tkey serial 10  √  nextval('tbltgspotprogsheet_tkey_seq'::regclass)
acctime text 2147483647  √  null
add2next text 2147483647  √  null
argosid text 2147483647  √  null
b1low text 2147483647  √  null
b1high text 2147483647  √  null
b2high text 2147483647  √  null
b3high text 2147483647  √  null
b4high text 2147483647  √  null
b5high text 2147483647  √  null
b6high text 2147483647  √  null
b7high text 2147483647  √  null
b8high text 2147483647  √  null
b9high text 2147483647  √  null
b10high text 2147483647  √  null
b11high text 2147483647  √  null
b12low text 2147483647  √  null
b12high text 2147483647  √  null
battvolts text 2147483647  √  null
change2slow text 2147483647  √  null
check4dry text 2147483647  √  null
cond text 2147483647  √  null
cthreshold text 2147483647  √  null
days text 2147483647  √  null
depthtemp text 2147483647  √  null
email text 2147483647  √  null
enteredby text 2147483647  √  null
hardversion text 2147483647  √  null
histenabled text 2147483647  √  null
hours text 2147483647  √  null
locdate date 13  √  null
loctime time 15,6  √  null
months text 2147483647  √  null
otherdays text 2147483647  √  null
otherhours text 2147483647  √  null
othermonths text 2147483647  √  null
pauseafter text 2147483647  √  null
phone text 2147483647  √  null
progcomments text 2147483647  √  null
progsw text 2147483647  √  null
pstdate date 13  √  null
psttime time 15,6  √  null
repfilename text 2147483647  √  null
repratefast text 2147483647  √  null
reprateslow text 2147483647  √  null
restartafter text 2147483647  √  null
tagclockgmt time 15,6  √  null
tagcode text 2147483647  √  null
tagdate date 13  √  null
tagnumber text 2147483647  √  null
tagsoft text 2147483647  √  null
tgspkey text 2147483647  √  null
toppid text 2147483647  √  null
totaltrans text 2147483647  √  null
transperday text 2147483647  √  null
transyes text 2147483647  √  null
uemail text 2147483647  √  null
updatebutton text 2147483647  √  null
uphone text 2147483647  √  null
userr text 2147483647  √  null

Table contained 14 rows at Wed Dec 27 13:25 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
tkey Primary key Asc tbltgspotprogsheet_pkey