Primary Key = Highlighted in Yellow |
|
|
|
|
|
|
|
|
|
Secondary Key = Highlighted in Peach |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
household |
|
|
|
privacy |
|
|
|
|
relation |
|
|
household_id |
unique integer |
Not Null |
|
privacy_id |
unique integer |
|
Not Null |
|
person_id |
integer |
Not Null |
name |
varchar(50) |
Not Null |
|
type |
varchar(255) |
|
Not Null |
|
related_person_id |
integer |
Not Null |
descr |
text |
|
|
descr |
text |
|
|
|
date |
date/time |
|
|
|
|
|
|
|
|
|
|
relation_type_id |
integer |
Not Null |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
address |
|
|
|
person |
|
|
|
|
relation_type |
|
|
address_id |
unique integer |
Not Null |
|
person_id |
unique integer |
|
Not Null |
|
relation_type_id |
integer |
Not Null |
|
|
|
|
|
|
|
|
|
Recip |
integer |
Not Null |
country_id |
integer |
Not Null |
|
household_id |
integer |
|
Not Null |
|
descr |
varchar(255) |
Not Null |
address_1 |
varchar(255) |
|
|
address_id |
integer |
|
Not Null |
|
|
|
|
address_2 |
varchar(255) |
|
|
privacy_code |
integer |
bitwise thingy for privacy |
Not Null |
|
|
|
|
city |
varchar(255) |
|
|
title |
varchar(5) |
|
|
|
picture |
|
|
state_province |
varchar(255) |
|
|
first_name |
varchar(50) |
|
|
|
picture_id |
unique integer |
Not Null |
postal_code |
varchar(10) |
|
|
middle_name |
varchar(20) |
|
|
|
privacy_code |
integer |
Not Null |
phone |
varchar(20) |
|
|
last_name |
varchar(50) |
|
|
|
caption |
varchar(255) |
|
|
|
|
|
maiden_name |
varchar(50) |
|
|
|
mime_type |
varchar(25) |
Not Null |
|
|
|
|
gender |
varchar(1) |
|
|
|
descr |
text |
|
country |
|
|
|
birth_date |
date/time |
|
|
|
date_taken |
date/time |
|
country_id |
unique integer |
Not Null |
|
homepage |
varchar(255) |
|
|
|
date_uploaded |
date/time |
|
name |
varchar(255) |
Not Null |
|
email_address |
varchar(255) |
|
|
|
person_id |
integer |
Not Null |
|
|
|
|
deceased_date |
date/time |
|
|
|
data |
mediumblob |
Not Null |
|
|
|
|
descr |
text |
|
|
|
|
|
|
news |
|
|
|
type |
integer |
0=normal user 1=head 2=admin |
Not Null |
|
|
|
|
news_id |
unique integer |
Not Null |
|
username |
varchar(20) |
|
Not Null |
|
picture_association |
|
|
person_id |
integer |
Not Null |
|
password |
varchar(255) |
|
|
|
picture_id |
integer |
Not Null |
title |
varchar(100) |
Not Null |
|
password_hint |
varchar(255) |
|
|
|
person_id |
integer |
Not Null |
content |
text |
|
|
picture_id |
integer |
|
|
|
|
|
|
publish_date |
date/time |
default now |
|
status |
integer |
1=active 2=pending 3=excommunicated |
Not Null |
|
|
|
|
|
|
|
|
|
|
|
|
|
event |
|
|
|
|
|
|
|
|
|
|
|
event_id |
unique integer |
Not Null |
|
|
|
|
event_type |
|
|
|
|
event_type_id |
integer |
Not Null |
Quotes |
|
|
|
event_type_id |
unique integer |
|
Not Null |
|
person_id |
integer |
Not Null |
quote_id |
integer |
|
|
descr |
text |
|
Not Null |
|
start |
date/time |
Not Null |
Author |
varchar(255) |
|
|
|
|
|
|
|
end |
date/time |
|
Quote |
varchar(255) |
|
|
|
|
|
|
|
descr |
text |
Not Null |
|
|
|
|
prior_addresses |
|
|
|
|
Type |
varchar(255) |
|
|
|
|
|
person_id |
integer |
|
Not Null |
|
Annual |
varchar(255) |
|
|
|
|
|
address_id |
integer |
|
Not Null |
|
location |
text |
|
|
|
|
|
descr |
varchar(255) |
|
|
|
|
|
|
|
|
|
|
start |
date |
|
|
|
log |
|
|
|
|
|
|
end |
date |
|
|
|
log_id |
unique integer |
Not Null |
|
|
|
|
|
|
|
|
|
person_id |
integer |
|
|
|
|
|
|
|
|
|
|
household_id |
integer |
|
|
|
|
|
|
|
|
|
|
system_log_status |
integer |
|
|
|
|
|
|
|
|
|
|
date |
date/time |
default now |
|
|
|
|
|
|
|
|
|
title |
varchar(255) |
Not Null |
|
|
|
|
|
|
|
|
|
household_log_status |
integer |
|
|
|
|
|
|
|
|
|
|
content |
text |
Not Null |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
comment |
|
|
|
|
|
|
|
|
|
|
|
comment_id |
unique integer |
Not Null |
|
|
|
|
|
|
|
|
|
log_id |
integer |
Not Null |
|
|
|
|
|
|
|
|
|
person_id |
integer |
Not Null |
|
|
|
|
|
|
|
|
|
date |
date/time |
default now |
|
|
|
|
|
|
|
|
|
title |
varchar(255) |
Not Null |
|
|
|
|
|
|
|
|
|
comment |
text |
Not Null |