| Genealogia version 0.7.x (Rev 1) database |
|
|
|
|
|
|
|
| CheckOuts |
|
|
|
| Column_name |
Type |
Maxlength |
Precision |
Scale |
Is Nullable |
Description |
|
| CheckOutId |
Number |
|
10 |
|
not null |
Id for Checkout |
|
| CheckOutBy |
Text |
255 |
|
Name of person who has checked
the data |
|
| CheckOutDate |
Date/Time |
|
Date/Time when checkout was made |
|
|
|
|
| Conversions |
|
|
|
| Column_name |
Type |
Maxlength |
Precision |
Scale |
Is Nullable |
Description |
|
| ConversionId |
Number |
|
10 |
|
not null |
Line id |
|
| FromText |
Text |
50 |
|
Text to be converted |
|
| Language |
Text |
2 |
|
Language to be converted to |
|
| Rule |
Text |
15 |
|
Rule to use |
|
| ToText |
Text |
50 |
|
Result when rule and language
matches |
|
|
|
|
| Groups |
|
|
|
| Column_name |
Type |
Maxlength |
Precision |
Scale |
Is Nullable |
Description |
|
| GroupId |
Number |
|
10 |
|
not null |
Numeric Id for the group |
|
| Name |
Text |
50 |
|
Group Name |
|
| Description |
Text |
255 |
|
Additional description of the
group |
|
| CreateDate |
Date/Time |
|
not null |
Date/Time created |
|
|
|
|
| Notices |
|
|
|
| Column_name |
Type |
Maxlength |
Precision |
Scale |
Is Nullable |
Description |
|
| NoticeId |
Number |
|
10 |
|
not null |
Numeric Id that identifies this
Notice, supplied by the system |
|
| Tag |
Text |
8 |
|
not null |
Tag of the Notice, Level 1
GEDCOM tags |
|
| Privacy |
Text |
1 |
|
Privacy indicator, null = Public |
|
| UnitId |
Number |
|
10 |
|
not null |
Id of the Unit for this
UnitNotice (can be null) |
|
| NoticeRow |
Number |
|
10 |
|
not null |
Row # of the Notice for the unit |
|
| NoticeType |
Text |
50 |
|
Notice type |
|
| Description |
Text |
255 |
|
Description or remark |
|
| FromDatePrefix |
Text |
8 |
|
Prefix for the date (beginning
date if date period) |
|
| FromDate |
Text |
8 |
|
Date for the event described in
this notice |
|
| ToDate |
Text |
8 |
|
Date for the event described in
this notice |
|
| Place |
Text |
255 |
|
Place |
|
| Address |
Text |
255 |
|
Street address |
|
| PostOffice |
Text |
50 |
|
Place of the event, Postoffice,
City |
|
| PostalCode |
Text |
20 |
|
Postal Code |
|
| Country |
Text |
50 |
|
Country |
|
| Email |
Text |
255 |
|
Email-address or web-page of
person |
|
| NoteText |
Memo |
0 |
|
Note textfield |
|
| MediaFilename |
Text |
255 |
|
Filename of the multimedia file |
|
| MediaTitle |
Text |
255 |
|
Text describing the multimedia
file |
|
| Prefix |
Text |
50 |
|
Prefix of the surname |
|
| Surname |
Text |
50 |
|
Surname |
|
| Givenname |
Text |
255 |
|
Givenname |
|
| PostFix |
Text |
50 |
|
Name Postfix |
|
| SourceId |
Number |
|
10 |
|
Id to Source record in the
Sources |
|
| SourceText |
Text |
255 |
|
Additional info for above source |
|
| PrivateText |
Text |
255 |
|
Private researcher information |
|
| CreateDate |
Date/Time |
|
not null |
Date/Time created |
|
|
|
|
| Relations |
|
|
|
| Column_name |
Type |
Maxlength |
Precision |
Scale |
Is Nullable |
Description |
|
| RelationId |
Number |
|
10 |
|
not null |
Numeric Id that identifies this
Relation, supplied by the system |
|
| Tag |
Text |
15 |
|
not null |
Tag of the relation ( MARR or
CHIL) |
|
| UnitIdA |
Number |
|
10 |
|
not null |
Unit Id of Person (or first
unit) A of the relation |
|
| UnitIdB |
Number |
|
10 |
|
not null |
Unit Id of Person (or other
unit) B of the relation |
|
| RelationRowA |
Number |
|
10 |
|
not null |
Row # of the Relation for Unit
A. MARR = Male, CHIL = Child |
|
| RelationRowB |
Number |
|
10 |
|
not null |
Row # of the Relation for Unit
B. MARR = Female, CHIL = Parent |
|
| Description |
Text |
255 |
|
Description of relation (for
parent/child relations not null means adopted) |
|
| BeginType |
Text |
50 |
|
Type such as type of marriage |
|
| BeginFromDatePrefix |
Text |
8 |
|
Prefix for the date (beginning
date if date period) |
|
| BeginFromDate |
Text |
8 |
|
Date for the (beginning) event
described in this notice |
|
| BeginToDate |
Text |
8 |
|
End Date for the beginning even |
|
| BeginPlace |
Text |
255 |
|
Place for the (beginning of the)
event |
|
| EndType |
Text |
50 |
|
Type of end event |
|
| EndFromDatePrefix |
Text |
8 |
|
Prefix for the start date of a
dateintervall of the end date |
|
| EndFromDate |
Text |
8 |
|
Date for the relation end event |
|
| EndToDate |
Text |
8 |
|
Date for end date for teh alst
date |
|
| EndPlace |
Text |
255 |
|
Place of relation end event |
|
| NoteText |
Memo |
0 |
|
Note textfield |
|
| SourceId |
Number |
|
10 |
|
Id to Source record in the
Sources |
|
| SourceText |
Text |
255 |
|
Additional info for above source |
|
| PrivateText |
Text |
255 |
|
Private researcher information |
|
| CreateDate |
Date/Time |
|
not null |
Date/time when created |
|
|
|
|
| Reports |
|
|
|
| Column_name |
Type |
Maxlength |
Precision |
Scale |
Is Nullable |
Description |
|
| ReportId |
Number |
|
10 |
|
not null |
Report numeric Id is supplied by
the system |
|
| FirstTableNumber |
Number |
|
10 |
|
Table number of first table for
this report |
|
| LastTableNumber |
Number |
|
10 |
|
Last table number for this
descendant report |
|
| SubjectId |
Number |
|
10 |
|
Unit Id of Report main person
(Subject) |
|
| Description |
Text |
255 |
|
not null |
Description ( name) of the
report |
|
| NoteText |
Memo |
0 |
|
Note textfield |
|
| MediaFilename |
Text |
255 |
|
Filename of the multimedia file |
|
| MediaTitle |
Text |
255 |
|
Text describing the multimedia
file |
|
| WorkFamilyDate |
Date/Time |
|
Time of update of the
Tablenumbers in Workfamily |
|
| CreateDate |
Date/Time |
|
not null |
Date/Time created |
|
|
|
|
| Sources |
|
|
|
| Column_name |
Type |
Maxlength |
Precision |
Scale |
Is Nullable |
Description |
|
| SourceId |
Number |
|
10 |
|
not null |
Numeric Id of the source is
supplied by the system |
|
| SourceNote |
Memo |
0 |
|
Source textfield |
|
| CreateDate |
Date/Time |
|
not null |
Date/Time created |
|
|
|
|
| SukuVariables |
|
|
|
| Column_name |
Type |
Maxlength |
Precision |
Scale |
Is Nullable |
Description |
|
| OwnerName |
Text |
255 |
|
Owner Name |
|
| OwnerInfo |
Memo |
0 |
|
Text describing the database |
|
| OwnerAddress |
Text |
255 |
|
Street address of Owner |
|
| OwnerPostOffice |
Text |
50 |
|
Postoffice, City of Owner |
|
| OwnerPostalCode |
Text |
20 |
|
Postal Code of Owner |
|
| OwnerCountry |
Text |
50 |
|
Country of Owner |
|
| OwnerEmail |
Text |
255 |
|
Email address or web-page of
owner |
|
| WorkFamilyDate |
Date/Time |
|
Time of last update of the work
family tables |
|
| MediaPath |
Text |
255 |
|
Path to the Multimedia folder relative to the Genealogia database |
|
|
|
|
| Units |
|
|
|
| Column_name |
Type |
Maxlength |
Precision |
Scale |
Is Nullable |
Description |
|
| UnitId |
Number |
|
10 |
|
not null |
Person ( or other unit)
identification |
|
| Tag |
Text |
15 |
|
not null |
Tag of the type of unit (INDI) |
|
| CheckOutId |
Number |
|
10 |
|
Id for Checkout, Units data
cannot be modified if this is not null |
|
| Privacy |
Text |
1 |
|
Privacy indicator, null = Public |
|
| Prefix |
Text |
50 |
|
von, af, van or similar surname
prefix |
|
| Surname |
Text |
50 |
|
Surname of the person or name of
other unit |
|
| Givenname |
Text |
255 |
|
Given name of the person |
|
| PostFix |
Text |
50 |
|
Name Postfix |
|
| GroupId |
Number |
|
10 |
|
Id of group for this unit |
|
| Sex |
Text |
1 |
|
not null |
Male = M, Female = F, Unknown =
U |
|
| FirstDate |
Text |
8 |
|
First Date when unit has been,
such as Birth date of a person |
|
| FirstTag |
Text |
8 |
|
Tag of notice that describes the
first date (BIRT or CHR) |
|
| LastDate |
Text |
8 |
|
Last Date of a person such as
Death date |
|
| LastTag |
Text |
8 |
|
Tag of notice that describes the
last date (DEAT or BURI) |
|
| SourceId |
Number |
|
10 |
|
Id to Source record in the
Sources |
|
| SourceText |
Text |
255 |
|
Additional info for above source |
|
| PrivateText |
Text |
255 |
|
Private researcher information |
|
| UserREFN |
Text |
50 |
|
Reference number to the unit.
GEDCOM REFN tag |
|
| CreateDate |
Date/Time |
|
not null |
Date/Time created |
|
|
|
|
| Views |
|
|
|
| Column_name |
Type |
Maxlength |
Precision |
Scale |
Is Nullable |
Description |
|
| ViewId |
Number |
|
10 |
|
not null |
Numeric id for the View
(supplied by the system) |
|
| Description |
Text |
255 |
|
not null |
Description (name) of the view |
|
| Author |
Text |
255 |
|
Author of the view |
|
| CreateDate |
Date/Time |
|
not null |
Date/time when the view was
created |
|
|
|
|
| ViewUnits |
|
|
|
| Column_name |
Type |
Maxlength |
Precision |
Scale |
Is Nullable |
Description |
|
| UnitId |
Number |
|
10 |
|
Id of the unit |
|
| ViewId |
Number |
|
10 |
|
Id of the View |
|
| Value |
Number |
|
10 |
|
Value given to this. E.g.
conversion value |
|
|
|
|
| WorkFamily |
|
|
|
| Column_name |
Type |
Maxlength |
Precision |
Scale |
Is Nullable |
Description |
|
| FamilyId |
Number |
|
10 |
|
not null |
Id of this family |
|
| FatherId |
Number |
|
10 |
|
UnitId of father |
|
| MotherId |
Number |
|
10 |
|
UnitId of mother |
|
| HusbandRow |
Number |
|
10 |
|
Row # of marriage notice for husband |
|
| WifeRow |
Number |
|
10 |
|
Row # of marriage notice for
wife |
|
| TableNumber |
Number |
|
10 |
|
Number of table in report |
|
| SubjectId |
Number |
|
10 |
|
UnitId of the subject (same as
FatherId or MotherId) |
|
| Generation |
Number |
|
10 |
|
Generation for the subject of
the table |
|
|
|
|
| WorkFamilyRelation |
|
|
|
| Column_name |
Type |
Maxlength |
Precision |
Scale |
Is Nullable |
Description |
|
| FamilyRelationId |
Number |
|
10 |
|
not null |
Id of this family - child
relation |
|
| FamilyId |
Number |
|
10 |
|
not null |
The Id of the family |
|
| ChildId |
Number |
|
10 |
|
not null |
UnitId of the child |
|
| ChildSex |
Text |
1 |
|
not null |
Sex of the Child |
|
| FatherRow |
Number |
|
10 |
|
Row # of child notice for father |
|
| MotherRow |
Number |
|
10 |
|
Row # of child notice for mother |
|
| TableNumber |
Number |
|
10 |
|
Number of table where Child is
parent of family |
|
| Description |
Text |
255 |
|
Description of relation (for
parent/child relations not null means adopted) |
|
|
|
|
|
|
|
|
|
|
|