...
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). It is also a primary source for the film citation produced by the function film_citationdetail_summary.
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. E.g., see pfafilm31474 below. |
director | text | Can be multiple pipe-separated values. |
filmlanguage | text | Can be multiple pipe-separated values. |
prodco | text | Can be multiple pipe-separated values. |
subject | text | Can be multiple pipe-separated values. |
genre | text | Can be multiple pipe-separated values. |
title | text | Primary and alternate titles. Can be multiple pipe-separated values. |
...
filmdocs is a many-to-many table showing the relationships between films and documents. One film can be tied to many documents. One document can be tied to many films. (Used in DocList.java to populate temp tables for searching.) It is also a primary source for the film citation produced by the function film_detail_summary and for the documentation citation produced by the function doc_detail_summary.
Schema
Field | Type | Notes |
film_id | varchar |
|
doc_id | int8 |
|
entered | unknown | deprecated; might get deleted |
modified | unknown | deprecated; might get deleted |
entered_by | unknown | deprecated; might get deleted |
verified_by | unknown | deprecated; might get deleted |
note | unknown | deprecated; might get deleted |
Notes
NOTE: Five fields (entered through note) might be deleted once we confirm they are not being used.
Example rows
pfafilm1000 | 4177 | not used | not used | not used | not used | not used |
pfafilm1000 | 4178 | not used | not used | not used | not used | not used |
pfafilm1000 | 4179 | not used | not used | not used | not used | not used |
pfafilm26266 | 10627 | not used | not used | not used | not used | not used |
pfafilm26268 | 10627 | not used | not used | not used | not used | not used |
alldoctitles_view
Used in DocList.java to populate temp tables for searching
allfilmtitles_view
Used in DocList.java to populate temp tables for searching.