Audio-Visual Prototyping Project

DigiProv Data Dictionary

# Table Name Field Name Field Definition Data Type Enumerated Values
1 configfile configfile_key Primary Key of the CONFIGFILE table Primary Key NONE
2 configfile description Summary of the contents of the file. SBCS(2000) NONE
3 configfile label Name of the file. SBCS(255) NONE
4 configfile location Location of the file, e.g., //www.loc.gov/aggname/filename.ext. SBCS(255) NONE
5 configfile location_type The type of location of the config file, e.g., URN, URL, etc. Enumerated Type DOI, Handle, Other, PURL, URL, URN
6 instance datetime Date and time at which the digital production task was performed. When output to METS (XML), this will be expressed using ISO 8601 syntax; see http://www.w3.org/TR/NOTE-datetime. DateTime NONE
7 instance individual Name, or title, or identifier of the individual who executed the process or task, e.g., Jane Smith or recording engineer, or Emp # 1234 etc. SBCS(255) NONE
8 instance instance_key Primary Key of the INSTANCE table Primary Key NONE
9 instance note Information about the tasks not contained in the descriptions. SBCS(2000) NONE
10 instance organization Organization responsible for executing the process, e.g., M/B/RS recording lab. SBCS(255) NONE
11 instance production_id Tracking number related to digital production, e.g., production batch number or LWO (the job numbers used by the LC recording laboratory). SBCS(255) NONE
12 instance structmap_key Foreign Key pointer to the STRUCTMAP table Foreign Key NONE
13 instance task_key Foreign Key pointer to the TASK table Foreign Key NONE
14 instance timestamp Date and time the entry was made. DateTime NONE
15 process alias A nick name for the process described in the process_description to easily identify the process. SBCS(255) NONE
16 process creator Name, or title, or identifier of the individual who defined the process, e.g., Jane Smith or recording engineer, or Emp # 1234 etc. SBCS(255) NONE
17 process datetime Date and time at which the digital production process was defined. When output to METS (XML), this will be expressed using ISO 8601 syntax; see http://www.w3.org/TR/NOTE-datetime. DateTime NONE
18 process description Summary description of the process used to prepare, describe, digitize, migrate, or normalize the content. SBCS(2000) NONE
19 process label Formal name for the process described in the process_description. SBCS(255) NONE
20 process organization Organization responsible for defining the process, e.g., M/B/RS recording lab. SBCS(255) NONE
21 process process_type Formal name for the purpose of the overall process. Enumerated Type Conservation Treatment, Digitize Audio, Digitize Video, Process Text, Scan Image
22 settings configfile_key Foreign Key pointer to the CONFIGFILE table Foreign Key NONE
23 settings description Description of the setting. SBCS(2000) NONE
24 settings label Label for this setting. SBCS(255) NONE
25 settings settings_key Primary Key of the SETTINGS table Primary Key NONE
26 settings tool_key Foreign Key pointer to the TOOL table Foreign Key NONE
27 settings value Value of the setting. SBCS(255) NONE
28 task alias A nick name for the task described in the task_description to easily identify the task. SBCS(255) NONE
29 task description A narrative description of the task. SBCS(2000) NONE
30 task label Formal name for the task described in the task_description. SBCS(255) NONE
31 task process_key Foreign Key which is a pointer to the PROCESS table Foreign Key NONE
32 task sequence Sequential position of this task among its predecessors and successors. Large signed number NONE
33 task task_key Primary Key of the TASK table Primary Key NONE
34 tool description Description of the tool. SBCS(2000) NONE
35 tool label Information displayed to the user identifying the tool. SBCS(255) NONE
36 tool make Name of the manufacturer of the device, e.g., Phase I Camera Company. SBCS(255) NONE
37 tool note Any additional information not contained in the description. SBCS(2000) NONE
38 tool sequence Sequential position of this tool among its predecessors and successors. Large signed number NONE
39 tool serial_number The serial number of the device, e.g., CR387493. SBCS(255) NONE
40 tool task_key Foreign Key pointer to the TASK table Foreign Key NONE
41 tool tool_key Primary Key of the TOOL table Primary Key NONE
42 tool tool_type The common name for the tool. Suggested Enumerated Type NONE
43 tool version The version of the tool. SBCS(255) NONE
2/25/03
Library of Congress
Comments: AV Prototype Coordinator ([email protected])
Legal | External Link Disclaimer
( August 31, 2010 )