vendredi 26 décembre 2014

Storing URLs in a database


I am thinking about storing URL's in my database, but I am not sure whether the way I use is an efficient way to do things or not.



Table name : url
url_id (Primary Key & Auto Increment)
url_value (Varchar 500)

Table name : tvseries
tvseries_id
tvseries_name
url_id (Foreign Key from url table)

Table name : movie
movie_id
movie_name
url_id (Foreign Key from url table)

Table name : documentary
documentary_id
documentary_name
url_id (Foreign Key from url table)


P.S. : I didn't ask my question elsewhere like CodeReview or StackOverflow, because my question doesn't contain any code.





Aucun commentaire:

Enregistrer un commentaire