Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.14

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 - - - - � - �

Apache Software Foundation

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

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