obituary

0 rows


Description

Information about an obituary for a person

Columns

Column Type Size Nulls Auto Default Children Parents Comments
obituaryId INT 10 null
personId INT 10 null
person.personId Implied Constraint R

The person this obituary is for

source VARCHAR 255 NULL
date DATE 10 NULL
sourcePage VARCHAR 25 NULL
contents LONGTEXT 2147483647 NULL
picture VARCHAR 255 NULL
dateDay INT 10 NULL
dateMonth INT 10 NULL
dateYear INT 10 NULL

Indexes

Constraint Name Type Sort Column(s)
obituary_s_pk Primary key Asc obituaryId
PRIMARY Must be unique Asc obituaryId

Relationships