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
table { }td
.xl63
.xl64
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 |
|