Key – Andrew V Gonzales

All database attributes are listed below.
Each can be queried using its provided key.

ID

Definition: A unique ID assigned to every record in the database.
Key: id
Type: Text

Example: Query a specific record.
[id]=110-001-009-033

Volume

Definition: A collection of entries that share a common, physical enclosure.
Key: volume
Type: Unsigned Integer

Example: Query contents of all first volumes.
[volume]=1|1

Example: Query contents of all volumes numbered one through four.
[volume]=1|4

Entry

Definition: A collection of verses that share a common, distinguishing trait.
Key: entry
Type: Unsigned Integer

Example: Query contents of all first entries.
[entry]=1|1

Example: Query contents of all entries numbered four through seven.
[entry]=4|7

Verse

Definition: Most discrete unit of media that is both practical and reasonably able to be processed.
Key: verse
Type: Unsigned Integer

Example: Query contents of all first verses.
[verse]=1|1

Example: Query contents of all verses numbered thirteen through thirty-seven.
[verse]=13|37

Date

Definition: The full month, day, and year a record was created.
Key: date
Type: Date

Example: Query records created on June 04, 2013.
[date]=06/04/2013|06/04/2013

Example: Query records created from June 06 – 09, 2013.
[date]=06/06/2013|06/09/2013

Day of the Week

Definition: The day of the week a record was created.
Key: dayofweek
Type: Text

Example: Query records created on a Monday.
[dayofweek]=monday

Example: Query records created during the weekend.
[dayofweek]=saturday|sunday

Month

Definition: The month of a year a record was created.
Key: month
Type: Unsigned Integer

Example: Query records created in June.
[month]=6|6

Example: Query records created from June to July.
[month]=6|7

Day

Definition: The day of a month a record was created.
Key: day
Type: Unsigned Integer

Example: Query records created on the fourth day of the month.
[day]=4|4

Example: Query records created between the sixth and ninth days of the month.
[day]=6|9

Year

Definition: The year (current era) a record was created.
Key: year
Type: Unsigned Integer

Example: Query records created in the year 2013.
[year]=2013|2013

Example: Query records created between the years 2013 and 2015.
[year]=2013|2015

Time

Definition: The time of the day (24-hour) a record was created.
Key: time
Type: Time

Example: Query records created at 11 PM.
[time]=23:00|23:00

Example: Query records created between 1 and 2 AM.
[time]=01:00|02:00

Hour

Definition: The hour of the day (24-hour clock format) a record was created.
Key: hour
Type: Unsigned Integer

Example: Query records created on the first hour of any day.
[hour]=1|1

Example: Query records created between hours 20 and 22 of any day.
[hour]=20|22

Minute

Definition: The minute of the hour a record was created.
Key: minute
Type: Unsigned Integer

Example: Query records created at the top of any hour.
[minute]=0|0

Example: Query records created in the last ten minutes of any hour.
[minute]=50|59

Second

Definition: The second of the minute a record was created.
Key: second
Type: Unsigned Integer

Example: Query records created at the top of any minute.
[second]=0|0

Example: Query records created in the first ten seconds of any minute.
[second]=0|10

City

Definition: The geographical city where a record was created.
Key: city
Type: Text

Example: Query records created in any city named Huntsville.
[city]=huntsville

Example: Query records created in any cities named Huntsville, Glendale, and San Clemente.
[city]=huntsville|glendale|san clemente

State

Definition: The geographical state where a record was created.
Key: state
Type: Text

Example: Query records created in the state of Alabama.
[state]=al

Example: Query records created in the states of Alabama and Arizona.
[state]=al|az

County

Definition: The geographical county (or parish) where a record was created.
Key: county
Type: Text

Example: Query records created in any county named Madison.
[county]=madison

Example: Query records created in any counties named Madison and Orange.
[county]=madison|orange

Country

Definition: The geographical country where a record was created.
Key: country
Type: Text

Example: Query records created in the United States of America.
[country]=usa

Example: Query records created in the United States of America and Mexico.
[country]=usa|mex

Type

Definition: The means by which a record was originally created. There are two: analog and digital.
Key: type
Type: Text

Example: Query analog records.
[type]=analog

Example: Query digital records.
[type]=digital

Medium

Definition: The intervening substance by which records are collected and preserved. Examples include but are not limited to: paper, film, magnetic tape, and flash memory.
Key: medium
Type: Text

Example: Query records committed to paper.
[medium]=paper

Example: Query records committed to paper and film.
[medium]=paper|film

Format

Definition: An organizational classification of medium variations. Examples include but are not limited to: film formats (35mm, instant, super 8mm), magnetic tape formats (compact cassette), and flash memory formats (SD, CF, MicroSD).
Key: format
Type: Text

Example: Query instant film records.
[format]=instant

Example: Query instant and 35mm film records.
[format]=instant|35mm

Medium (Make)

Definition: The organization responsible for producing the intervening substance by which records are collected and preserved. Examples include but are not limited to: producers of journals, films, magnetic tapes, and flash memory cards.
Key: mediummake
Type: Text

Example: Query records collected on any media made by CR Gibson.
[mediummake]=cr gibson

Example: Query records collected on any media made by both Kodak and Fujifilm.
[mediummake]=kodak|fujifilm

Medium (Model)

Definition: The model of a specific medium make. Examples include but are not limited to: the Markings model of CR Gibson journals and the Portra model of Kodak film.
Key: mediummodel
Type: Text

Example: Query records collected on medium models named Markings.
[mediummodel]=markings

Example: Query records collected on medium models named Portra and Gold.
[mediummodel]=portra|gold

Medium (Variant)

Definition: The variation of a specific medium make and model. Examples include but are not limited to: the 400 ISO variant of Portra film made by Kodak and the Ruled variant of Hard Linen journals made by Shinola.
Key: mediumvariant
Type: Text

Example: Query records collected on the 400 variation (film ISO) of any medium make and model.
[mediumvariant]=400

Example: Query records collected on the 400 and 200 variations (film ISO) of any medium make and model.
[mediumvariant]=400|200

Recorder (Make)

Definition: The organization responsible for producing the enclosure that facilitates the use of a medium. Examples of recorders include but are not limited to: writing utensils, camera bodies, handheld recorders, and typewriters.
Key: recordermake
Type: Text

Example: Query records created with any recorder made by Pilot.
[recordermake]=pilot

Example: Query records created with any recorders made by Nikon and Fujifilm.
[recordermake]=nikon|fujifilm

Recorder (Model)

Definition: The model of a specific recorder make. Examples include but are not limited to: the G2 model of Pilot pens and the D610 model of Nikon cameras.
Key: recordermodel
Type: Text

Example: Query records created with recorder models named G2.
[recordermodel]=g2

Example: Query records created with recorder models named F2, F6, and D610.
[recordermodel]=f2|f6|d610

Recorder (Variant)

Definition: The variation of a specific recorder make and model. Examples include but are not limted to: the .38mm variant of G2 pen models made by Pilot.
Key: recordervariant
Type: Text

Example: Query records created with the .38mm variation of any recorder make and model.
[recordervariant]=.38mm

Example: Query records created with the .5mm and .7mm variations of any recorder make and model.
[recordervariant]=.5mm|.7mm

Peripheral (Make)

Definition: The organization responsible for producing elements required to facilitate the use of a medium with a recorder. Examples include but are not limited to: lenses, microphones, and inks.
Key: peripheralmake
Type: Text

Example: Query records created using any peripheral made by Noodlers.
[peripheralmake]=noodlers

Example: Query records created using any peripherals made by Nikon and Zeiss.
[peripheralmake]=nikon|zeiss

Peripheral (Model)

Definition: The model of a specific peripheral make. Examples include but are not limited to: the 19060 Bad Blue Heron model of Noodlers inks and the 50mm model of Nikon lenses.
Key: peripheralmodel
Type: Text

Example: Query records created using peripheral models named Bad Blue Heron.
[peripheralmodel]=19060 bad blue heron

Example: Query records created using 50mm and 35mm peripheral models.
[peripheralmodel]=50mm|35mm

Peripheral (Variant)

Definition: The variation of a specific peripheral make and model. Examples include but are not limited to: the f/1.4 variant of 50mm lenses made by Nikon.
Key: peripheralvariant
Type: Text

Example: Query records created with the f/1.4 variation of any peripheral make and model.
[peripheralvariant]=f/1.4

Example: Query records created with the f/1.4 and f/1.2 variations of any peripheral make and model.
[peripheralvariant]=f/1.4|f/1.2

Pseudonym

Definition: A permanent alias assigned to a person of significant influence in order to protect their identity.
Key: pseudonym
Type: Text

Example: Query records for any instance of Mariposa.
[pseudonym]=mariposa

Example: Query records for any instance of Xavier and/or Barry.
[pseudonym]=xavier|barry

Example: Query records for any instance of Josephine and Olga. Pseudonyms shall be spaced and arranged alphabetically.
[pseudonym]=josephine olga

ID

Category