Page Comparison

New data sources are available for the web sites to display information managed in the CineFiles CollectionSpace system.  Their design is based on the requirements for the [IST-developed site|http://www.mip.berkeley.edu/cinefiles/], but they have been refactored extensively.  These data sources are described below.  A separate document will describe how these data sources are refreshed (TBD).

{toc:maxLevel=2}

h2. doclist_view

doclist_view is a table despite the name.  The name was retained in order to simplify refactoring the IST developed CineFiles web site.  This is the primary source for searching documents (keyword search and field-based search).


h3. Schema

| {color:#000000}{*}Field{*}{color} | {color:#000000}{*}Type{*}{color} | {color:#000000}{*}Notes{*}{color} |
| doc_id | int8 | |
| doctitle | varchar | |
| doctype | text | |
| pages | int8 | |
| pg_info | varchar | |
| source | text | usually the publisher of the document \\ |
| src_id | text | source identifier used behind the scenes \\ |
| author | text | Can be multiple pipe-separated values. |
| name_id | int4 | always '2' because this short identifier is no longer used. \\ |
| doclanguage | text | Can be multiple pipe-separated values. \\ |
| pubdate | varchar | |
| code | int4 | Access code for this document: \\
0 = PFA Staff Only \\
null = PFA Staff Only \\
1 = In House Only \\
2 = Campus (UCB) \\
3 = Education (.edu) \\
4 = World |
| cast_cr | bool | |
| tech_cr | bool | |
| bx_info | bool | |
| filmog | bool | |
| dist_co | bool | |
| prod_co | bool | |
| costinfo | bool | |
| illust | bool | |
| biblio | bool | |
| docurl | varchar | URL provided for direct access or further information \\ |
| pubdatescalar | timestamp | publication date \\ |
| srcurl | varchar | |
| docsubject | text | Subject of document. Can be multiple pipe-separated values. |
| docnamesubject | text | Named subjects (person or organization) in document. Can be multiple pipe-separated values. |


h3. Notes


h3. Example rows

| 2 | The abyss | review | 2 | | New Yorker, The | organization484 | Terrence Rafferty | 2 | English | 1989 Sep 04 | 0 | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | | 9/3/89 17:00 | (null) | (null) | (null) |
| 3 | The abyss | review | 2 | | Film Journal International | organization15066 | Kevin Lally | 2 | English | 1989 Sep | 4 | TRUE | TRUE | FALSE | FALSE | FALSE | TRUE | FALSE | FALSE | FALSE | | 8/31/89 17:00 | (null) | (null) | (null) |
| 4 | There is a tide | review | 1 | p. 61 | Village Voice | organization494 | Amy Taubin | 2 | English | 1989 Aug 15 | 4 | FALSE | FALSE | FALSE | FALSE | TRUE | TRUE | TRUE | FALSE | FALSE | | 8/14/89 17:00 | [http://www.villagevoice.com/] | (null) | (null) |
| 12 | The abyss: a foray into deep waters | review | 2 | p. H-15 | New York Times | organization482 | Aljean Harmetz | 2 | English | 1989 Aug 06 | 0 | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE | FALSE | FALSE | | 8/5/89 17:00 | (null) | Underwater cinematography | James Cameron\|Ed Harris |
| 13 | Playing with water | review | 1 | p. H-16 | New York Times | organization482 | David A. Kaplan | 2 | English | 1989 Aug 06 | 0 | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | FALSE | | 8/5/89 17:00 | (null) | Special effects | Industrial Light and Magic (Studio) |

h2. filmlist_view

filmlist_view is a table despite the name.  The name was retained in order  to simplify refactoring the IST developed CineFiles web site.  This is  the primary source for searching films (keyword search and  field-based search).

h3. Schema

| *Field* | *Type* | *Notes* |
| film_id | varchar | |
| name_id | text | |
| doc_count | int8 | |
| filmtitle | varchar | |
| country | text | |
| filmyear | int4 | |
| director | text | |
| filmlanguage | text | |
| prodco | text | |
| subject | text | |
| genre | text | |
| title | text | |

h3. Notes


h3. Example rows

table {  }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { font-weight: 700; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(217, 217, 217); }
| *Field* | *Type* | *Notes* |
| film_id | varchar | |
| name_id | text | |
| doc_count | int8 | |
| filmtitle | varchar | |
| country | text | |
| filmyear | int4 | |
| director | text | |
| filmlanguage | text | |
| prodco | text | |
| subject | text | |
| genre | text | |
| title | text | |

h3. Notes


h3. Example rows
| pfafilm10 | \|person12\| | 22 | Yukinojo henge (An actor's revenge) | Japan | 1963 | Kon Ichikawa | Japanese | Daiei Motion Picture Co. Ltd. | Actors \-\- Japan \-\- Drama\|Kabuki \-\-   Drama\|Revenge \-\- Drama\|Melodrama | Melodrama | Yukinojo henge\|An actor's revenge\|Yukinojo   Hengei\|The Revenge of Yukinojo\|The Avenging ghost of Yukinojo\|Yukinojo Henge   (1963 : Kon Ichikawa)\|An Actor's revenge (1963 : Kon Ichikawa) |
| pfafilm100 | \|person391\| | 1 | World gone wild | (null) | (null) | Lee H. Katzin | English | (null) | (null) | Drama | World gone wild |
| pfafilm1000 | \|person8886\|person8498\| | 3 | Ama | Ghana\|Great Britain | 1991 | Kwesi Owusu\|Kwate Nee-Owoo | English | Channel Four Films\|Efire Tete Films | Cultural conflict \-\- Great Britain \-\- Drama\|Ghanaians \-\- Great Britain \-\-   London \-\- Drama\|Africans \-\- Great Britain \-\- London \-\- Drama\|Girls \-\- Great   Britain \-\- London \-\- Drama\|Ghana \-\- Religion \-\- Drama | Drama | Ama |
| pfafilm10018 | \|person383\| | 17 | Insignificance | Great Britain | 1985 | Nicolas Roeg | English | Recorded Picture Company\|Zenith Entertainment Ltd. | Einstein, Albert, 1879-1955 \-\- Drama\|Monroe, Marilyn, 1926-1962 \-\-   Drama\|DiMaggio, Joe, 1914-1999 \-\- Drama\|McCarthy, Joseph, 1908-1957 \-\-   Drama\|Johnson, Terry, 1949\- Insignificance \-\- Film and video adaptations | Adaptation\|Comedy\|Drama\|Feature | Insignificance |
| pfafilm1002 | \|person3849\| | 1 | Ambar (Amber) | Mexico | 1994 | Luis Estrada | Spanish | Imcine\|Bandidos Films | Adventure and adventurers \-\- Drama\|Amber \-\- Drama | Drama | Ambar\|Amber |