Database+System+Catalog

=RootsMagic 4 Database System Catalog=

A singular system table, sqlite_master, resides in a SQLite database. The table essentially defines the RootsMagic 4 database tables, indices, and fields as follows:

PRIMARY KEY, OwnerType INTEGER, AddressID INTEGER, OwnerID INTEGER, AddressNum INTEGER, Details TEXT ) || PRIMARY KEY, AddressType INTEGER, Name TEXT COLLATE RMNOCASE, Street1 TEXT, Street2 TEXT, City TEXT, State TEXT, Zip TEXT, Country TEXT, Phone1 TEXT, Phone2 TEXT, Fax TEXT, Email TEXT, URL TEXT, Latitude INTEGER, Longitude INTEGER, Note BLOB ) || KEY, ChildID INTEGER, FamilyID INTEGER, RelFather INTEGER, RelMother INTEGER, ChildOrder INTEGER, IsPrivate INTEGER, ProofFather INTEGER, ProofMother INTEGER, Note BLOB ) || (SourceID) || PRIMARY KEY, OwnerType INTEGER, SourceID INTEGER, OwnerID INTEGER, Quality TEXT, IsPrivate INTEGER, Comments BLOB, ActualText BLOB, RefNumber TEXT, Flags INTEGER, Fields BLOB ) || (OwnerID) || KEY, RecType INTEGER, Title TEXT, DataRec BLOB ) || KEY, EventType INTEGER, OwnerType INTEGER, OwnerID INTEGER, FamilyID INTEGER, PlaceID INTEGER, SiteID INTEGER, Date TEXT, SortDate INTEGER, IsPrimary INTEGER, IsPrivate INTEGER, Proof INTEGER, Status INTEGER, EditDate FLOAT, Sentence BLOB, Details BLOB, Note BLOB ) || (ExclusionType, ID1, ID2) || KEY, ExclusionType INTEGER, ID1 INTEGER, ID2 INTEGER ) || PRIMARY KEY, OwnerType INTEGER, Name TEXT COLLATE RMNOCASE, Abbrev TEXT, GedcomTag TEXT, UseValue INTEGER, UseDate INTEGER, UsePlace INTEGER, Sentence BLOB, Flags INTEGER ) || (Abbrev) || (Name) || (GedcomTag) || KEY, FatherID INTEGER, MotherID INTEGER, ChildID INTEGER, HusbOrder INTEGER, WifeOrder INTEGER, IsPrivate INTEGER, Proof INTEGER, SpouseLabel INTEGER, FatherLabel INTEGER, MotherLabel INTEGER, Note BLOB ) || (MotherID) || (FatherID) || KEY, GroupID INTEGER, StartID INTEGER, EndID INTEGER ) || KEY, LabelType INTEGER, LabelValue INTEGER, LabelName TEXT COLLATE RMNOCASE, Description TEXT ) || KEY, extSystem INTEGER, LinkType INTEGER, rmID INTEGER, extID TEXT, Modified INTEGER, extVersion TEXT, extDate FLOAT, Status INTEGER, Note BLOB ) || (OwnerID) || 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 ) || (Caption) || PRIMARY KEY, MediaType INTEGER, MediaPath TEXT, MediaFile TEXT COLLATE RMNOCASE, URL TEXT, Thumbnail BLOB ) || (MediaFile) || KEY, OwnerID INTEGER, Surname TEXT COLLATE RMNOCASE, Given TEXT COLLATE RMNOCASE, Prefix TEXT COLLATE RMNOCASE, Suffix TEXT COLLATE RMNOCASE, Nickname TEXT COLLATE RMNOCASE, NameType INTEGER, Date TEXT, SortDate INTEGER, IsPrimary INTEGER, IsPrivate INTEGER, Proof INTEGER, EditDate FLOAT, Sentence BLOB, Note BLOB, BirthYear INTEGER, DeathYear INTEGER ) || Given, BirthYear, DeathYear) || 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 ) || KEY, PlaceType INTEGER, Name TEXT COLLATE RMNOCASE, Abbrev TEXT, Normalized TEXT, Latitude INTEGER, Longitude INTEGER, LatLongExact INTEGER, MasterID INTEGER, Note BLOB ) || (OwnerID) || 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 ) || (Name) || KEY, RoleName TEXT COLLATE RMNOCASE, EventType INTEGER, RoleType INTEGER, Sentence TEXT ) || KEY, Name TEXT COLLATE RMNOCASE, RefNumber TEXT, ActualText TEXT, Comments TEXT, IsPrivate INTEGER, TemplateID INTEGER, Fields BLOB ) || INTEGER PRIMARY KEY, Name TEXT COLLATE RMNOCASE, Description TEXT, Favorite INTEGER, Category TEXT, Footnote TEXT, ShortFootnote TEXT, Bibliography TEXT, FieldDefs BLOB ) || (Name) || 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 ) || (EventID) || (PersonID) ||
 * ~ type ||||~ name ||||~ tbl_name ||||~ rootpage ||||~ sql ||
 * table |||| AddressLinkTable |||| AddressLinkTable |||| 52 |||| CREATE TABLE AddressLinkTable (LinkID INTEGER
 * index |||| idxAddressName |||| AddressTable |||| 19 |||| CREATE INDEX idxAddressName ON AddressTable (Name) ||
 * table |||| AddressTable |||| AddressTable |||| 18 |||| CREATE TABLE AddressTable (AddressID INTEGER
 * index |||| idxChildID |||| ChildTable |||| 11 |||| CREATE INDEX idxChildID ON ChildTable (ChildID) ||
 * index |||| idxChildFamilyID |||| ChildTable |||| 12 |||| CREATE INDEX idxChildFamilyID ON ChildTable (FamilyID) ||
 * index |||| idxChildOrder |||| ChildTable |||| 13 |||| CREATE INDEX idxChildOrder ON ChildTable (ChildOrder) ||
 * table |||| ChildTable |||| ChildTable |||| 10 |||| CREATE TABLE ChildTable (RecID INTEGER PRIMARY
 * index |||| idxCitationSourceID |||| CitationTable |||| 50 |||| CREATE INDEX idxCitationSourceID ON CitationTable
 * table |||| CitationTable |||| CitationTable |||| 49 |||| CREATE TABLE CitationTable (CitationID INTEGER
 * index |||| idxCitationOwnerID |||| CitationTable |||| 51 |||| CREATE INDEX idxCitationOwnerID ON CitationTable
 * index |||| idxRecType |||| ConfigTable |||| 3 |||| CREATE INDEX idxRecType ON ConfigTable (RecType) ||
 * table |||| ConfigTable |||| ConfigTable |||| 2 |||| CREATE TABLE ConfigTable (RecID INTEGER PRIMARY
 * index |||| idxOwnerDate |||| EventTable |||| 17 |||| CREATE INDEX idxOwnerDate ON EventTable (OwnerID,SortDate) ||
 * index |||| idxOwnerEvent |||| EventTable |||| 15 |||| CREATE INDEX idxOwnerEvent ON EventTable (OwnerID,EventType) ||
 * table |||| EventTable |||| EventTable |||| 14 |||| CREATE TABLE EventTable (EventID INTEGER PRIMARY
 * index |||| idxExclusionIndex |||| ExclusionTable |||| 65 |||| CREATE UNIQUE INDEX idxExclusionIndex ON ExclusionTable
 * table |||| ExclusionTable |||| ExclusionTable |||| 64 |||| CREATE TABLE ExclusionTable (RecID INTEGER PRIMARY
 * table |||| FactTypeTable |||| FactTypeTable |||| 20 |||| CREATE TABLE FactTypeTable (FactTypeID INTEGER
 * index |||| idxFactTypeAbbrev |||| FactTypeTable |||| 22 |||| CREATE INDEX idxFactTypeAbbrev ON FactTypeTable
 * index |||| idxFactTypeName |||| FactTypeTable |||| 21 |||| CREATE INDEX idxFactTypeName ON FactTypeTable
 * index |||| idxFactTypeGedcomTag |||| FactTypeTable |||| 24 |||| CREATE INDEX idxFactTypeGedcomTag ON FactTypeTable
 * table |||| FamilyTable |||| FamilyTable |||| 5 |||| CREATE TABLE FamilyTable (FamilyID INTEGER PRIMARY
 * index |||| idxFamilyMotherID |||| FamilyTable |||| 8 |||| CREATE INDEX idxFamilyMotherID ON FamilyTable
 * index |||| idxFamilyFatherID |||| FamilyTable |||| 6 |||| CREATE INDEX idxFamilyFatherID ON FamilyTable
 * table |||| GroupTable |||| GroupTable |||| 63 |||| CREATE TABLE GroupTable (RecID INTEGER PRIMARY
 * table |||| LabelTable |||| LabelTable |||| 69 |||| CREATE TABLE LabelTable (LabelID INTEGER PRIMARY
 * index |||| idxLabelType |||| LabelTable |||| 70 |||| CREATE INDEX idxLabelType ON LabelTable (LabelType) ||
 * index |||| idxLinkRmId |||| LinkTable |||| 58 |||| CREATE INDEX idxLinkRmId ON LinkTable (rmID) ||
 * table |||| LinkTable |||| LinkTable |||| 57 |||| CREATE TABLE LinkTable (LinkID INTEGER PRIMARY
 * index |||| idxLinkExtId |||| LinkTable |||| 59 |||| CREATE INDEX idxLinkExtId ON LinkTable (extID) ||
 * index |||| idxMediaOwnerID |||| MediaLinkTable |||| 30 |||| CREATE INDEX idxMediaOwnerID ON MediaLinkTable
 * table |||| MediaLinkTable |||| MediaLinkTable |||| 28 |||| CREATE TABLE MediaLinkTable (LinkID INTEGER PRIMARY
 * index |||| idxMediaCaption |||| MediaLinkTable |||| 31 |||| CREATE INDEX idxMediaCaption ON MediaLinkTable
 * index |||| idxMediaURL |||| MultimediaTable |||| 27 |||| CREATE INDEX idxMediaURL ON MultimediaTable (URL) ||
 * table |||| MultimediaTable |||| MultimediaTable |||| 25 |||| CREATE TABLE MultimediaTable (MediaID INTEGER
 * index |||| idxMediaFile |||| MultimediaTable |||| 26 |||| CREATE INDEX idxMediaFile ON MultimediaTable
 * index |||| idxSurname |||| NameTable |||| 35 |||| CREATE INDEX idxSurname ON NameTable (Surname) ||
 * index |||| idxGiven |||| NameTable |||| 36 |||| CREATE INDEX idxGiven ON NameTable (Given) ||
 * table |||| NameTable |||| NameTable |||| 32 |||| CREATE TABLE NameTable (NameID INTEGER PRIMARY
 * index |||| idxNameOwnerID |||| NameTable |||| 34 |||| CREATE INDEX idxNameOwnerID ON NameTable (OwnerID) ||
 * index |||| idxNamePrimary |||| NameTable |||| 38 |||| CREATE INDEX idxNamePrimary ON NameTable (IsPrimary) ||
 * index |||| idxSurnameGiven |||| NameTable |||| 37 |||| CREATE INDEX idxSurnameGiven ON NameTable (Surname,
 * table |||| PersonTable |||| PersonTable |||| 4 |||| CREATE TABLE PersonTable (PersonID INTEGER PRIMARY
 * index |||| idxPlaceName |||| PlaceTable |||| 41 |||| CREATE INDEX idxPlaceName ON PlaceTable (Name) ||
 * index |||| idxPlaceAbbrev |||| PlaceTable |||| 42 |||| CREATE INDEX idxPlaceAbbrev ON PlaceTable (Abbrev) ||
 * table |||| PlaceTable |||| PlaceTable |||| 39 |||| CREATE TABLE PlaceTable (PlaceID INTEGER PRIMARY
 * index |||| idxResearchOwnerID |||| ResearchTable |||| 44 |||| CREATE INDEX idxResearchOwnerID ON ResearchTable
 * table |||| ResearchTable |||| ResearchTable |||| 43 |||| CREATE TABLE ResearchTable (TaskID INTEGER PRIMARY
 * index |||| idxResearchName |||| ResearchTable |||| 45 |||| CREATE INDEX idxResearchName ON ResearchTable
 * table |||| RoleTable |||| RoleTable |||| 60 |||| CREATE TABLE RoleTable (RoleID INTEGER PRIMARY
 * index |||| idxRoleEventType |||| RoleTable |||| 62 |||| CREATE INDEX idxRoleEventType ON RoleTable (EventType) ||
 * table |||| SourceTable |||| SourceTable |||| 46 |||| CREATE TABLE SourceTable (SourceID INTEGER PRIMARY
 * index |||| idxSourceName |||| SourceTable |||| 48 |||| CREATE INDEX idxSourceName ON SourceTable (Name) ||
 * table |||| SourceTemplateTable |||| SourceTemplateTable |||| 66 |||| CREATE TABLE SourceTemplateTable (TemplateID
 * index |||| idxSourceTemplateName |||| SourceTemplateTable |||| 67 |||| CREATE INDEX idxSourceTemplateName ON SourceTemplateTable
 * table |||| WitnessTable |||| WitnessTable |||| 53 |||| CREATE TABLE WitnessTable (WitnessID INTEGER
 * index |||| idxWitnessEventID |||| WitnessTable |||| 55 |||| CREATE INDEX idxWitnessEventID ON WitnessTable
 * index |||| idxWitnessPersonID |||| WitnessTable |||| 56 |||| CREATE INDEX idxWitnessPersonID ON WitnessTable