RootsMagic 4 table structures

AddressLinkTable
  Field Name Type Key Notes
LinkID INTEGER PRIMARY KEY  
OwnerType INTEGER    
AddressID INTEGER    
OwnerID INTEGER    
  AddressNum INTEGER    
  Details TEXT    
         
         
AddressTable
  Field Name Type Key Notes
AddressID INTEGER PRIMARY KEY  
AddressType INTEGER    
Name TEXT COLLATE RMNOCASE Name
Street1 TEXT   Street
Street2 TEXT   Street
City TEXT   City
State TEXT   State
Zip TEXT   Zip code
Country TEXT   Country
  Phone1 TEXT   Phone
  Phone2 TEXT   Phone
  Fax TEXT   FAX
  Email TEXT   email
  URL TEXT   website URL
  Latitude INTEGER   Latitude
  Longitude INTEGER   Longitude
  Note BLOB    
INDEX idxAddressName Name    
         
         
ChildTable
  Field Name Type Key Notes
  RecID INTEGER PRIMARY KEY  
  ChildID INTEGER    
  FamilyID INTEGER   Family ID#
  RelFather INTEGER    
  RelMother INTEGER    
  ChildOrder INTEGER    
  IsPrivate INTEGER    
  ProofFather INTEGER    
  ProofMother INTEGER    
  Note BLOB    
INDEX idxChildFamilyID FamilyID    
INDEX idxChildID ChildID    
INDEX idxChildOrder ChildOrder    
         
         
         
CitationTable
  Field Name Type Key Notes
  CitationID INTEGER PRIMARY KEY  
  OwnerType INTEGER    
  SourceID INTEGER    
  OwnerID INTEGER    
  Quality TEXT    
  IsPrivate INTEGER    
  Comments BLOB    
  ActualText BLOB    
  RefNumber TEXT    
  Flags INTEGER    
  Fields BLOB    
INDEX idxCitationOwnerID OwnerID    
INDEX idxCitationSourceID SourceID    
         
       
ConfigTable
  Field Name Type Key Notes
  RecID INTEGER PRIMARY KEY  
  RecType INTEGER    
  Title TEXT    
  DataRec BLOB    
INDEX idxRecType RecType    
         
       
EventTable
  Field Name Type Key Notes
  EventID INTEGER PRIMARY KEY  
  EventType INTEGER   (See Fact/Event Types)
  OwnerType INTEGER   0 = individual; 1 = family
  OwnerID INTEGER    
  FamilyID INTEGER    
  PlaceID INTEGER   Place ID#
  SiteID INTEGER    
  Date TEXT    
  SortDate INTEGER    
  IsPrimary INTEGER    
  IsPrivate INTEGER    
  Proof INTEGER    
  Status INTEGER    
  EditDate FLOAT    
  Sentence BLOB    
  Details BLOB    
  Note BLOB    
INDEX idxOwnerDate OwnerID, SortDate
INDEX idxOwnerEvent OwnerID, EventType
         
       
ExclusionTable
  Field Name Type Key Notes
  RecID INTEGER PRIMARY KEY  
  ExclusionType INTEGER    
  ID1 INTEGER    
  ID2 INTEGER    
UNIQUE INDEX idxExclusionIndex ExclusionType, ID1, ID2  
         
       
FactTypeTable (see -- Fact Types)
  Field Name Type Key Notes
  FactTypeID INTEGER PRIMARY KEY ID number of fact (user-defined facts above 1000)
  OwnerType INTEGER   0 = individual; 1 = family
  Name TEXT COLLATE RMNOCASE Fact name
  Abbrev TEXT   Fact abbreviation
  GedcomTag TEXT   Gedcom Tag
  UseValue INTEGER   1 = use value field
  UseDate INTEGER   1 = use date field
  UsePlace INTEGER   1 = use place field
  Sentence BLOB   Sentence definition
  Flags INTEGER    
INDEX idxFactTypeAbbrev Abbrev    
INDEX idxFactTypeGedcomTag GedcomTag    
INDEX idxFactTypeName Name    
         
       
FamilyTable
  Field Name Type Key Notes
  FamilyID INTEGER PRIMARY KEY Family ID#
  FatherID INTEGER   Person ID#
  MotherID INTEGER   Person ID#
  ChildID INTEGER    
  HusbOrder INTEGER    
  WifeOrder INTEGER    
  IsPrivate INTEGER    
  Proof INTEGER    
  SpouseLabel INTEGER    
  FatherLabel INTEGER    
  MotherLabel INTEGER    
  Note BLOB    
INDEX idxFamilyFatherID FatherID    
INDEX idxFamilyMotherID MotherID    
         
       
GroupTable
  Field Name Type Key Notes
  RecID INTEGER PRIMARY KEY  
  GroupID INTEGER    
  StartID INTEGER    
  EndID INTEGER    
         
       
LabelTable
  Field Name Type Key Notes
  LabelID INTEGER PRIMARY KEY  
  LabelType INTEGER    
  LabelValue INTEGER    
  LabelName TEXT COLLATE RMNOCASE
  Description TEXT    
INDEX idxLabelType LabelType    
         
       
LinkTable
  Field Name Type Key Notes
  LinkID INTEGER PRIMARY KEY  
  extSystem INTEGER    
  LinkType INTEGER    
  rmID INTEGER    
  extID TEXT    
  Modified INTEGER    
  extVersion TEXT    
  extDate FLOAT    
  Status INTEGER    
  Note BLOB    
INDEX idxLinkExtId extID    
INDEX idxLinkRmId rmID    
         
       
MediaLinkTable
  Field Name Type Key Notes
  LinkID INTEGER PRIMARY KEY  
  MediaID INTEGER    
  OwnerType INTEGER    
  OwnerID INTEGER    
  IsPrimary INTEGER    
  Include1 INTEGER    
  Include2 INTEGER    
  Include3 INTEGER    
  Include4 INTEGER    
  SortOrder INTEGER    
  RectLeft INTEGER    
  RectTop INTEGER    
  RectRight INTEGER    
  RectBottom INTEGER    
  Note TEXT    
  Caption TEXT COLLATE RMNOCASE
  RefNumber TEXT COLLATE RMNOCASE
  Date TEXT    
  SortDate INTEGER    
  Description BLOB    
INDEX idxMediaOwnerID OwnerID    
INDEX idxMediaCaption Caption    
         
       
MultimediaTable
  Field Name Type Key Notes
  MediaID INTEGER PRIMARY KEY  
  MediaType INTEGER    
  MediaPath TEXT    
  MediaFile TEXT COLLATE RMNOCASE
  URL TEXT    
  Thumbnail BLOB    
INDEX idxMediaFile MediaFile    
INDEX idxMediaURL URL    
         
       
NameTable
  Field Name Type Key Notes
  NameID INTEGER PRIMARY KEY Person ID#
  OwnerID INTEGER    
  Surname TEXT COLLATE RMNOCASE Surname
  Given TEXT COLLATE RMNOCASE Given name
  Prefix TEXT COLLATE RMNOCASE Prefix
  Suffix TEXT COLLATE RMNOCASE Suffix
  Nickname TEXT COLLATE RMNOCASE Nickname
  NameType INTEGER    
  Date TEXT    
  SortDate INTEGER    
  IsPrimary INTEGER    
  IsPrivate INTEGER    
  Proof INTEGER    
  EditDate FLOAT    
  Sentence BLOB    
  Note BLOB    
  BirthYear INTEGER    
  DeathYear INTEGER    
INDEX idxSurname Surname    
INDEX idxSurnameGiven Surname, Given, BirthYear, DeathYear
INDEX idxNameOwnerID OwnerID    
INDEX idxNamePrimary IsPrimary    
INDEX idxGiven Given    
         
       
PersonTable
  Field Name Type Key Notes
  PersonID INTEGER PRIMARY KEY  
  UniqueID TEXT    
  Sex INTEGER    
  EditDate FLOAT    
  ParentID INTEGER    
  SpouseID INTEGER    
  Color INTEGER    
  Relate1 INTEGER    
  Relate2 INTEGER    
  Flags INTEGER    
  Living INTEGER    
  IsPrivate INTEGER    
  Proof INTEGER    
  Bookmark INTEGER    
  Note BLOB    
         
       
PlaceTable
  Field Name Type Key Notes
  PlaceID INTEGER PRIMARY KEY  
  PlaceType INTEGER    
  Name TEXT COLLATE RMNOCASE
  Abbrev TEXT    
  Normalized TEXT    
  Latitude INTEGER    
  Longitude INTEGER    
  LatLongExact INTEGER    
  MasterID INTEGER    
  Note BLOB    
INDEX idxPlaceAbbrev Abbrev    
INDEX idxPlaceName Name    
         
       
ResearchTable
  Field Name Type Key Notes
  TaskID INTEGER PRIMARY KEY  
  TaskType INTEGER    
  OwnerID INTEGER    
  OwnerType INTEGER    
  RefNumber TEXT    
  Name TEXT COLLATE RMNOCASE
  Status INTEGER    
  Priority INTEGER    
  Date1 TEXT    
  Date2 TEXT    
  Date3 TEXT    
  SortDate1 INTEGER    
  SortDate2 INTEGER    
  SortDate3 INTEGER    
  Filename TEXT    
  Details BLOB    
INDEX idxResearchName Name    
INDEX idxResearchOwnerID OwnerID    
         
       
RoleTable (see -- Role Types)
  Field Name Type Key Notes
  RoleID INTEGER PRIMARY KEY  
  RoleName TEXT COLLATE RMNOCASE
  EventType INTEGER    
  RoleType INTEGER    
  Sentence TEXT    
INDEX idxRoleEventType EventType    
         
       
SourceTable
  Field Name Type Key Notes
  SourceID INTEGER PRIMARY KEY  
  Name TEXT COLLATE RMNOCASE
  RefNumber TEXT    
  ActualText TEXT    
  Comments TEXT    
  IsPrivate INTEGER    
  TemplateID INTEGER    
  Fields BLOB    
INDEX idxSourceName Name    
         
       
SourceTemplateTable
  Field Name Type Key Notes
  TemplateID INTEGER PRIMARY KEY  
  Name TEXT COLLATE RMNOCASE
  Description TEXT    
  Favorite INTEGER    
  Category TEXT    
  Footnote TEXT    
  ShortFootnote TEXT    
  Bibliography TEXT    
  FieldDefs BLOB    
INDEX idxSourceTemplateName Name    
         
       
WitnessTable
  Field Name Type Key Notes
  WitnessID INTEGER PRIMARY KEY  
  EventID INTEGER    
  PersonID INTEGER    
  WitnessOrder INTEGER    
  Role INTEGER    
  Sentence TEXT    
  Note BLOB    
  Given TEXT COLLATE RMNOCASE
  Surname TEXT COLLATE RMNOCASE
  Prefix TEXT COLLATE RMNOCASE
  Suffix TEXT COLLATE RMNOCASE
INDEX idxWitnessEventID EventID    
INDEX idxWitnessPersonID PersonID    

RootsMagic Home   RootsMagic Forums   purchase RootsMagic
Gedcom 5.5 standard
Gedcom 5.5 standard in Windows Help File (.chm) format

Please email new content or corrections: