On Wed, Jul 6, 2016 at 7:57 AM, Max Rosenbaum <m...@rtechservices.io> wrote: > > I am having a play with the imdbpy2sql script. Having a look at the UML > diagram of the DB, there are some tables that seem redundant as well as > interesting naming schemes. In particular, the tables prefixed with "aka_". > What is this shorthand for? A googling around hasn't revealed anything :(
Hi, AKA is an abbreviation of "also known as", for alternative names of persons or movie titles. > Also, in the upper right hand corner of the diagram, the aka_title and > link_type tables have no relations, should aka_title relate to the title > table as movie_id:id ? Yes, exactly. > and if link_type table needs a relation what table should it relate to? That's used to identify the kind of link between two movies ("remake of", "spoofed in", ...) The relation should be between movie_link.link_type_id : link_type.id It's strange that these two relations are missing, since they are both specified in their imdb.parser.sql.dbschema entries. Thanks for your analysis! -- Davide Alberani <davide.alber...@gmail.com> [PGP KeyID: 0x465BFD47] http://www.mimante.net/ ------------------------------------------------------------------------------ What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports.http://sdm.link/zohodev2dev _______________________________________________ Imdbpy-help mailing list Imdbpy-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-help