Legacy Tables…


Return to the Legacy Table index...
Table Details for: tblSR (Master Source Records)
Column Name Data Type Size Description User Comments
IDSR AutoNumber 232 Primary key of table tblSR.
SrcName VARCHAR 255
SrcTitle MEMO 1GB
SrcAuthor VARCHAR 255
SrcPubl MEMO 1GB
SrcText MEMO 1GB
SrcNote MEMO 1GB
SrcTag BYTE 28
SrcExclude BYTE 28
IDST Long 232 Foreign key pointing to tblST.
Used BYTE 28
pSrcNote BYTE 28
fSrcNote BYTE 28
tSrcNote BYTE 28
pSrcText BYTE 28
fSrcText BYTE 28
tSrcText BYTE 28
IDAR Long 232 Foreign key pointing to tblAR.
EnteredSD Long 232 Sortable version of EnteredD.
FilingRef VARCHAR 50
SrcCallNum VARCHAR 255
Verified BYTE 28
Published BYTE 28
EnteredD VARCHAR 100
SrcMPub VARCHAR 255 Clooz
SrcRollNum VARCHAR 255 Clooz
TemplateID Long 232
Contents MEMO 1GB
UseStandard BYTE 28 0=use professional template, 1=use standard format
IDAR2 Long 232 Foreign key pointing to tblAR.
Bibliography BYTE 28
Override MEMO 1GB combine all three override formats separated by //
OverrideFootnote BYTE 28
OverrideSubsequent BYTE 28
OverrideBibliography BYTE 28
Primary & Foreign Keys for table tblSR are highlighted.
BIT values can be 0 or 1
BYTE values can range from 0 to +255
Integer values can range from -32,768 to +32,767
Long (and AutoNumber) values can range from -2,147,483,648 to +2,147,483,647
Single (single-precision floating-point)
Double (double-precision floating-point)

Comments are closed.