Table : collection_types

See Also:

collections

Field Summary
Name Type Description
id Serial  
name Varchar-50  

Sql Summary
Name Type PrKey Unq NotN MUnq Def Idx1
id int set.gif set.gif set.gif unset.gif   set.gif
name varchar(50) unset.gif unset.gif set.gif unset.gif   unset.gif

Sql Commands
INSERT INTO collection_types VALUES (1, 'Collection');
INSERT INTO collection_types VALUES (2, 'Periodical');
INSERT INTO collection_types VALUES (3, 'Journal');
INSERT INTO collection_types VALUES (4, 'Series');