/* Pendragon database concept.  Possible relational links noted as comments. Only the most basic fields are required, the rest can be null.*/

create table person (
	person_id		integer not null primary key,
	person_name		varchar(100) not null,
	person_sex		char(1),
	person_birth		char(3), --simple math for current age display -
	person_death		char(3),

/* Family data is either relational with separate fields or a single "family" field. */

	person_father		person_name
person_mother		person_name
	person_child		person_name
	person_family		varchar (700), 

	person_desc		varchar(700), 
	person_owns		varchar(100), -- or location_owned --

	person_siz		varchar(2),
	person_str		varchar(2),
	person_dex		varchar(2),
	person_con		varchar(2),
	person_app		varchar(2),

	person_battle		varchar(2),
	person_melee		varchar(2),
	person_horse		varchar(2),
	person_lance		varchar(2),

	person_notes		varchar(700), --noteworthy traits/passions/skills --
);

create table event (
	event_id		integer not null primary key,
	event_date		char(3) not null,
	event_desc		varchar(700) not null,
);

create table location (
	l_id		integer not null primary key,
	l_name		varchar(100) not null,
	l_georegion	varchar(100), --or location_name--
	l_polregion_owner	varchar(100), --or person_owns--
	l_desc		varchar(700),
	l_image
	l_gm
	l_gmnotes
);


id
mapname
localname
georegion
polregion
desc
image
gm
gmnotes