SQL movie database description made by IMDBpy

Recently, I have been using the IMDBpy API to clear the IMDB dataset. This API has imdbpy2sql.py which can convert the IMDB movie dataset to SQL database. But I cannot find a description of this dataset. So I cannot understand the schema of this SQL database. There are too many tables in this database. Is there a way to find out?

I am strictly following this website for creating my database http://blog.secaserver.com/2013/08/importing-imdb-sample-data-set-mysql/ .

Thank you so much!

+3


source to share


1 answer


I doubt there are too many tables. There are many properties / relationships available.

I generated this imageonce while building pyIRDG . You can also take a look at this code for documentation of the available data. Here is the output of the comments: http://pastebin.com/zGnZ02w4

I also used MySQL Workbench to generate schema from DB.



There is also an article in the German blog c an ERM image.

not that I know, and of course our DB is not in any SF. :-) Anyway, you can easily look at the schema in the imdb / parser / sql / dbschema.py module or use some tool directly on the database. Source .



      

+10


source







All Articles