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