...
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. |
| prodco_id | text | Added 7/31/14: Can be multiple pipe-separated values. |
| updatedat | timestamp | Date record was last updated |
Notes
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.
...