Table topp.public.tblsgarchivalprogramming
This table is almost never used. It is rare for an archival deployment on a shark. The table structure is similar to tblfgarchivalprogramming.

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('tblsgarchivalprogramming_tkey_seq'::regclass)
sgdepkey int4 10
progsw text 2147483647  √  null
hardversion text 2147483647  √  null
tagsoft text 2147483647  √  null
localdate date 13  √  null
_localtime time 15,6  √  null
tagdate date 13  √  null
tagclock time 15,6  √  null
workgroup text 2147483647  √  null
fieldleader text 2147483647  √  null
tagcode text 2147483647  √  null
transtatus text 2147483647  √  null
sampdepth text 2147483647  √  null
sampinttemp text 2147483647  √  null
sampexttemp text 2147483647  √  null
samplight text 2147483647  √  null
isensthresh text 2147483647  √  null
samplemode text 2147483647  √  null
depthencoding text 2147483647  √  null
inttempencoding text 2147483647  √  null
exttempencoding text 2147483647  √  null
lightencoding text 2147483647  √  null
stabilizetime text 2147483647  √  null
timediff text 2147483647  √  null
tagreset text 2147483647  √  null
recint int4 10  √  null
tele text 2147483647  √  null
dzero text 2147483647  √  null
delay text 2147483647  √  null
password text 2147483647  √  null
progby text 2147483647  √  null
progcomments text 2147483647  √  null
battvolt text 2147483647  √  null
progjnlfile text 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
sgdepkey Primary key Asc tblsgarchivalprogramming_pkey