Legacy Tables…


Return to the Legacy Table index...
Table Details for: tblMR (Marriage Records)
Column Name Data Type Size Description User Comments
ID AutoNumber 232
IDMR Long 232 Primary key of table tblMR.

This is the MRIN.

For MRIN 0 (zero), column IDTRSeal holds the next available MRIN.
IDIRHusb Long 232 Foreign key pointing to tblIR.
HusbOrder Integer 216
HusbPrefMar BYTE 28
HusbSurname VARCHAR 120
HusbGivenName VARCHAR 120
HusbMarrSurname VARCHAR 120
HusbBirthSD Long 232 Sortable version of HusbBirthD.
IDIRWife Long 232 Foreign key pointing to tblIR.
WifeOrder Integer 216
WifePrefMar BYTE 28
WifeSurname VARCHAR 120
WifeGivenName VARCHAR 120
WifeMarrSurname VARCHAR 120
WifeBirthSD Long 232 Sortable version of WifeBirthD.
MarriedNameRule BYTE 28 '0=is not a married name, 1=rule generated married name, 2=user entered married name
IDMS Long 232 Foreign key pointing to tblMS.
MarD VARCHAR 100
MarSD Long 232 Sortable version of MarD.
MarEndD VARCHAR 100
MarEndSD Long 232 Sortable version of MarEndD.
IDLRMar Long 232 Foreign key pointing to tblLR.
SealD VARCHAR 100
SealSD Long 232 Sortable version of SealD.
IDTRSeal Long 232 Foreign key pointing to tblTR.
SealNote MEMO 1GB
LDSS BYTE 28
TempleTag BYTE 28 Temple Ready field
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
SrchTag BYTE 28
ReminderTag BYTE 28
NotMarried BYTE 28
NoChildren BYTE 28
AlreadyUsed BYTE 28
LTMP1 Long 232
LTMP2 Long 232
Notes MEMO 1GB
PPCheck BYTE 28
Added Long 232
AddedTime VARCHAR 5
Updated Long 232
UpdatedTime VARCHAR 5
IDAR Long 232 Foreign key pointing to tblAR.
HPhrase VARCHAR 100
WPhrase VARCHAR 100
RPhrase VARCHAR 100
RPhrase2 VARCHAR 100
UserRef VARCHAR 50
MPhrase VARCHAR 100
SPhrase VARCHAR 100
HusbWifeOver1 VARCHAR 255
HusbWifeOver2 VARCHAR 255
WifeHusbOver1 VARCHAR 255
WifeHusbOver2 VARCHAR 255
Private BYTE 28
Primary & Foreign Keys for table tblMR 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.