Advertisement
Guest User

Untitled

a guest
Nov 26th, 2014
158
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1.  
  2. CREATE TABLE TabelaFato
  3. (
  4. codigolivro numeric(10,0) NOT NULL,
  5. codigoautor numeric(10,0) NOT NULL,
  6. codigoedicao numeric(10,0) NOT NULL,
  7. numero character(1) NOT NULL,
  8. ano integer NOT NULL,
  9. PRIMARY KEY (codigolivro, codigoautor, codigoedicao, numero, ano),
  10. FOREIGN KEY (codigolivro) REFERENCES livros (codigo),
  11. FOREIGN KEY (codigoautor) REFERENCES autor (codigo),
  12. FOREIGN KEY (codigoedicao, numero) REFERENCES edicao (codigo, numero)
  13. FOREIGN KEY (ano) REFERENCES edicao (ano)
  14. )
  15. drop table TabelaFato
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement