Description of the SQL movie databse made by IMDBpy
Recently, I am using IMDBpy API to scrape the IMDB dataset. In this API, there is a imdbpy2sql.py which could convert IMDB movie dataset to a SQL database. But I can not find any description of this dataset. So I can not understand the schema of this SQL database. There are too many tables in this database. Is there any way to know that?
I strictly follow this website to build my database http://blog.secaserver.com/2013/08/importing-imdb-sample-data-set-mysql/.
Thanks so much!!
I doubt that there are too many tables. There are a lot properties/relationships available.
I generated 
once while creating pyIRDG. You can have a look at that code too for documentation on the available data. Here is the output of the comments: http://pastebin.com/zGnZ02w4
I've also used MySQL Workbench to generate a schema from the db.
There is also this German blog article with 
.
not that I'm aware of, and for sure our db is not in any NF. :-) Anyway, you can easily look at the scheme in the imdb/parser/sql/dbschema.py module or using some tool directly on the database. Source.
- System.NotSupportedException: Character set 'utf8mb3' is not supported by .Net Framework
- Enabling MySQL general query log with JDBC
- Join two tables where one table name is inside the other table
- Unable to make a remote api call to flask app(for MySQL connection) inside my apache server
- How can I set a numeric wildcard in MySQL?
- Your password does not satisfy the current policy requirements
- Weighted hierarchical cumulative sum
- MySql views performance
- Are MySql Views Dynamic and Efficient?
- Storing 2 same id of post table with different language into database
- Using multiple tables for lookup in MySQL
- mysql change innodb_large_prefix
- findAll() in Sequelize doesn't find a row created inside a transaction
- Unable to connect from MySQL Workbench to AWS RDS instance
- Spring Boot JPA MySQL : Failed to determine a suitable driver class
- How to count the number of groups of events that are more than 20 minutes from each other?
- How to properly save a complex object using EF Core
- Select query in MySQL
- Same table union from different databases
- How to generate a UUIDv4 in MySQL?
- Whats wrong with my query with CASE statement
- Select All Events with Event->Schedule->Date between start and end dates in CakePHP
- Insert custom date into mysql timestamp field
- Filtering mysql data using nested json_table returns "Incorrect arguments"
- How to fix "Error executing DDL "alter table events drop foreign key FKg0mkvgsqn8584qoql6a2rxheq" via JDBC Statement"
- Directus is not connecting with mysql over SSH server
- Inserting and selecting UUIDs as binary(16)
- How to fix Authentication method caching_sha2_password not supported by any of the available plugins in Visual Studio
- exception emyxerror in module mysqlquerybrowser exe at 00111E52
- Efficiently Querying Nearby Warehouses Based on Latitude and Longitude Within a Specified Radius