Dumped on 2003-09-28

Index of database - CTDDBR

public

dominion
dominionlord
dominiontype
escheatoath
fae
faetype
fealtygreateroath
freehold
freeholdsize
holdingoath
house
incarnation
kith
mortal
pookaform
sidhehouse
soul

Table: dominion

dominion Structure
F-Key	Name	Type	Description
	dominion_id	serial	PRIMARY KEY
	dominion_name	character varying(50)	UNIQUE NOT NULL
dominiontype.dominion_type_id	dominion_type_id	integer	NOT NULL
	notes	text

Tables referencing this one via Foreign Key Constraints:

dominionlord

Index - Schema public

Table: dominionlord

dominionlord Structure
F-Key	Name	Type	Description
dominion.dominion_id	dominion_id	integer	PRIMARY KEY
fae.fae_id	lord_id	integer	PRIMARY KEY
	start_date	date	PRIMARY KEY
	end_date	date
	title	character varying(50)

Index - Schema public

Table: dominiontype

dominiontype Structure
Name	Type	Description
dominion_type_id	serial	PRIMARY KEY
dominion_type	character varying(50)
notes	text

Tables referencing this one via Foreign Key Constraints:

dominion

Index - Schema public

Table: escheatoath

escheatoath Structure
F-Key	Name	Type	Description
fae.fae_id	lord_id	integer	PRIMARY KEY
fae.fae_id	vassal_id	integer	PRIMARY KEY
	oath_date	date	PRIMARY KEY
	release_date	date
freehold.freehold_id	freehold_id	integer
	notes	text

Index - Schema public

Table: fae

fae Structure
F-Key	Name	Type	Description
	fae_id	serial	PRIMARY KEY
faetype.fae_type_id	fae_type_id	integer	NOT NULL

Tables referencing this one via Foreign Key Constraints:

dominionlord

escheatoath

fealtygreateroath

holdingoath

incarnation

soul

Index - Schema public

Table: faetype

faetype Structure
F-Key	Name	Type	Description
	fae_type_id	serial	PRIMARY KEY
	fae_type	character varying(20)	NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: fealtygreateroath

fealtygreateroath Structure
F-Key	Name	Type	Description
fae.fae_id	vassal_id	integer	PRIMARY KEY
fae.fae_id	lord_id	integer	NOT NULL
	notes	text

Index - Schema public

Table: freehold

freehold Structure
F-Key	Name	Type	Description
	freehold_id	serial	PRIMARY KEY
	freehold_name	character varying(50)	NOT NULL
	region	character varying(50)
	address	character varying(200)
freeholdsize.size_id	size_id	integer
	notes	text

Tables referencing this one via Foreign Key Constraints:

escheatoath

holdingoath

Index - Schema public

Table: freeholdsize

freeholdsize Structure
F-Key	Name	Type	Description
	size_id	serial	PRIMARY KEY
	size	character varying(20)	UNIQUE NOT NULL

Tables referencing this one via Foreign Key Constraints:

freehold

Index - Schema public

Table: holdingoath

holdingoath Structure
F-Key	Name	Type	Description
freehold.freehold_id	freehold_id	integer	PRIMARY KEY
fae.fae_id	fae_id	integer	PRIMARY KEY
	oath_date	date	PRIMARY KEY
	release_date	date
	notes	text

Index - Schema public

Table: house

house Structure
F-Key	Name	Type	Description
	house_id	serial	PRIMARY KEY
	house_name	character varying(50)	UNIQUE NOT NULL

Tables referencing this one via Foreign Key Constraints:

sidhehouse

Index - Schema public

Table: incarnation

incarnation Structure
F-Key	Name	Type	Description
fae.fae_id	fae_id	integer	PRIMARY KEY
fae.fae_id	soul_fae_id	integer	NOT NULL
mortal.mortal_id	mortal_id	integer	NOT NULL
	incarnation_name	character varying(50)	NOT NULL
	chrysalis_date	date
	sain_date	date
	notes	text

Tables referencing this one via Foreign Key Constraints:

pookaform

Index - Schema public

Table: kith

kith Structure
F-Key	Name	Type	Description
	kith_id	serial	PRIMARY KEY
	kith_name	character varying(50)	UNIQUE NOT NULL

Tables referencing this one via Foreign Key Constraints:

soul

Index - Schema public

Table: mortal

mortal Structure
Name	Type	Description
mortal_id	serial	PRIMARY KEY
mortal_name	character varying(50)	NOT NULL
dob	date
dod	date
notes	text

Tables referencing this one via Foreign Key Constraints:

incarnation

Index - Schema public

Table: pookaform

pookaform Structure
F-Key	Name	Type	Description
incarnation.fae_id	fae_id	integer	PRIMARY KEY
	animal	character varying(50)	NOT NULL
	notes	text

Index - Schema public

Table: sidhehouse

sidhehouse Structure
F-Key	Name	Type	Description
soul.fae_id	fae_id	integer	PRIMARY KEY
house.house_id	house_id	integer	NOT NULL

Index - Schema public

Table: soul

soul Structure
F-Key	Name	Type	Description
fae.fae_id	fae_id	integer	PRIMARY KEY
kith.kith_id	kith_id	integer	NOT NULL
	soul_name	character varying(50)	NOT NULL
	notes	text

Tables referencing this one via Foreign Key Constraints:

sidhehouse

Index - Schema public

Generated by PostgreSQL Autodoc

W3C HTML 4.01 Strict