Legacy Tables…


Return to the Legacy Table index...
Table Details for: tblIR (Individual Records)
Column Name Data Type Size Description User Comments
ID AutoNumber 232 Internal use - don't use this in queries.
IDIR Long 232 Primary key of table tblIR.

This is the RIN.

For RIN 0 (zero), column IDAR holds the next available RIN.
Surname VARCHAR 120
SoundsLike VARCHAR 4
GivenName VARCHAR 120
Prefix VARCHAR 120
Title VARCHAR 120
NameNote MEMO 1GB
Gender BYTE 28
BirthD VARCHAR 100
BirthSD Long 232 Sortable version of BirthD.
IDLRBirth Long 232 Foreign key pointing to tblLR.
ChrisD VARCHAR 100
ChrisSD Long 232 Sortable version of ChrisD.
IDLRChris Long 232 Foreign key pointing to tblLR.
ChrTerm VARCHAR 100
DeathD VARCHAR 100
DeathSD Long 232 Sortable version of DeathD.
IDLRDeath Long 232 Foreign key pointing to tblLR.
BuriedD VARCHAR 100
BuriedSD Long 232 Sortable version of BuriedD.
IDLRBuried Long 232 Foreign key pointing to tblLR.
Cremated BYTE 28
IDARBirth Long 232 Foreign key pointing to tblAR.
IDARChris Long 232 Foreign key pointing to tblAR.
IDARDeath Long 232 Foreign key pointing to tblAR.
IDARBuried Long 232 Foreign key pointing to tblAR.
BirthNote MEMO 1GB
ChrisNote MEMO 1GB
DeathNote MEMO 1GB
BuriedNote MEMO 1GB
Living BYTE 28
BaptismD VARCHAR 100
BaptismSD Long 232 Sortable version of BaptismD.
BaptismKind BYTE 28
IDTRBaptism Long 232 Foreign key pointing to tblTR.
BaptismNote MEMO 1GB
LDSB BYTE 28
ConfirmationD VARCHAR 100
ConfirmationSD Long 232 Sortable version of ConfirmationD.
ConfirmationKind BYTE 28
IDTRConfirmation Long 232 Foreign key pointing to tblTR.
ConfirmationNote MEMO 1GB
LDSC BYTE 28
InitiatoryD VARCHAR 100
InitiatorySD Long 232 Sortable version of InitiatoryD.
IDTRInitiatory Long 232 Foreign key pointing to tblTR.
InitiatoryNote MEMO 1GB
LDSI BYTE 28
EndowD VARCHAR 100
EndowSD Long 232 Sortable version of EndowD.
IDTREndow Long 232 Foreign key pointing to tblTR.
EndowNote MEMO 1GB
LDSE BYTE 28
TempleTag BYTE 28 Temple Ready bit field. 01234567 bits set = 0=Name Only, 1=Baptism, 2=Endowment
IDMRPref Long 232 Foreign key pointing to tblMR.
IDMRParents Long 232 Foreign key pointing to tblMR.
IDAR Long 232 Foreign key pointing to tblAR.
AncInterest BYTE 28
DecInterest BYTE 28
Tag1 BYTE 28
Tag2 BYTE 28
Tag3 BYTE 28
Tag4 BYTE 28
Tag5 BYTE 28
Tag6 BYTE 28
Tag7 BYTE 28
Tag8 BYTE 28
Tag9 BYTE 28
TagGroup BYTE 28
TagAnc BYTE 28
TagDec BYTE 28
SaveTag BYTE 28
SrchTag BYTE 28
SrchTagRG BYTE 28
qsTag BYTE 28
ReminderTag BYTE 28
ReminderTagDeath BYTE 28
TreeNum Integer 216
LTMP1 Long 232
LTMP2 Long 232
AlreadyUsed BYTE 28
UserRef VARCHAR 50
AncestralRef VARCHAR 20
Notes MEMO 1GB
References MEMO 1GB
Medical MEMO 1GB
DeathCause VARCHAR 255
PPCheck BYTE 28
Imported BYTE 28
Added Long 232
AddedTime VARCHAR 5
Updated Long 232
UpdatedTime VARCHAR 5
Relations VARCHAR 20
NeverMarried BYTE 28
DirectLine BYTE 28
STMP1 VARCHAR 255
ColorTag1 Integer 216
ColorTag2 Integer 216
IntelliShare VARCHAR 50
Private BYTE 28
PPExclude VARCHAR 50
RGExclude BYTE 28
DNA MEMO 1GB
FSActive BYTE 28
Primary & Foreign Keys for table tblIR 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.