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