array or not array? -
07-19-2007
, 04:04 PM
Hi all,
i'm a real noob in databasedesign, so i have some questions about it. In
case i want to make a booklist with two tables and the following fields:
owner_table has the fields ID, name, books
book_table has the fields ID, author, title, isbn
normally i would say, this is easy, just filling both tables with data
and linking them together maybe like owner_table.books as a foreign key
linked to book_table.isbn or book_table.ID.
In this way i will have many datasets in owner_table with the same entry
in 'name', depending on how much books this man (or women) has.
But what about an array? Can i use owner_table.isbn as an array-field?
And if this is viable, is it 'good' or 'bad'? And how an i link this
array-field to book_table, because the datatype of the array-field is
not any longer compatible with any field in book_table.
thank you, J. |