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 set.gif unset.gif set.gif unset.gif   set.gif
reference_type_id int unset.gif unset.gif set.gif unset.gif   set.gif
title varchar(255) unset.gif unset.gif set.gif unset.gif   unset.gif
year date unset.gif unset.gif unset.gif unset.gif   unset.gif
locators_id int unset.gif unset.gif unset.gif unset.gif   set.gif
description varchar(32,000) unset.gif unset.gif unset.gif unset.gif   unset.gif
collection_id int unset.gif unset.gif unset.gif unset.gif   unset.gif
container_id smallint unset.gif unset.gif unset.gif unset.gif   unset.gif
abstract varchar(32,000) unset.gif unset.gif unset.gif unset.gif   unset.gif
event_id int unset.gif unset.gif unset.gif unset.gif   unset.gif
original_id int unset.gif unset.gif unset.gif unset.gif   unset.gif

Foreign Keys
Field Import On Update On Delete
reference_type_idreference_types(id)NO ACTIONNO ACTION
locators_idlocators(id)NO ACTIONNO ACTION
collection_idcollections(id)NO ACTIONNO ACTION
event_idevents(id)NO ACTIONNO ACTION
original_idreference_items(id)NO ACTIONNO ACTION