...
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
...
...
...
,
...
but
...
they
...
have
...
been
...
refactored
...
extensively.
...
These
...
data
...
sources
...
are
...
described
...
below.
...
A
...
separate
...
document
...
will
...
describe
...
how
...
these
...
data
...
sources
...
are
...
refreshed
...
(TBD).
...
| Table of Contents |
|---|
...
|
...
|
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
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) |