Legacy Tables…


Return to the Legacy Table index...
Table Details for: tblNX (Name Index)
Column Name Data Type Size Description User Comments
IDNX AutoNumber 232 Primary key of table tblNX.
IDNR Long 232 Foreign key pointing to tblNR.
IDIR Long 232 Foreign key pointing to tblIR.
Order Integer 216
ValueExplanation
0Name as found in tblIR. This is redundant data, but its inclusion probably speeds up rendering of Legacy's Name List/Index View.
-1Married Name for wives if turned on using Legacy's Data Entry tab.
≥1All additional user entered AKAs. These AKAs will be presented in ascending sequence ordered by this value.
MarriedNameCreatedBy BYTE 28 0=not a married name, 1=rule generated married name, 2=user created married name
MarriedNameMarIDID Long 232
Prefix VARCHAR 120
Title VARCHAR 120
Surname VARCHAR 120
GivenName VARCHAR 120
SoundsLike VARCHAR 4
UserRef VARCHAR 50
AKANote MEMO 1GB
PreferredAKA BYTE 28
BirthSD Long 232 Sortable version of BirthD.
SrchTag BYTE 28
qsTag BYTE 28
Primary & Foreign Keys for table tblNX 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.