Hi, I just had a look over the PDF file. So a few comments following. Are going to use integers, or enum values for eg. the state columns. I think that using enums may make the PHP code more readable, as you can work with strings in the application then. Some comments about the tables: Artwork: A second field for the date, eg. last_updated, is probably needed. So that both the date of the first release and the last updated time can be stored. Collection: I wonder what the need for this table is? Wouldn't a collection be basically a general artwork with type "collection", and the artwork_collection lookup table to get the components? FAQ: There is probably a need for a status flag. Benjamin
Attachment:
signature.asc
Description: This is a digitally signed message part