Legacy Tables…


Return to the Legacy Table index...
Table Details for: tblER (Event Records)
Column Name Data Type Size Description User Comments
IDER AutoNumber 232 Primary key of table tblER.
IDET Long 232 Foreign key pointing to tblET.
IDType BYTE 28 0 - this is an individual event, tblER.IDIR points to tblIR

20 - this is a marriage event, tblER.IDIR points to tblMR
IDIDOwner Long 232 Foreign key pointing to tblEX.
EventD VARCHAR 100
EventSD Long 232 Sortable version of EventD.
IDLREvent Long 232 Foreign key pointing to tblLR.
Desc MEMO 1GB Notes This is actually the event's Note field. I guess the programmers were too lazy to bother to rename this column when they introduced the Description field.
AddNotes BYTE 28
Description VARCHAR 255 This is actually the event's Description field.
IDAR Long 232 Foreign key pointing to tblAR.
SentenceOverride VARCHAR 255
GEDTag VARCHAR 30
Primary & Foreign Keys for table tblER 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.