INDEX	REVISIONS		OVERVIEW	FIELD SUMMARY
DATATYPES			SQL SUMMARY	TRIGGERS

---

Table : reference_items

Reference Items are citable content, and include both parts (articles) and monographs (books)

See Also:

reference_items
locators
identifiers

Field Summary
Name	Type	Description
id	Serial
reference_type_id	reference_types(id)
title	Varchar-255
year	date
locators_id	locators(id)
description	text
collection_id	collections(id)
container_id	smallint
abstract	text
event_id	events(id)
original_id	reference_items(id)

Sql Summary
Name	Type	PrKey	Unq	NotN	MUnq	Def	Idx1
id	int
reference_type_id	int
title	varchar(255)
year	date
locators_id	int
description	varchar(32,000)
collection_id	int
container_id	smallint
abstract	varchar(32,000)
event_id	int
original_id	int

Foreign Keys
Field	Import	On Update	On Delete
reference_type_id	reference_types(id)	NO ACTION	NO ACTION
locators_id	locators(id)	NO ACTION	NO ACTION
collection_id	collections(id)	NO ACTION	NO ACTION
event_id	events(id)	NO ACTION	NO ACTION
original_id	reference_items(id)	NO ACTION	NO ACTION

---

INDEX	REVISIONS		OVERVIEW	FIELD SUMMARY
DATATYPES			SQL SUMMARY	TRIGGERS