Dumped on 2003-07-01

• public
• author
• link
• note
• part
• part_author
• partdata
• publication
• publication_author
• publisher

---

Table: author

author Structure

F-Key	Name	Type	Description
	no	integer	DEFAULT nextval('kaspa_seq'::text)
	lastname	text	DEFAULT ''
	firstname	text	DEFAULT ''
	pseudonym	text	DEFAULT ''
	born	text	DEFAULT ''
	died	text	DEFAULT ''
	country	text	DEFAULT ''
	memo	text	DEFAULT ''
	created	timestamp with time zone	DEFAULT "timestamp"('now'::text)
	modified	timestamp with time zone	DEFAULT "timestamp"('now'::text)

Index - Schema public

---

Table: link

link Structure

F-Key	Name	Type	Description
	obj_1	integer
	obj_2	integer
	tbl	text	DEFAULT ''
	created	timestamp with time zone	DEFAULT "timestamp"('now'::text)
	modified	timestamp with time zone	DEFAULT "timestamp"('now'::text)

Index - Schema public

---

Table: note

note Structure

F-Key	Name	Type	Description
	no	integer	DEFAULT nextval('kaspa_seq'::text)
	title	text	DEFAULT ''
	memo	text
	type	smallint
	publication_no	integer
	created	timestamp with time zone	DEFAULT "timestamp"('now'::text)
	modified	timestamp with time zone	DEFAULT "timestamp"('now'::text)
	parent	integer
	sibling	integer

Index - Schema public

---

Table: part

part Structure

F-Key	Name	Type	Description
	no	integer	DEFAULT nextval('kaspa_seq'::text)
	publication_no	integer
	partno	smallint	DEFAULT 1
	title	text	DEFAULT ''
	pages	text	DEFAULT ''
	memo	text	DEFAULT ''
	key	text	DEFAULT ''
	language	text	DEFAULT ''
	bibtex	text	DEFAULT ''
	intro_no	integer
	createbibtex	boolean	DEFAULT false
	created	timestamp with time zone	DEFAULT "timestamp"('now'::text)
	modified	timestamp with time zone	DEFAULT "timestamp"('now'::text)

Index - Schema public

---

Table: part_author

part_author Structure

F-Key	Name	Type	Description
	part_no	integer
	author_no	integer
	created	timestamp with time zone	DEFAULT "timestamp"('now'::text)
	modified	timestamp with time zone	DEFAULT "timestamp"('now'::text)
	author_order	integer

Index - Schema public

---

Table: partdata

partdata Structure

F-Key	Name	Type	Description
	no	integer	DEFAULT nextval('kaspa_seq'::text)
	part_no	integer
	file	text	DEFAULT ''
	astext	text	DEFAULT ''
	filename	text	DEFAULT ''
	type	text	DEFAULT ''
	created	timestamp with time zone	DEFAULT "timestamp"('now'::text)
	modified	timestamp with time zone	DEFAULT "timestamp"('now'::text)

Index - Schema public

---

Table: publication

publication Structure

F-Key	Name	Type	Description
	no	integer	DEFAULT nextval('kaspa_seq'::text)
	title	text	DEFAULT ''
	subtitle	text	DEFAULT ''
	edition	smallint
	editor	text	DEFAULT ''
	howpublished	text	DEFAULT ''
	organization	text	DEFAULT ''
	publisher_no	integer
	year	text	DEFAULT ''
	pages	text	DEFAULT ''
	translator	text	DEFAULT ''
	volume	text	DEFAULT ''
	number	text	DEFAULT ''
	month	text	DEFAULT ''
	series	text	DEFAULT ''
	type	text	DEFAULT ''
	key	text	DEFAULT ''
	orgtitle	text	DEFAULT ''
	orgpublisher_no	integer
	orgyear	text	DEFAULT ''
	isbn_issn	text	DEFAULT ''
	hidingplace	text	DEFAULT ''
	bibtex	text	DEFAULT ''
	entrytype	smallint
	memo	text
	createbibtex	boolean	DEFAULT false
	created	timestamp with time zone	DEFAULT "timestamp"('now'::text)
	modified	timestamp with time zone	DEFAULT "timestamp"('now'::text)

Index - Schema public

---

Table: publication_author

publication_author Structure

F-Key	Name	Type	Description
	publication_no	integer
	author_no	integer
	created	timestamp with time zone	DEFAULT "timestamp"('now'::text)
	modified	timestamp with time zone	DEFAULT "timestamp"('now'::text)
	author_order	integer

Index - Schema public

---

Table: publisher

publisher Structure

F-Key	Name	Type	Description
	no	integer	DEFAULT nextval('kaspa_seq'::text)
	name	text	DEFAULT ''
	city	text	DEFAULT ''
	serie	text	DEFAULT ''
	created	timestamp with time zone	DEFAULT "timestamp"('now'::text)
	modified	timestamp with time zone	DEFAULT "timestamp"('now'::text)

Index - Schema public

W3C HTML 4.01 Strict