Having multiple refs in an intersection table I have two tables, BOOK and JOURNAL.  I want to store their authors in an intersection table called AUTHORS.  Is it acceptable practice to have mulitple reference id columns (kind of FK's I think) to other tables i.e. BOOK and JOURNAL?  This is to save having separate author tables for Books and Journals.
So, AUTHORS would look like:




ID
BOOK_ID
JOURNAL_ID
NAME




0
54
212
A.R Smith


1
598
NULL
J.R. Hartley
This is a possible design based on Joel Brown's correct answer (+1).  The WorkIds could come from the same sequence.

Author Table



╔══════════╦═══════════╦══════════╗
║ AuthorID ║ FirstName ║ LastName ║
╠══════════╬═══════════╬══════════╣
║        0 ║ A.R       ║ Smith    ║
║        1 ║ J.R.      ║ Hartley  ║
╚══════════╩═══════════╩══════════╝


AuthorWorks Table

╔══════════╦════════╗
║ AuthorId ║ WorkId ║
╠══════════╬════════╣
║        0 ║      1 ║
║        0 ║      2 ║
║        1 ║      3 ║
║        0 ║      4 ║
╚══════════╩════════╝


Book Table

╔════════╦══════════╗
║ WorkId ║  Title   ║
╠════════╬══════════╣
║      1 ║ asdf     ║
║      3 ║ jkl      ║
║      4 ║ zxcvzxcv ║
╚════════╩══════════╝


Journal Table

╔════════╦══════════╗
║ WorkId ║  Title   ║
╠════════╬══════════╣
║      2 ║ dfghdfgh ║
╚════════╩══════════╝