Legacy Tables…


Return to the Legacy Table index...
Table Details for: tblEX (Shared Event Records)
Column Name Data Type Size Description User Comments
IDEX AutoNumber 232 Primary key of table tblEX.
IDType BYTE 28 0 - if tblEX.IDIR points to an individual in tblIR

20 - if tblEX.IDIR points to a marriage in tblMR
IDIR Long 232 Foreign key pointing to tblIR.

Or tblMR (depending on tblEX.IDType).
Order Integer 216 Moved here from tblER. Why didn't they move IDET also???
IDERType BYTE 28 0 - if tblEX.IDER points to an individual event

20 - if tblEX.IDER points to a marriage event
IDER Long 232 Foreign key pointing to tblER.
IDRO Long 232 Foreign key pointing to tblRO.
Given VARCHAR 120 Probably here to avoid a join with tblIR/tblMR.

I hope Check/Repair fixes this if it gets out of sync.
Surname VARCHAR 120 Probably here to avoid a join with tblIR/tblMR.

I hope Check/Repair fixes this if it gets out of sync.
Notes MEMO 1GB
SentenceOverride VARCHAR 255
AddSharedNotes BYTE 28
Private BYTE 28
PPExclude BYTE 28
RGExclude BYTE 28
Primary & Foreign Keys for table tblEX 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.