mysql - Design a tables layouts for a web application : Hi everybody and sorry for my english. 
Let's say for example that I have to organize these informations: books, books editions and colors of every page of each edition (I know it sounds stupid but it's for the example).

Let's assume that a book can have only one edition, and that since the application is written in PHP, every table will have its set of functions to read and write on them, and I'd like to keep it simple if possible. I can't decide if it's best to do:

    **Books**
    bookid
    author

    **Editions**
    editionid
    bookid
    title
    publisher
    isbn

    **PagesColors**
    editionid
    page
    color

or trying to simplify in:

    **Books**
    bookid
    bookidreference
    author
    title
    publisher
    isbn

    **PagesColors**
    bookid
    page
    color

and records like this:

    1, 0, "Jane Austen", null, null, null
    2, 1, null, "Emma", "Books Enterprise", 12231231213
    3, 1, null, "Emma in Italian", "Jane Austen Italian Editions", 45345354334

and so on. Thank you.