Postgres data sources for CineFiles web sites

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

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

9/3/89 17:00

(null)

3

The abyss

review

2

Film Journal International

organization15066

Kevin Lally

2

English

1989 Sep

4

TRUE

FALSE

TRUE

FALSE

8/31/89 17:00

(null)

4

There is a tide

review

1

p. 61

Village Voice

organization494

Amy Taubin

2

English

1989 Aug 15

4

FALSE

TRUE

FALSE

8/14/89 17:00

http://www.villagevoice.com/

(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

TRUE

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

8/5/89 17:00

(null)

Special effects

Industrial Light and Magic (Studio)