| Wiki Markup |
|---|
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). |
...
Schema
Field | Type | Notes |
doc_id | int8 |
|
doctitle | varchar |
|
doctype | text |
|
pages | int8 |
|
pg_info | varchar |
|
source | text |
|
src_id | text |
|
author | text |
|
name_id | int4 |
|
doclanguage | text |
|
pubdate | varchar |
|
code | int4 |
|
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 |
|
pubdatescalar | timestamp |
|
srcurl | varchar |
|
docsubject | text |
|
docnamesubject | text |
|
Notes
...
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 | |
| src_id | text | |
| author | text | |
| name_id | int4 | |
| doclanguage | text | |
| pubdate | varchar | |
| code | int4 | |
| 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 | |
| pubdatescalar | timestamp | |
| srcurl | varchar | |
| docsubject | text | |
| docnamesubject | 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 { }
| 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) |
| 5 | Twenty thousand groans under the sea | review | 1 | p. 25 | East Bay Express | organization474 | Kelly Vance | 2 | English | 1989 Aug 11 | 4 | TRUE | FALSE | FALSE | FALSE | FALSE | FALSE | TRUE | FALSE | FALSE | | 8/10/89 17:00 | (null) | (null) | (null) | |