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