INDEX	REVISIONS		OVERVIEW	FIELD SUMMARY
DATATYPES			SQL SUMMARY	TRIGGERS

---

Table : collections

Collections are non-citable related items such as periodicals and archival collections

See Also:

reference_items

Field Summary
Name	Type	Description
id	Serial
title	Varchar-255
short_title	Varchar-255
description	text
collection_type-Id	collection_types(id)

Sql Summary
Name	Type	PrKey	Unq	NotN	MUnq	Def	Idx1
id	int
title	varchar(255)
short_title	varchar(255)
description	varchar(32,000)
collection_type-Id	int

Foreign Keys
Field	Import	On Update	On Delete
collection_type-Id	collection_types(id)	NO ACTION	NO ACTION

---

INDEX	REVISIONS		OVERVIEW	FIELD SUMMARY
DATATYPES			SQL SUMMARY	TRIGGERS