Summary File for Database : BiblioDB (Build 33)
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 |
- |
- |
- |
- |
|
- |
|