-- Database: postgres CREATE DATABASE postgres WITH OWNER = postgres ENCODING = 'SQL_ASCII' TABLESPACE = pg_default; -- Schema: "public" CREATE SCHEMA public AUTHORIZATION postgres; GRANT ALL ON SCHEMA public TO postgres; GRANT ALL ON SCHEMA public TO public; COMMENT ON SCHEMA public IS 'Standard public schema'; -- Table: documentos CREATE TABLE documentos ( doc_nome character varying(30) NOT NULL, doc_autor1 character varying(60) NOT NULL, doc_autor2 character varying(60) NOT NULL, doc_local_apli character varying(50) NOT NULL, doc_grupo character varying(16) NOT NULL, doc_resumo character varying(300) NOT NULL, doc_upload character varying(100) NOT NULL, doc_nome_antigo character varying(100) NOT NULL, CONSTRAINT upload UNIQUE (doc_upload) ) WITHOUT OIDS; ALTER TABLE documentos OWNER TO postgres; -- Table: membros CREATE TABLE membros ( membro_nome character varying(30) NOT NULL, membro_sobrenome character varying(30) NOT NULL, membro_email character varying(40) NOT NULL, membro_login character varying(30) NOT NULL, membro_password character varying(30) NOT NULL, CONSTRAINT pk_membros PRIMARY KEY (membro_nome, membro_sobrenome, membro_email, membro_login, membro_password) ) WITHOUT OIDS; ALTER TABLE membros OWNER TO postgres; -- Table: palavras_chaves CREATE TABLE palavras_chaves ( pc_palavra_chave character varying(30) NOT NULL, pc_doc_upload character varying(100) NOT NULL, CONSTRAINT pk_palavras_chaves PRIMARY KEY (pc_palavra_chave, pc_doc_upload), CONSTRAINT fk_pal_chave FOREIGN KEY (pc_palavra_chave) REFERENCES rep_palavras_chaves (rep_palavra_chave) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT fk_upload FOREIGN KEY (pc_doc_upload) REFERENCES documentos (doc_upload) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION ) WITHOUT OIDS; ALTER TABLE palavras_chaves OWNER TO postgres;
-- Index: fki_pal_chave CREATE INDEX fki_pal_chave ON palavras_chaves USING btree (pc_palavra_chave); -- Index: fki_upload CREATE INDEX fki_upload ON palavras_chaves USING btree (pc_doc_upload); -- Table: rep_palavras_chaves -- DROP TABLE rep_palavras_chaves; CREATE TABLE rep_palavras_chaves ( rep_palavra_chave character varying(30) NOT NULL, CONSTRAINT pk_rep_palavras_chaves PRIMARY KEY (rep_palavra_chave), CONSTRAINT pal_chave UNIQUE (rep_palavra_chave) ) WITHOUT OIDS; ALTER TABLE rep_palavras_chaves OWNER TO postgres;