Banner ACVCarinianaOasisbrManifesto

Sistema para Construção de Bibliotecas Virtuais Temáticas (BVT)

Script-OAICat.sql — SQL code, 1Kb

Conteúdo do arquivo

--drop view set_list;
create view set_list as
select 'BVT-SET:001'::varchar as set_spec, 'Biblioteca Virtual'::varchar as set_name, 'IBICT - Instituto Brasileiro de Informa� em Ci�ia e Tecnologia'::varchar as set_description;

--drop view about_list;
create view about_list as
select id as about_ID, nome as about_value from assunto;

--drop view record_about_map;
create view record_about_map as
select 'BVT/'||id as local_identifier, assunto_id as about_ID from item_acervo;

--drop view record_set_map;
create view record_set_map as
select 'BVT/'||id as local_identifier, 'BVT-SET:001'::varchar as set_spec from item_acervo;

--drop view metadata_record;
create view metadata_record as
select 'BVT/'||id as local_identifier, 
	   nome as title,
	   autor as creator, 
	   area_conhecimento as subject, 
	   descricao as description, 
	   autor as publisher, 
	   autor as contributor, 
	   data as datecreated, 
	   tipo_arquivo as type, 
	   ''::varchar as format, 
	   ''::varchar as identifier, 
	   fonte as source, 
	   idioma as language, 
	   ''::varchar as relation, 
	   area_conhecimento as coverage, 
	   ''::varchar as rights, 
	   data as timestamp
from item_acervo;