http://www.gystdoit.com/family/FAMILY_Data_Dictionary.htm
Wednesday February 10th, 2016 11:16 AM

Genealogical Accounting Framework (GAF) - Record of Families

FAMILY.DBF

Family Tree Data Base - FAMILY Level Production Data Table
Table Last Updated: 12/15/2015 6:58 AM

Records: 204
Families: 196
(There are some remarried)

Supporting Files:
C:\JPG\FAMILY.CDX
C:\JPG\FAMILY.FPT

Fieldname Type(Size) DescriptionExample
FAM_ID Numeric
  • Family ID is a predictable numeric value that provides built-in intelligence
  • ID is assigned based on binary ancestory branches see FamilyTree_Number_Scheme.jpg
  • Can be visually mapped see FAMILY_TREE_desc.SVG
  • Provides base value to construct Individual ID
103
SURNAME C( 51) Family Surname (Last Name) Gaffey
FATHER_ID C( 12) IND_ID of the Father 1.30
FATHER C( 52) GIVEN Name of the Father John Gaffey
MOTHER_ID C( 12) IND_ID of the Mother 103.01
MOTHER C( 52) GIVEN Name of the Mother Ludmila Leytman
WED_DATE Date Date Father and Mother married 11/19/1988
CITY C( 30) This can serve as storage for gedcom Wedding Place information Rome, NY
PHOTO C(100)
  • File name of parent couple picture
  • Father-Mother together image file
  • could be Wedding Picture, Current Picture, or other

Naming Convention to tie photo to family

  • Use combination of Family ID and Surname to name the photo
  • for example
  • Gaffey_103_couple.jpg
  • Gaffey_103_wedding.jpg
  • Gaffey_103_19881118.jpg
    • (includes date stamp YYYYMMDD of when photo taken)

  • All Family Tree image files should have either a
  • Family ID (FAM ID) or
  • Individual ID (IND ID)
  • embedded in the filename
  • to provide reference control and support access

see Family_Member-PickLists.htm List of Existing Files


  • Gaffey_103_wedding.jpg