Kith and Kin Pro manual - Database fields

Kith and Kin Pro stores family tree data in a relational database. This consists of several separate tables (files) within the database folder which are linked together by common fields. To understand how to create custom SQL queries you need to know what the available database tables and fields are and how they are linked together.

Field types

String - Text field; 1 to 255 characters
Small integer - 16-bit integer field; whole numbers in the range -32767 to 32767
Integer - 32-bit integer field; whole numbers in the range -2147483648 to 2147483647
Byte - 8-bit integer field; whole numbers in the range 0 to 255
Decimal - Floating-point numeric field; -10E307 to 10E308 with 15 significant digits
Logical - Boolean field; "true" or "false"
Multi-line - Text field which can hold more than one line of text.
Date - Date field

Table name	Field name	Type	Links / Notes
Aliases	PersonCode	Integer	People \| Code
	Date of change	Date
	Surname	String (60)
	Firstnames	String (60)
	Soundex	String (4)	Soundex code for the surname
	Metaphone	String (10)	Metaphone code for the surname
Documents	Code	Integer
	Title	String (60)
	Author	String (60)
	Publication	Multi-line
	Repository	Integer	Repositories \| Code
	Repositorys ref	String (60)
	Media	String (60)
	Notes	Multi-line
Families	Code	Integer
	Description	String (120)
	Marriage date	Date
	Marriage place	String (60)
	Divorce date	Date
	Divorce place	String (60)
	Fathers name	String (60)	Surname first for sorting
	Mothers name	String (60)	Surname first for sorting
	Change date	Date	Date of last record change
	Changed	Logical	Record changed flag
	Layer	Integer	Layers \| Code
	(user-defined fields)
Layers	Code	Integer
Layers	Description	String (60)	Layer name
Links	RecType	String (1)
	PersFam	Integer	People \| Code if RecType = 'P'; Families \| Code if RecType = 'F'
	ChildMarr	Integer	Families \| Code if RecType = 'P'; People \| Code if RecType = 'F'
	Order	Decimal
	Definite	Logical	False = probable link
Notes	RecordType	String (1)
	RecordCode	Integer	People \| Code if RecordType = 'P'; Families \| Code if RecordType = 'F'
	Code	Integer
	Description	String (60)
	PrivacyLevel	Small integer
	Notes	Multi-line
Objects	RecordType	String (1)
	RecordCode	Integer	People \| Code if RecordType = 'P'; Families \| Code if RecordType = 'F'
	Code	Integer
	Order	Integer	Sequence number to define the order
	Description	String (60)
People	Code	Integer
	Description	String (120)
	Surname	String (60)
	Firstnames	String (60)
	Male	Logical	True = male
	Birth date	Date
	Birth place	String (60)
	Christening date	Date
	Christening place	String (60)
	Death date	Date
	Death place	String (60)
	Burial date	Date
	Burial place	String (60)
	Search date	Date	Birth or christening date for sorting
	Search place	String (60)	Birth or christening place for sorting
	Dead	Logical	True = dead
	Change date	Date	Date of last record change
	Changed	Logical	Record changed flag
	Soundex	String (4)	Soundex code for the surname
	Metaphone	String (10)	Metaphone code for the surname
	(user-defined fields)
Pictures	RecordType	String (1)
	RecordCode	Integer	People \| Code if RecordType = 'P' Families \| Code if RecordType = 'F' Documents \| Code if RecordType = 'D' Sources \| Order if RecordType = 'S'
	Code	Integer
	Order	Integer	Sequence number to define the order
	InPrints	Logical	True = include in printouts
	Description	String (60)
	Filename	String (60)	Image filename relative to the Pictures folder
	Width	Small integer	in tenths mm
	Height	Small integer	in tenths mm
PLayers			Identifies the layers each person is on
	PersonCode	Integer	People \| Code
	LayerCode	Integer	Layer \| Code
Repositories	Code	Integer
	Name	String (60)
	Address	Multi-line
	Phone	String (20)
	Email	String (60)
	Web site	String (60)
	Notes	Multi-line
Sources	Order	Integer	Sequence number to define the order
	RecordType	String (1)
	RecordCode	Integer	People \| Code if RecordType = 'P'; Families \| Code if RecordType = 'F
	FieldName	String (30)
	Document	Integer	Documents \| Code
	Page	String (60)
	Quay	Small integer	Quality of data; 0=Primary evidence - 3=Unreliable
	Notes	Multi-line
UFields			Holds the definitions for user-defined fields
	RecType	String (1)	People table if = 'P'; Families table if = 'F'
	FieldName	String (25)
	GEDTag1	String (5)
	GEDTag2	String (5)
	GEDTag3	String (5)
	PrivacyLevel	Small integer

Database fields

See also