kirky_D
Members
-
Joined
-
Last visited
Reputation Activity
-
kirky_D reacted to Jay Gilford in 2 tables with 3 many to many relationshipsThe design is OK but imho can be improved
scrap those last three tables. they are all the same but with a different name. instead create a third table called contributor_type, with the structure
id, name
Then in that table you can have
1 Author
2 Editor
3 Translator
Then to link a book to a person, you need a table with the following structure (example call it person_book)
person_id, book_id, contributor_type_id
This gives you much more flexibility since to add a new contributor type you only need to create a new record in the contributor_type table not create an entirely new table
It also means that you only need to query one table to find out which people belong to a book
Simply using
SELECT * FROM person_book WHERE book_id = 5
will return all the people associated with the book
-
kirky_D reacted to Design Agency Leeds in Best practice for url structureHi, we've written a brief guide on best practices for url structure to aid SEO and usability. Hope it might prove useful for somebody:
Best practices for url structure
-
kirky_D got a reaction from asek in Website Portfolio FeedbackHi!
I really like the design. This is what I see, the contact button is not centered vertically correctly. Using newest chrome btw.
Also (not a design issue) check your portfolio page, under ctg systems. one of the sentences ends abruptly. "The client wanted a vertical..."
Good work!