Difference between revisions of "Dvdlookup.org"
From Fernseher
Jump to navigationJump to search
(New page: [http://www.dvdlookup.org] So there ya go. Essentially we will need to work on the database table structures, apis for accessing the database, how we are going to index the database, and...) |
|||
| Line 1: | Line 1: | ||
[http://www.dvdlookup.org] | [http://www.dvdlookup.org www.dvdlookup.org] | ||
So there ya go. Essentially we will need to work on the database table structures, apis for accessing the database, how we are going to index the database, and website stuff (web interface, blog for news, google ads, wiki for development, etc.) | So there ya go. Essentially we will need to work on the database table structures, apis for accessing the database, how we are going to index the database, and website stuff (web interface, blog for news, google ads, wiki for development, etc.) | ||
Some potential tables and what they might contain. Keep in mind that although these tables are complex, hopefully the API would make things much simpler for the users. Alot of the pain here is trying to keep the version stuff generic, to keep our nouns seperated, and to avoid comma seperated lists of things in our records :-) | Some potential tables and what they might contain. Keep in mind that although these tables are complex, hopefully the API would make things much simpler for the users. Alot of the pain here is trying to keep the version stuff generic, to keep our nouns seperated from each other and from our linkages, and to avoid comma seperated lists of things in our records :-) | ||
discs (physical medium) | ===discs=== (physical medium) | ||
* indexed by md5 sum of IFO files on disk | * indexed by md5 sum of IFO files on disk | ||
* version | * version | ||
| Line 13: | Line 13: | ||
* disc format | * disc format | ||
products (Something that can be purchased) | ===products=== (Something that can be purchased) | ||
* Include information on the extras on the disk | * Include information on the extras on the disk | ||
* when the product was published | * when the product was published | ||
| Line 20: | Line 20: | ||
* run length. (is this where this logically goes?) | * run length. (is this where this logically goes?) | ||
works (a movie or episode. A complete "thought".) | ===works=== (a movie or episode. A complete "thought".) | ||
* indexed by unique id? | * indexed by unique id? | ||
* real movie title | * real movie title | ||
| Line 27: | Line 27: | ||
* version | * version | ||
persons | ===persons=== | ||
* an opaque unique id for each person, | * an opaque unique id for each person, | ||
* the person's name | * the person's name | ||
| Line 33: | Line 33: | ||
* person's DOB | * person's DOB | ||
* person's DOD | * person's DOD | ||
* version | |||
plots | ===plots=== | ||
* id | * id | ||
* version | * version | ||
| Line 42: | Line 42: | ||
* product id to link to (if specific to the product instead of the work. would be weird for a plot, but possible) | * product id to link to (if specific to the product instead of the work. would be weird for a plot, but possible) | ||
reviews | ===reviews=== | ||
* id | * id | ||
* version | * version | ||
| Line 49: | Line 49: | ||
* product id to link to (if specific to the product instead of the work) | * product id to link to (if specific to the product instead of the work) | ||
discproduct (maps discs to products they are bought in. could be multiple discs in a product. Also could theoretically have a disc that is purchasable in multiple products) | ===discproduct=== (maps discs to products they are bought in. could be multiple discs in a product. Also could theoretically have a disc that is purchasable in multiple products) | ||
* disc id | * disc id | ||
* product id | * product id | ||
* disc number in the product | * disc number in the product | ||
productwork (maps products to works they represent. could be multiple products that represent a work in different ways (extended version, directors cut, etc). could be multiple works that a product contains (for double features, box sets, etc.) | ===productwork=== (maps products to works they represent. could be multiple products that represent a work in different ways (extended version, directors cut, etc). could be multiple works that a product contains (for double features, box sets, etc.) | ||
* product id | * product id | ||
* work id | * work id | ||
personwork (maps persons to works that they contributed to) | ===personwork=== (maps persons to works that they contributed to) | ||
* person id | * person id | ||
* work id | * work id | ||
* role | * role | ||
Revision as of 16:37, 25 February 2008
So there ya go. Essentially we will need to work on the database table structures, apis for accessing the database, how we are going to index the database, and website stuff (web interface, blog for news, google ads, wiki for development, etc.)
Some potential tables and what they might contain. Keep in mind that although these tables are complex, hopefully the API would make things much simpler for the users. Alot of the pain here is trying to keep the version stuff generic, to keep our nouns seperated from each other and from our linkages, and to avoid comma seperated lists of things in our records :-)
===discs=== (physical medium)
- indexed by md5 sum of IFO files on disk
- version
- volume id
- directx id
- timestamp from volume set id?
- disc format
===products=== (Something that can be purchased)
- Include information on the extras on the disk
- when the product was published
- version
- what makes this product different from others? (extended cut, etc)
- run length. (is this where this logically goes?)
===works=== (a movie or episode. A complete "thought".)
- indexed by unique id?
- real movie title
- initial release year
- production company
- version
persons
- an opaque unique id for each person,
- the person's name
- possible the person's nationality
- person's DOB
- person's DOD
- version
plots
- id
- version
- plot blob
- work id to link to
- product id to link to (if specific to the product instead of the work. would be weird for a plot, but possible)
reviews
- id
- version
- review blob
- work id to link to
- product id to link to (if specific to the product instead of the work)
===discproduct=== (maps discs to products they are bought in. could be multiple discs in a product. Also could theoretically have a disc that is purchasable in multiple products)
- disc id
- product id
- disc number in the product
===productwork=== (maps products to works they represent. could be multiple products that represent a work in different ways (extended version, directors cut, etc). could be multiple works that a product contains (for double features, box sets, etc.)
- product id
- work id
===personwork=== (maps persons to works that they contributed to)
- person id
- work id
- role
