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