Language

The Free and Open Productivity Suite

Released: Apache OpenOffice 4.1.15

home » bibliographic

Summary File for Database : BiblioDB (Build 33)

er-diagram

Date of creation: 2006-04-10 11:20:24

reference_items

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	X	-	X	-	�	X	�
reference_type_id	reference_types(id)	int	-	-	X	-	�	X	�
title	Varchar-255	varchar(255)	-	-	X	-	�	-	�
year	date	date	-	-	-	-	�	-	�
locators_id	locators(id)	int	-	-	-	-	�	X	�
description	text	varchar(32,000)	-	-	-	-	�	-	�
collection_id	collections(id)	int	-	-	-	-	�	-	�
container_id	smallint	smallint	-	-	-	-	�	-	�
abstract	text	varchar(32,000)	-	-	-	-	�	-	�
event_id	events(id)	int	-	-	-	-	�	-	�
original_id	reference_items(id)	int	-	-	-	-	�	-	�

collections

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	X	X	X	-	�	X	�
title	Varchar-255	varchar(255)	-	-	X	-	�	-	�
short_title	Varchar-255	varchar(255)	-	-	-	-	�	-	�
description	text	varchar(32,000)	-	-	-	-	�	-	�
collection_type-Id	collection_types(id)	int	-	-	X	-	�	X	�

contributors

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	X	X	X	-	�	X	�
sort_name	Varchar-255	varchar(255)	-	-	X	-	�	-	�
display_name	Varchar-255	varchar(255)	-	-	-	-	�	-	�
organisation	Bool	char(1)	-	-	-	-	�	-	�
discription	text	varchar(32,000)	-	-	-	-	�	-	�

names

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	X	X	X	-	�	X	�
givenname	Varchar-50	varchar(50)	-	-	-	-	�	-	�
familyname	Varchar-50	varchar(50)	-	-	-	-	�	-	�
articular	Varchar-50	varchar(50)	-	-	-	-	�	-	�
prefix	Varchar-50	varchar(50)	-	-	-	-	�	-	�
suffix	Varchar-50	varchar(50)	-	-	-	-	�	-	�
preffered	Bool	char(1)	-	-	-	-	1	-	�
language	Varchar-5	varchar(5)	-	-	-	-	�	-	�
valid	date	date	-	-	-	-	�	-	�
contributers_id	contributors(id)	int	-	-	-	-	�	-	�

events

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	X	X	X	-	�	X	�
event_type_id	event_types(id)	int	-	-	X	-	�	X	�
name	Varchar-255	varchar(255)	-	-	X	-	�	-	�
sponser	contributors(id)	int	-	-	-	-	�	-	�
begin_date	date	date	-	-	-	-	�	-	�
end_date	date	date	-	-	-	-	�	-	�
other_date	date	date	-	-	-	-	�	-	�

tags

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	X	-	X	-	�	X	�
name	Varchar-50	varchar(50)	-	-	X	-	�	-	�

feeds

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	X	X	X	-	�	X	�
url	Varchar-255	varchar(255)	-	-	X	-	�	-	�
title	Varchar-255	varchar(255)	-	-	X	-	�	-	�
link	Varchar-255	varchar(255)	-	-	-	-	�	-	�
data_feed	text	varchar(32,000)	-	-	-	-	�	-	�
data_feed_type	Varchar-50	varchar(50)	-	-	-	-	�	-	�
http_headers	text	varchar(32,000)	-	-	-	-	�	-	�
last_retrieved	date	date	-	-	-	-	�	-	�

roles

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	X	X	X	-	�	X	�
name	Varchar-50	varchar(50)	-	-	X	-	�	-	�

reference_types

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	X	X	X	-	�	X	�
name	Varchar-50	varchar(50)	-	-	X	-	�	-	�

collection_types

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	X	X	X	-	�	X	�
name	Varchar-50	varchar(50)	-	-	X	-	�	-	�

event_types

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	X	X	X	-	�	X	�
name	Varchar-50	varchar(50)	-	-	X	-	�	-	�

locators

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	X	X	X	-	�	X	�
value	Varchar-50	varchar(50)	-	-	X	-	�	-	�
locator_type_id	locator_type(id)	int	-	-	X	-	�	X	�
reference_item_id	reference_items(id)	int	-	-	-	-	�	X	�

locator_type

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	X	X	X	-	�	X	�
name	Varchar-50	varchar(50)	-	-	X	-	�	-	�

users

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	X	X	X	-	�	X	�
nick	Varchar-50	varchar(50)	-	-	X	-	�	-	�
password	Varchar-50	varchar(50)	-	-	-	-	�	-	�
modified	date	date	-	-	-	-	�	-	�
access	date	date	-	-	-	-	�	-	�

contributions

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	X	-	-	-	�	X	�
position	smallint	smallint	-	-	-	-	�	-	�
role_id	roles(id)	int	-	-	-	-	�	-	�
contributor_id	contributors(id)	int	-	-	-	-	�	-	�

identifiers

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	X	-	-	-	�	X	�
reference_item_id	reference_items(id)	int	-	-	-	-	�	X	�
content	Varchar-50	varchar(50)	-	-	-	-	�	-	�
identifier_type_id	identifier_type(id)	int	-	-	-	-	�	-	�

identifier_type

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	-	-	-	-	�	-	�
name	Varchar-50	varchar(50)	-	-	-	-	�	-	�

annotations

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	X	-	-	-	�	X	�
user_id	users(id)	int	-	-	-	-	�	-	�
content	text	varchar(32,000)	-	-	-	-	�	-	�

tagings

Field	Type	Sql type	PrKey	Unq	NotN	MUnq	Def	Idx1	DD Equiv
id	Serial	int	-	-	-	-	�	-	�
tagable_type	Varchar-50	varchar(50)	-	-	-	-	�	-	�
tags_id	tags(id)	int	-	-	-	-	�	-	�

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The ASF logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.