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 set.gif set.gif set.gif unset.gif   set.gif
title varchar(255) unset.gif unset.gif set.gif unset.gif   unset.gif
short_title varchar(255) unset.gif unset.gif unset.gif unset.gif   unset.gif
description varchar(32,000) unset.gif unset.gif unset.gif unset.gif   unset.gif
collection_type-Id int unset.gif unset.gif set.gif unset.gif   set.gif

Foreign Keys
Field Import On Update On Delete
collection_type-Idcollection_types(id)NO ACTIONNO ACTION