3. All tables and columns

Table/column name

Col. type

Comments

app

Textual apparatus entries (variants)

id

int

verse_id

int

Link to verse relevant to the variant

word_ids

text

Type: idrefs; Links to relevant entries in word table

line_nums

varchar

Overrides word links to supply line numbers for variant lemma (e.g. 1-4 for first helmingr)

refs_ids

text

Type: idrefs; TEI: rdg[wit]; Links to entries in refs table, representing the witnesses to this particular reading

allmss

tinyint

If true (1) the reading applies to all witnesses not elsewhere defined for these words

type

enum

The type of reading; generally the value will be inserted in the apparatus entry in italics after the reading

reading

varchar

The reading itself (normalised unless dipl is true)

lemma

tinyint

If true, this reading will be used to show the unnormalised form in the lemma for the word(s), rather than as a variant reading

dipl

tinyint

If true, the reading represents the diplomatic text as defined in the Editors’ Manual; reading will appear in quotation marks

unsure

tinyint

Uncertain reading; reading will be followed by ‘(?)’ or similar

note

varchar

Where information is not available in other columns, free text can be inserted here and will appear in italics at the end of the reading

corr_from

varchar

Alternative reading, such as original text which has been corrected (use has become more broad than when column was first named)

corr_from_dipl

tinyint

If true, reading in corr_from is taken to be diplomatic and will appear in the apparatus in quotation marks

vartype

enum

The type of variant, such as lexical or grammatical; this field is not currently used by the skaldic project

notes

text

Notes for internal use by the project only

bibl_authors

bibliographic authors

id

int

name1

varchar

Given name(s)

name2

varchar

Patronym (for Icelandic names)

name3

varchar

Surname (used for alphabetical order except for Icelandic names)

icel

tinyint

Is the author Icelandic and should be alphabetised by first name, even when there is a surname?

dates

varchar

Dates for distinguishing authors of the same name

bibl_images

images of bibliographic works

id

int

bibl_work_id

int

The work the image is of

volume

tinyint

The volume of the work

section

enum

The part of the work in which the page number is relevant

page

smallint

The page number of the image (use Arabic numbers even in Roman numbered sections)

image_url

varchar

URI pointing to the location of the image (local or external)

copyright

tinyint

Is the image subject to copyright restrictions (true), or is it public domain (false)?

bibl_journals

Journals and other periodicals

id

int

abbr

varchar

Abbreviation used by the project(s)

name

varchar

Full name of journal

name1

varchar

notjournal

tinyint

The entry is used for some other purpose than to record an actual journal (e.g. a series title or similar)

notes

text

bibl_url

links for bibliographic entries

id

int

bibl_work_id

int

The work which this URI documents

url

varchar

URI of a resource that contains or documents this item

name

varchar

Descriptive name for the link

hidden

tinyint

Don't publish the link

bibl_works

bibliographic works

id

int

php_interface_ids

varchar

The database(s) for which this is relevant

volume_ids

varchar

The volume(s) in which this item should appear

type

enum

Type of resource: will determine how the item is formatted

abbr

varchar

An optional abbreviation for abbreviated references

abbr_sort

varchar

A sort form (i.e. with no formatting) for ordering abbreviated references

bibl_author_id

int

Link to the main author of this work

atype

enum

Type of author(s) — normally appended to the author list

bibl_author2_id

int

Link to the second author of this work

atype2

enum

Type of author for the second author

etal

tinyint

If true ‘et al.’ will be appended to author(s)

authors

varchar

Additional author details if more than two authors

dates

varchar

Year(s) of the work’s publication

useformatted

tinyint

Replace the normal output with the preformatted text in ‘formatted’ (you must still fill out all relevant fields for searching and ordering the work)

formatted

text

HTML text for displaying reference where the database cannot generate an accurate output for the entry

title

text

The title of the work

other

varchar

Other information (e.g. series, etc.)

publ

varchar

Publisher name

reprint

varchar

Reprint details (appended with ‘Repr.’)

place

varchar

Place of publication

bibl_work_id

int

Reference to another work which this is part of (required for book articles)

bibl_journal_id

int

Reference to a journal (required for journal articles)

jser

varchar

Journal series information (e.g. additional or special issues, special series, etc.)

vol

varchar

Volume of the journal or similar

num

varchar

Issue number of journal

pages

varchar

Page range for journal and book articles

url

varchar

URI for internet references or similar

accessed

date

Date accessed for URIs

webloc

varchar

location of passage for use with online resources, e.g. ‘para 3 of 17’

keywords

text

Keywords (not really used by these databases)

locations

text

Where the resource can be found

url_download

varchar

URL of resource in scanned form

notes

text

clips

locations of verses on images of mss

id

int

ref_id

int

Link to the instance of a stanza in a manuscript or inscription

image_id

int

Link to an image of a ms. or object

start_x

int

The point in pixels at which the text starts on the image (x)

start_y

int

The point in pixels at which the text starts on the image (y)

collections

names and locations of manuscript collections

id

int

type

enum

Type of collection — manuscript, runes (normally as published items), or another grouping of objects/independent witnesses of the text

name

varchar

Name of collection

location

varchar

Location of collection

latlong

varchar

Latitude and longitude coordinates eg. 63.43,-12.34

zoom

tinyint

Used for Google Maps API — the level at which a map of the location should be zoomed

abbr

varchar

Abbreviation for collection

notes

text

compound

links two words as compound

id

int

first_word_id

int

Link to the first part of the compound

last_word_id

int

Link to the second part of a compound

lemma_id

int

Link (optional) to a dictionary headword

lexicon_id

int

Link as a citation to the lexicon sense

verse_id

int

Link to the stanza in which this occurs (not strictly necessary but helps to reduce linking load when querying this table)

doc

miscellaneous documentation in recursive arrangement

id

int

topdoc_id

int

Link to a document collection that this forms part of (linked document should have NULL doc_id)

doc_id

int

Link to a parent document which this forms part of (used for creating a document tree)

n

smallint

Number for ordering document within group with same parent document (must be unique with doc_id)

n_alt

varchar

An alternative number where ‘n’ is inappropriate

name

varchar

Title for the document

content

mediumtext

The HTML content of the document

restricted

tinyint

Select this if access should be restricted to project members or those with access to the volume this forms part of

editor_id

int

The editor responsible for authoring the document (optional)

php_interface_ids

varchar

The database(s) which this document is relevant to

all_interfaces

tinyint

Select if document should appear in all interfaces

cdate

date

Creation date for document (optional)

images

images of pages from the manuscripts

id

int

ms_id

int

Link to the manuscript of which this is an image

page

varchar

Page or folio number for image (one page per image normally). This should normally have the same format as other page references to the same manuscript.

url

varchar

URI where an original image may be found

file

varchar

Filename of image on the server filesystem, relative to the database scripts (required)

dpi

smallint

Image DPI value or approximation

source

char

Link to appl_imgsrc table with different types of images

size_x

smallint

width of image

size_y

smallint

height of image

restricted

enum

Is the image public, or is it only available to members of the project?

copystmt

text

A copyright statement for the image e.g. ‘(c) Stofnun Árna Magnússonar’

editor_id

int

Link to an editor who supplied the image (optional)

notes

text

kenning

new kenning referents table

id

int

verse_id

int

Link to the stanza in which the kenning occurs

n

tinyint

The number of the kenning within the stanza

level

tinyint

The level of the kenning (1=outermost kenning)

word_ids

text

Links to ‘word’ table for the words that make up the kenning (in SET format)

bwword_id

int

Optional link to the specific word which is the baseword of the kenning (not yet implemented)

bwkenning_id

int

Link to a kenning which forms the baseword of the kenning (not yet implemented)

detword_id

int

Link to the word which forms the determinant of the kenning (not yet implemented)

detkenning_id

int

Link to the kenning that forms the determinant of the kenning (not yet implemented)

lastpr_word_id

int

The last word of the kenning in the prose word order of the stanza

lasttr_word_id

int

Link to the last word of the kenning in the translation (used for positioning the kenning referents in the text)

rough_prose

varchar

A rough prose order used for checking the kenning (auto-generated and not reliable)

rough_trans

varchar

A rough translation used for checking the kenning (auto-generated and not reliable)

ref

varchar

The referent (links to entries in the kenningrefs table)

genref

varchar

A second, more general referent (rarely used)

nameref

varchar

Referent which is a named being or person (inserted after '=' in the edition)

lemma_id

int

Link to a lemma which is likely to be the referent in Old Norse (not really used at this stage)

contextref

varchar

A contextual referent (named person or being)

uncertain

tinyint

Is the reference or kenning uncertain in its interpretation? (inserts '?' into the text)

lit

varchar

A literal translation of the kenning where compound elements have been inverted for the standard translation

ofljost_ref

varchar

An ofljóst referent, i.e. a word in Old Norse which the kenning appears to play on

ofljost_trans

varchar

A translation of the ofljóst referent which explains the word-play

kenningtype_id

int

A link to the kenning type table, classifying the kenning

notes

text

thing_id

int

For named referents, the kenning refers to a person or being in the thing table

kenningclass

classes of basewords, determinants and referents of kennings

id

int

name

varchar

The English name for this class of kenning element

name_on

varchar

An Old Norse name for this class of kenning element (use those from the þulur titles where appropriate)

kenningclass_id

int

A link to the same table where this kenning element type is a sub-type of another one

baseword

tinyint

Can this element type form a baseword of a kenning?

determinant

tinyint

Can this element type form a determinant of a kenning?

referent

tinyint

Can this element type form a referent of a kenning?

medieval

tinyint

Is the interpretation here based on medieval sources?

meissner

varchar

The equivalent section in Meissner’s index

meissner_name

varchar

The name given to this category in Meissner

notes

text

kenningrefs

list of kenning referents

id

int

name

varchar

Name of kenning referent (normally upper case)

kenningclass_id

int

A link to the kenningclass table

disallowed

tinyint

If true, this referent is not to be used in the edition

notes

varchar

kenningtype

classification systems of kennings

id

int

class

varchar

type

varchar

notes

text

lemma

headwords from onp and elsewhere

id

int

n

tinyint

For homonyms, the number used to disambiguate them in the lexicon (must be unique with the lemma)

name

varchar

The lemma (headword) itself

oen_lemma

varchar

An East Norse lemma where relevant

onp_lemma

varchar

The original lemma form from ONP

alt

varchar

An alternative spelling (not for oblique forms)

gramminfo

varchar

Basic grammatical information about the declension/conjugation or similar

part

enum

Part of speech

plural

tinyint

Is the lemma a plural form?

gramm

varchar

ONP: grammatical info

inflclass

varchar

ONP: inflectional class

class

varchar

onpcit

smallint

ONP: Number of citations

trans

varchar

A rough translation/gloss for disambiguation

discussion

mediumtext

(Not used)

notonp

tinyint

The lemma is not from the ONP wordlist

skpnew

tinyint

The lemma has been added by the Skaldic Project

poetic

tinyint

ONP: poetic word

persname

tinyint

Personal name

placename

tinyint

Place name

ethnicname

tinyint

Ethnic name

mythname

tinyint

Mythological name

foreign_word

tinyint

ONP: foreign word

onppoetic

tinyint

ONP: poetic word

youngicel

tinyint

ONP: Younger Icelandic

youngnorw

tinyint

ONP: Younger Norwegian

uncertain

tinyint

Not sure whether this is in fact a word or a distinct word

reconstr

tinyint

Reconstructed form (only occurs in defective contexts)

donotuse

tinyint

Do not use the lemma for the skaldic project

runic

tinyint

The word is in the runic corpus

prose

tinyint

grammitem

tinyint

The word is a formword or similar linguistic category (i.e. unaccented in verse)

nott_id

int

Link to the Nottingham Rune Dictionary

nott_lem

varchar

Lemma form from the Nottingham Rune Dictionary

nott_gramm

varchar

Grammatical information from the Nottingham Rune Dictionary

nott_lemown

varchar

West Norse form from the NRD

nott_swedish

varchar

Swedish form from the NRD

nott_english

varchar

Gloss/translation from the NRD

nott_ref

varchar

References from the NRD

doc_id

int

A link to a document which provides grammatical information

notes

text

php_interface_ids

varchar

Database(s) for which this word is relevant (normally determined by other dependencies)

lemmapart

parts of compound lemma

id

int

lemma_id

int

Link to the lemma which this word is part of

part_lemma_id

int

Link to the lemma which corresponds to the compound part

sort

tinyint

The number of the word within the compound

lexicon

lexicon poeticum entry

id

int

lemma_id

int

The headword which this sense forms part of

lexicon_id

int

A link to another sense where this is a sub-sense

n

char

The number of the sense or sub-sense

sense

varchar

The description/gloss of the sense

notes

text

line

verse lines

id

int

verse_id

int

Link to the stanza or text segment which this forms part of

n

smallint

line number

n_alt

varchar

Alternative numbering for lines or other text segments

repeats

tinyint

This line repeats one in another stanza (e.g. a repeated stef)

linetype

enum

Metrical type according to Siever’s system

linetype_id

int

Link to line type according to Kuhn/Gade (linetype table)

rough

varchar

Simple text of line (auto-generated and unreliable)

mettype

varchar

Metrical analysis

met

varchar

Another metrical analysis

type

enum

Type of line or segment: Normal verse line (left margin), b-line (preceded by spaces), ljóðaháttr long line (preceded by newline and spaces), prose (inline), prose before verse, prose after verse (new paragraph, inline) or heading

altfirst

tinyint

This should be indexed as an alternative first line for the stanza (e.g. where a 2nd helmingr occurs free-standing)

linetype

Metrical line types according to Kuhn, Gade, etc.

id

int

basetype

enum

The basic Sievers type

metre

char

A link to the metre in which this occurs

abbr

varchar

An abbreviation for the metrical type

met

varchar

The metrical analysis of this type

descr

varchar

A description of the type

notes

text

locations

locations of poems and texts in the corpus

id

int

ms_id

int

Link to the manuscript in which this text/poem is found (required)

text_id

int

Link to a text/poem (required)

mainms

tinyint

The manuscript represents the main/base text of the poem/text

page1

varchar

The page on which this text starts

col1

enum

The column on which this text starts

line1

tinyint

The line on which this text starts (optional)

page2

varchar

The page on which this text ends

col2

enum

The column on which this text ends

line2

tinyint

The line on which this text ends (optional)

siglum

varchar

A siglum from e.g. ONP for this particular version of the text

incipit

varchar

Opening words of the text

notes

text

rawscope

varchar

A free-text list of page references in which this text occurs in the ms.

metre

metres

id

int

abbr

char

1-letter abbreviation/index for the metre

name

varchar

Name of metre in Old Norse where relevant

namenorm

varchar

ASCII form of the name for exporting

skaldic

tinyint

Is this a skaldic metre?

unclassified

tinyint

Is the metre unclassified?

syllabic

tinyint

Does the metre count syllables?

unstress_syllabic

varchar

positions

varchar

Metrical positions per line

positions_str

varchar

Metrical positions per line (where lines are of different lengths)

min_allit

tinyint

Minimum alliterations per line pair (normall 2 or 3)

rhymes

tinyint

Number of rhymes per line pair (0, 1 (runhent), or 2 (internal rhyme))

metclass

enum

Classification according to metrical density (see Wills 2009)

notes

text

appl_table_id

int

mss

information on manuscripts, inscriptions and unique objects

id

int

idx

varchar

siglum

varchar

The manuscript siglum, normally the abbreviated collection name plus shelfmark; must be unique (required)

abbr

varchar

An abbreviated siglum for use by the project; must be unambiguous

name

varchar

A name for the manuscript (e.g. Codex Wormianus) or inscription (e.g. Karlevi) where relevant

notes

text

comments

text

Formatted comments on the object (not really used)

sort

varchar

A string by which the item can be sorted: see similar items and adjust appropriately

type

enum

Type of object; paper normally will have a superscript x appended to the sigla

reykjavik

enum

For collections that were sent to Iceland, is the ms. now in Reykjavik, or did it remain in Copenhagen?

consult

enum

(not really used) Should the ms. be consulted for the edition?

dating

varchar

Date information in the fomat: optional 'c' + year or year range

dating_mid

smallint

A year representing the midpoint of the dating or estimated dating

skaldic

enum

Is the ms. relevant to the skaldic edition? (partially superseded by ‘php_interface_ids’)

php_interface_ids

varchar

The database(s) for which this is relevant (may be determined by other dependencies)

collection_id

int

A link to the collection in which this item is classified (required)

sameas_bibl_work_id

int

A link to what is in fact the same as an entry in the bibliography but is treated as an independent witness of a medieval text in this table

doc_urn

varchar

location of definitive or authoritative documentation

object

varchar

The type of object (esp. for inscriptions)

location

varchar

Location of object (esp. for inscriptions)

img_status

varchar

Status of image collection for runic inscriptions in the skaldic corpus

img_order

varchar

Status of ordering information for images of runic items in the skaldic corpus

img_ok

tinyint

The skaldic project has images ready for publication in the runic volume

latlong

varchar

Latitude and longitude coordinates in WGS84 format (no space)

onp_msmadat_ms

varchar

Link to ONP tables

onp_alreg_ms

varchar

Link to ONP tables

notes

critical, etc. notes to verses

id

int

verse_id

int

Link to the stanza which this annotates

line_nums

varchar

Line number or range which this note relates to

word_ids

text

Links to words by id (SET format)

icel

varchar

Lemma to note in original language

gramm

varchar

Grammatical information associated with the lemma

trans

varchar

Translation of the lemma (should correspond to edition)

note

text

The content of the note itself in HTML format

noprint

tinyint

The note is not for print publication

notes

text

Notes for internal use by the project

editor_id

int

Link to editor responsible for note (if not stanza editor(s))

orderings

verses in their prose contexts in order

id

int

text_id

int

Link to the prose work in which the stanza occurs

verse_id

int

Link to the stanza

chapter_id

int

Link to a prose chapter in which the stanza occurs (optional)

chapter_verse_id

int

Links to a particular chapter in a prose text

here

enum

In the edition, the stanza edited occurs at this point (rather than a second occurrence in the same text; not really used)

2nd

tinyint

This is the second or subsequent occurrence of the stanza in the text

n

smallint

The number of the stanza in the sequence of the text

n_alt

char

An alternative number, e.g. editorial, of the stanza in the text

compln

enum

The stanza is listed here as part of a work which is a compilation

line1

tinyint

For partial occurrences, the first line of the stanza which is cited here

line2

tinyint

For partial occurrences, the last line of the stanza which is cited here

lines_alt

varchar

An alternative representation of a partial stanza where the arrangement is more complicated

alt_n

varchar

An alternative number

notes

text

refs

references to verses in manuscripts

id

int

verse_id

int

Link to the stanza which this is an instance of

ms_id

int

Link to the ms or other object in which this stanza occurs

rdg

varchar

The abbreviated name of a particular editor where this represents an editorial reading of a ms.

skip

tinyint

Do not use this ms./version for the edition

mainms

tinyint

This is the main ms. version for this text

2nd

tinyint

This is the second occurrence of the stanza in this ms.

2nd_pg

tinyint

This is the second occurrence of the stanza in this ms. page

spor

tinyint

Readings from this ms. are used only sporadically

rdg_sort

smallint

Number used to sort the ms. versions of this stanza

page1

varchar

The page on which this reading starts

col1

enum

The column on which this reading starts

line1

tinyint

The line on which this reading starts

marg

tinyint

The reading is written in the margin

page2

varchar

The page on which this reading ends

col2

enum

The column on which this reading ends

line2

tinyint

The line on which this reading ends

transcription

text

Transcription of the inscription using Unicode/MUFI characters

vline1

smallint

If reference represents only part of the verse/stanza, the start line of the verse corresponding to the numbering in the line table

vline2

smallint

If reference represents only part of the verse/stanza, the end line of the verse corresponding to the numbering in the line table

vlines

varchar

For more complicated arrangements of partial stanzas

text_id

int

Link to the prose work in which this reading occurs (will be inserted into manuscript list)

text2_id

int

chapter_id

int

Link to a prose chapter in which this stanza occurs

chapter_verse_id

int

Links to a particular chapter in a prose text

notext

tinyint

The stanza does not occur in prose context (overrides text_id)

notes

text

Notes for internal use by the project

editor_id

int

Link to editor responsible for the transcription

skalds

skalds (poets) in the corpus

id

int

name

varchar

Skald’s name in full

descr

varchar

A quick description of the skald

abbr

varchar

Abbreviated siglum for skald for use by the project

abbr_lp

varchar

Lexicon Poeticum’s abbreviation for the skald, where relevant

century

enum

The century in which the skald was most active

skp_v

tinyint

SkP volume where main entry for skald occurs (incl. biography)

skp_p

varchar

Page(s) where skald occurs in the Skaldic Project print editions

skj

enum

Is this skald listed as such in Skj?

skjindex

enum

In which index of Skj does this occur, if any?

skjname

varchar

Name of skald in Skj

skja

varchar

Page references in Skj A

skjb

varchar

Page references in Skj B

skjinfo

varchar

Byline in Skj (normally Danish, italic)

skaldic

tinyint

Is the skald/entry a skaldic poet?

person

tinyint

Is the entry a person (some entries are used for grouping anonymous poems and stanzas)

editor_id

int

The editor responsible for the bulk of the skald’s poetry

biography_editor_id

int

The editor responsible for the biography of the skald

volume_id

int

The volume in which the biography occurs

dates

varchar

The dates of the skald (b., fl., d., etc.)

place_thing_id

int

Link to the place where the skald was born or flourished

biography

text

HTML-formatted biography of the skald (in paragraphs)

text_levels

varchar

This is used by other projects to determine the way in which the different text forms in ‘word’ behave

public

tinyint

(not used)

notes

text

notes_html

text

HTML-formatted notes for internal use

text_id

int

(Not used)

skalds_doc

alternative source of introductory material

id

int

skald_id

int

Link to skald

doc_id

int

Link to documentation from volume introductions

n

tinyint

Used to order documentation

stemma

Manuscript stemmata represented in table format

id

int

text_id

int

The text or poem which this is the stemma for

stemma_id

int

A link to a parent entry in the same table; NULL if the archetype

name

varchar

Placeholder for a ms. in the stemma (e.g. ‘B’)

ms_id

int

Link to a ms. where the stemma item is a ms. in the database

notexactly

tinyint

An uncertain or inexact relationship between this item and its parent in the stemma

notes

text

text

Prose works and poems of various types; TEI: ‘text’ element

id

int

urn

varchar

Link to definitive name or documentation

type

enum

Type of text

lang

varchar

Language of original text

cat

enum

For the skaldic edition, a poem should be categorised as belonging to a skald, anonymous grouping or prose work

skald_id

int

Link to the author or skald

text_id

int

Link to parent text, or for skaldic poems, the text which it should be categorised under

n

tinyint

Number of text within parent text or author

textn

tinyint

Number of text within parent text — should eventually be replaced with n

skaldic

enum

Is the text/poem relevant to the Skaldic Project?

php_interface_ids

varchar

Relevant databases and interfaces

name

varchar

Name of text or poem in original language where relevant

nametrans

varchar

Name in English

nametype

enum

Name type: medieval (original) name, generic name such as Lausavísur or Fragment, or modern/editorial name

abbr

varchar

Abbreviation: must be unique to skald

abbr_fritz

varchar

Abbreviation from Fritzners dictionary

abbr_lp

varchar

Abbreviation from Lexicon Poeticum

lp_abbr

tinyint

Lexicon Poeticum has an abbreviation for this work

abbr_old

varchar

Superseded abbreviation

provenance

text

Unstructured account of the provenance of the text

latlong

varchar

Coordinates representing origin of text in WGS84 decimal format /^[0-9.]+,-?[0-9.]+$/

dating_disc

varchar

Unstructured account of the dating of the text according to the best evidence

dating

varchar

Date in format /^c?[1-9][0-9]{0,3}(-[1-9][0-9]{0,3})?$/

dating_mid

char

Midpoint of dating or putative dating in year format /^[1-9][0-9]{0,3}$/

skp_v

tinyint

Skaldic Project volume number

skp_p

varchar

Skaldic Project page number in format /^[1-9][0-9]{0,3}(-[1-9][0-9]{0,3})?$/

skj

enum

Is this a poem or category found in Skj?

skjindex

enum

Is this a poem found in Skj, and in which volume?

skjskald_id

int

Link to skald according to Skj classification

skjn

varchar

Number of poem under skald/anon in Skj

skjname

varchar

Name of poem or group of stanzas in Skj

skjinfo

varchar

Additional information, normally in italics, from Skj

skja

varchar

Page reference to Skj A in format /^(II?, [0-9]{1,3}(-[0-9]{1,3})?)?$/

skjb

varchar

Page reference to Skj B in format /^(II?, [0-9]{1,3}(-[0-9]{1,3})?)?$/

volume_id

int

Reference to Skaldic volume in which this text or poem will appear

editor_id

int

public

tinyint

Publish this text/poem (see also publ)

introduction

text

Introduction to the text or poem

collection_id

int

For collections of runic inscriptions which use this table, this links to the entry in the collections table

doc_id

int

For the text database, this provides a link to the documentation table for an alternative introduction (this should in the future be replaced by another mechanism)

onp_vktitel_loebenr

int

Link to the text in the ONP database table

notes

text

Notes for internal use by the project(s)

notes_html

text

Additional notes using HTML formatting

textdoc

alternative source of introductory material

id

int

text_id

int

Link to text/poem which this documents

doc_id

int

Link to part of introdutory material which documents this text/poem

n

tinyint

Order of documentation for the text/poem

thing

any sort of feature, for indexing

id

int

thing_type_id

int

Link to the type of thing (‘thing_type’ table)

subcat

varchar

A subcategory; free text but generally should be from a limited set

name

varchar

Name of thing

uncertain

tinyint

The existence of this thing is uncertain

lost

tinyint

The place, etc. is now lost or unknown

parent1_thing_id

int

Link to a parent thing of some type

namegen

varchar

Parish name, where relevant

namegen0

varchar

District name, where relevant

namegen1

varchar

Region or nickname

namegen2

varchar

Country or patronymic

name_full

varchar

Full name for disambiguation

name_modern

varchar

A modern form of the name

name_english

varchar

English translation of name

dates

varchar

Dates for persons or other relevant items

refyear

varchar

Year used for chronological ordering

latlong

varchar

Latitude and longitude coordinates in WGS84 format (no space)

latlong_source

varchar

Source of coordinates (URI)

latlong_search

varchar

Term used to search for item in the source specified in ‘latlong_source’

latlong_accuracy

tinyint

Estimated accuracy of coordinates (10m ** x)

loc_uncertain

tinyint

The location is uncertain

loc_inaccurate

tinyint

The location is not accurate

loc_area

tinyint

The place is an area/region

skald_id

int

Link to an entry in ‘skalds’ which is identical to this item

text_id

int

Link to an entry in ‘text’ which is identical to this item

kenningclass_id

int

Entry is identical to an entry in ‘kenningclass’

lemma_id

int

Link to a dictionary lemma for this name

same_thing_id

int

This is equivalent to another entry which should be taken as the main entry

lemma

varchar

Dictionary lemma for lookups

description

mediumtext

HTML-formatted description of the item

forms

text

Different forms of the name

bibl_work_id

int

verse_ids

text

References to text sections where this thing is explicitly mentioned

php_interface_ids

varchar

Database(s) for which this word is relevant (normally determined by other dependencies)

volume_ids

varchar

Volumes in which this index item should be printed

notes

text

thingref

index of features of verses

id

int

thing_id

int

attribute_id

int

verse_id

int

type

varchar

val

varchar

ref

varchar

notes

text

thing_type

Types of features

id

int

php_interface_ids

varchar

name

varchar

notes

text

verses

Verses/stanzas in the corpus; also chapters and text

id

int

dating

varchar

Skj dating of verse

info

varchar

Speaker or info.

name

varchar

Title, if relevant

name_trans

varchar

Title in English, if relevant

n

int

Number of stanza/text in poem/text

alt

varchar

Sub-number of item (normally ‘a’, ‘b’)

n_run

varchar

Rune siglum or speaker

n_alt

varchar

A second alternative number

n_run_sort

varchar

Sort form for runic numbers

caption_source

enum

Heading or caption source

intro_caption

varchar

Caption (use with ‘info’ in caption_source)

intro

text

Introduction to stanza in HTML format

skp_v

tinyint

Published volume in which this item occurs

skp_p

varchar

Page reference to published volume in which this item occurs

skjpoem_id

int

Link to the poem which this appears under in Skj

skjn

varchar

Number of stanza in Skj

skjpart

varchar

Line numbers where Skj has partial text or different lines

skjinfo

varchar

Info in brackets with stanza from Skj

skjref

tinyint

If true, add Skj reference automatically to editions list

skja

varchar

Volume and page reference to Skj A

skjb

varchar

Volume and page reference to Skj B

skjatext

text

Text of stanza from Skj A

skjbtext

mediumtext

Rough text from Skj B where relevant or another readily available edition

skjbtext_source

varchar

Source of text (if not Skj B)

skjbtrans

mediumtext

Rough translation from Skj B where relevant or another readily available source

skjbtrans_source

varchar

Source of translation (if not Skj B)

groups

varchar

Old administrative categories

text_id

int

Link to parent poem or text

skp_text_id

int

Text in which this is classified in SkP vols 5 and 8

textn

smallint

Number of stanza in text in SkP 5/8

volume_id

int

Link to volume in which this stanza is categorised (if poem/skald does not have equivalent field set)

editor_id

int

Link to editor responsible, where relevant

editor2_id

int

Second editor of verse

publ

enum

(Not used)

inclusion

enum

Type of resource or status of inclusion in edition

metre

char

Link to table of metrical types

breakafterline

tinyint

Where text is presented in two columns, the line after which it should be broken if not 4, 8 or 12

textlang

enum

Language of text

rune

tinyint

The stanza is a runic text

run_title

varchar

The title used in SkP 6

run_rdg

text

The reading for SkP 6

run_rdg_notes

text

Notes to the reading for SkP 6

run_prose_before

text

Prose text at start of inscription for SkP 6

run_prose_after

text

Prose text after inscription for SkP 6

lg_alt

text

Alternative text of stanza for insertion into notes

trans_lines

text

Translation in lines

ignore_prose

tinyint

Used to supress prose word order in edition

ignore_trans

tinyint

Used to supress translation in edition

editions

text

List of editions in HTML format, using internal referencing for SkP

one_edn

tinyint

There is only one edition (alters caption for editions()

context

text

HTML-formatted prose context description

verse_id

int

Link to a chapter or other item in which this occurs

xref_verse_id

int

Cross-reference to stanza for use with inclusion=xref value above

notes

text

notes_html

text

HTML-formatted notes

status

enum

The revision and publication status of the text and associated information (not necessarily all linked information)

old_chapter_id

int

volumecontent

contents of a printed volume

id

int

volume_id

int

Link to volume in which item occurs

n

smallint

Number used to order contents of volume

subheading

tinyint

Is the item a subheading (2nd-level part)?

section

varchar

Option 1: Item is a secisection heading or divider

skald_id

int

Option 2: item is a poet with biography

text_id

int

Option 3: item is a separate poem or prose work

volumes

published volumes of the corpus

id

int

php_interface_id

int

relevant resource

n

tinyint

volume number

title

varchar

Title of volume

abbr

varchar

Abbreviated number

year

year

editor_id

int

First volume editor

editor2_id

int

Second volume editor

groups

varchar

Old admin. groups

doc_id

int

Link to document where front and back matter of volume are stored

url

varchar

Link to ordering information for volume (URI)

printed

tinyint

The volume has been printed

public

tinyint

The volume’s publication embargo has been lifted

notes

text

word

Words in text, with translation, lexical and gramm. info, &c

id

int

verse_id

int

Link to stanza/chapter/section in which word occurs

line_id

int

Link to line in which word occurs (this is slightly redundant, but necessary for the interface)

n

smallint

Line number for stanza or another numbering schema depending on the nature of the item linked by verse_id

cpd

varchar

NOT USED

part

enum

NOT USED

app_id

int

Link to variant apparatus where variant reading of word

word_id

int

Where app_id links to multiple words, this can disambiguate which is meant

seelemma

tinyint

For glossaries, create cross-ref between word and lemma

seegramm

tinyint

For glossaries, include grammatical info for this word form in context

seetrans

tinyint

For glossaries, include translation of this word in its context

text_before

varchar

Punctuation before word

text

varchar

The word itself in the main text

text_after

varchar

Punctuation after word in main text

prose_n

tinyint

Order of word in prose order/secondary text

prose_before

varchar

Punctuation before word in prose order/secondary text

prose

varchar

Text of word in prose order/secondary text

prose_after

varchar

Punctuation after word in prose order/secondary text

trans_n

tinyint

Order of word in translation/tertiary text

trans_before

varchar

Punctuation before word in translation/tertiary text

trans

varchar

Text of word in translation/tertiary text

trans_after

varchar

Punctuation after word in translation/tertiary text

heiti

varchar

A heiti reference for the word (appears in angled brackets)

heiti_lemma_id

int

Link to dictionary headword for heiti reference, if relevant

thing_id

int

Word corresponds directly to a place, being or other thing in the index table

norm

varchar

(Not really in use) Normalised form of word

gramm

varchar

(Not really in use) Grammatical form of word (abbreviated)

gramm_case

enum

Grammatical case of word in context

gramm_gender

enum

Grammatical gender of word in context

gramm_number

enum

Grammatical number of word in context

gramm_person

enum

Grammatical person of word in context

gramm_tense

enum

Grammatical tense of verb in context

gramm_voice

enum

Grammatical voice of verb in context

gramm_finite

enum

Grammatical finiteness of verb in context

gramm_def

enum

Grammatical definiteness of verb in context

gramm_suffix

enum

Suffix on word

gramm_neg

tinyint

Negative particle attached?

gramm_strong

enum

Strong or weak adjective

gramm_mood

enum

Grammatical mood of verb in context

gramm_adj

enum

Comparison of adjective

lemma_id

int

Link to dictionary headword for this word

lemma

varchar

Some forms use this to help look up a lemma link

lexicon_id

int

For dictionaries, link to a particular sense (must link in turn to the same as lemma_id)

met

varchar

Metrical pattern

allit

varchar

Alliterative letters on line

skoth

varchar

Letters carrying skothending

adalh

varchar

Letters carrying aðalhending

metpos

tinyint

Number of metrical positions of word

wordform

list of word forms linked to lemmata + optional gramm info

id

int

name

varchar

Actual form of word found in texts

lemma_id

int

Link to dictionary headword for this form of the word

gramm_case

enum

Grammatical form where unambiguous: case

gramm_gender

enum

Grammatical form where unambiguous: gender

gramm_number

enum

Grammatical form where unambiguous: number

gramm_person

enum

Grammatical form where unambiguous: person

gramm_tense

enum

Grammatical form where unambiguous: tense

gramm_voice

enum

Grammatical form where unambiguous: voice

gramm_finite

enum

Grammatical form where unambiguous: finiteness

gramm_def

enum

Grammatical form where unambiguous: definiteness

gramm_suffix

enum

Grammatical form where unambiguous: suffixed item(s)

gramm_neg

tinyint

Grammatical form where unambiguous: negative suffix

gramm_strong

enum

Grammatical form where unambiguous: strong or weak adjective

gramm_mood

enum

Grammatical form where unambiguous: mood

gramm_adj

enum

Grammatical form where unambiguous: comparison of adjective