person

0 rows

Description

Stores information about a particular person for use in genealogy

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

personId

INT

10

√

null

marriage.personId	Implied Constraint	R
obituary.personId	Implied Constraint	R

firstName

VARCHAR

100

√

NULL

middleName

VARCHAR

100

√

NULL

lastName

VARCHAR

100

√

NULL

maidenName

VARCHAR

100

√

NULL

otherName

VARCHAR

100

√

NULL

nickName

VARCHAR

100

√

NULL

birthDate

DATE

10

√

NULL

deathDate

DATE

10

√

NULL

ageAtDeath

MEDIUMTEXT

16777215

√

NULL

Showing 1 to 10 of 41 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
person_s_pk	Primary key	Asc	personId
PRIMARY	Must be unique	Asc	personId

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation

One
One implied