On Wed, Jul 6, 2016 at 7:57 AM, Max Rosenbaum <[email protected]> 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 <[email protected]> [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
[email protected]
https://lists.sourceforge.net/lists/listinfo/imdbpy-help
