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
filmlist_view

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	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.

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)

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).

Schema

Field	Type	Notes
film_id	varchar
name_id	text	Name identifiers for director. Can be multiple pipe-separated values, but NOTE that these strings have leading and trailing pipes to allow "like" searches to work on these.
doc_count	int8	Number of documents associated with this film
filmtitle	varchar	Primary title
country	text	Can be multiple pipe-separated values.
filmyear	int4	Single 4-digit year. NOTE: Some films have multiple rows in this table because of multiple release years. In order to allow numeric search operations such as between and greater than, these were not generated as pipe-separated values.
director	text
filmlanguage	text
prodco	text
subject	text
genre	text
title	text

Notes

Example rows

table { }td

Unknown macro: { padding-top}

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
pfafilm31474	\|person4489\|	4	Shift	United States	1972	Ernie Gehr	English	(null)	City traffic	Experimental\|Short\|Bay Area avant-garde	Shift
pfafilm31474	\|person4489\|	4	Shift	United States	1973	Ernie Gehr	English	(null)	City traffic	Experimental\|Short\|Bay Area avant-garde	Shift
pfafilm31474	\|person4489\|	4	Shift	United States	1974	Ernie Gehr	English	(null)	City traffic	Experimental\|Short\|Bay Area avant-garde	Shift