Data Models

Events

events: A distinct happening defined by title, date/s and venue; typically, a performance or series of performances at a venue. This is the core table of IbsenStage. Multiple presentations of the same production at different venues (e.g. touring productions) are recorded as separate events.
event_name: The title or name of an event. Free text. Using preceding capitals except for articles, prepositions and pronouns. Mandatory.
umbrella: The festival or series in which an event is presented. Enter only if applicable. Free text.
venueid: The unique number identifying the venue at which the event occurred. Displayed as venue name, suburb, state or country. Unique.
ddfirst_date: The day of the event's first public presentation even if a preview. Enter as numerals. Display as numerals.
mmfirst_date: The month of the event's first public presentation, even if a preview. Enter as numerals. Display as text.
yyyyfirst_date: The year of the event's first public presentation even if a preview. Enter as numerals. Displayed as numerals. Mandatory.
sndfirst_date: The date of the event's first public showing, even if preview. Automatically generated.
ddopening_night: The day of the event's opening public showing - not a preview. Enter as numerals. Displayed as numeric.
mmopening_night: The month of the event's opening public showing - not a preview. Enter as numerals. Display as text.
yyyyopening_night: The year of the event's opening public showing - not a preview. Enter as numerals. Displayed as numeric.
sndopening_night: The date of the event's opening public showing - not a preview. Automatically generated.
ddlast_date: The day of the event's last public presentation. Enter as numerals. Displayed as numerals.
mmlast_date: The month of the event's first public presentation. Enter as numerals. Display as text.
yyyylast_date: The year of the event's first public showing. Enter as numerals. Displayed as numerals.
sndlast_date: The date of the event's last public showing. Automatically generated.
estimated_dates: Are the event's dates are estimated?. Binary selection: either yes or no.
status: The socio-economic status of the production of an event. Encompasses a range from professional to amateur. Select from the controlled list. Mandatory.
world_premier: Is the event a world premiere (being presented for the very first time)?. Binary selection: either yes or no.
part_of_a_tour: Is the event is part of a touring production?. Binary selection: either yes or no.
description: A short description of the content or significance of the event. Free text. Preferably derived from an existing resource and referenced in Description Source. Add referenced resource to the Resource table.
description_source: Denoting the source of the event description entered in the free text field above. To be chosen from controlled list.
primary_genre: A category indicating the kind of event, as defined by its main mode of performance. Select from the controlled list, noting associations between primary and secondary genres. 'Other' is to be used only as a last resort. Mandatory.
further_information: Any additional relevant information about the event not already covered by the available fields. Not to be confused with event description, which aims to summarise the content of the event. Free text.
review: Is the record reviewed?. Binary selection: either yes or no. If yes, displayed as user name of reviewer (from updated_by_user) and date.
eventid: A unique number identifying an event. Automatically generated. Unique.
entered_by_user: The user name of the user entering the data. Entered automatically.
dddate_entered: The day of data entry. Entered automatically.
mmdate_entered: The month of data entry. Entered automatically.
yyyydate_entered: The year of data entry. Entered automatically.
snddate_entered: The date of data entry. Entered automatically.
updated_by_user: The name of the user updating the data. Entered automatically on update.
dddate_updated: The day of data update. Entered automatically on update.
mmdate_updated: The month of data update. Entered automatically on update.
yyyydate_updated: The year of data update. Entered automatically on update.
snddate_updated: The date of data update. Automatically generated.

Contributor

contributor: An individual who contributes in some capacity to the conception, production or presentation of an event. Contributors are distinguished by their name and date of birth. A new record is created when a contributor changes name; former and subsequent names are recorded in the Other_Names field. Multiple contributors with the same name should be distinguished by date of birth and function. Care should be taken to avoid unnecessary duplicates, with particular attention being paid to variations in spellings of the same contributor. Contributors must be an individual, and may be human or non-human (e.g. animal, machine).
prefix: A contributor's title. Mr, Mrs, Prof, Dr etc.
first_name: The contributor's first name or initial. Free text, with capitalised initial letter. Use a hyphen if there is no first name. Mandatory.
middle_name: A contributor's middle name/s or initial/s. Free text, with capitaliased initial letter.
last_name: The contributor's last name/s. Free text, with capitalised initial letter. Use a hyphen if there is no last name. Mandatory.
suffix: A contributor's suffix. OAM, PhD, AM etc.
display_name: The contributor's first name and last name. Auto-generated by concatenating the First Name and Last Name, but editable.
other_names: Other names by which the contributor is known. May include stage names, former or subsequent names, or alternative spellings of the First and Last Names. Free text, in natural order, with capitalised initial letter. Separate multiple names with ;.
gender: The contributor's gender. Select either female or male.
nationality: The contributor's nationality, whether by origin or adoption. Free text, with capitalised initial letter. Prefer self-identified nationality; consult contributor if possible; otherwise nationality of origin. Hyphenated nationalities are acceptable.
place_of_birth: A contributor's place of birth. Select from venue table.
place_of_death: A contributor's place of death. Select from venue table.
dddate_of_birth: The day of the contributor's birth. Enter as numerals. Display as numeric. Not visible to users on the public side, unless date of death is complete.
mmdate_of_birth: The month of the contributor's birth. Enter as numerals. Display as text. Not visible to users on the public side, unless date of death is complete.
yyyydate_of_birth: The year of the contributor's birth. Enter as numerals. Display as numerals. Not visible to users on the public side, unless date of death is complete.
dddate_of_death: The day of the contributor's death . Enter as numerals. Display as numerals. Source from published obituaries or research publications.
mmdate_of_death: The month of the contributor's death. Enter as numerals. Display as text. Source from published obituaries or research publications.
yyyydate_of_death: The year of the contributor's death. Enter as numerals. Display as numerals. Source from published obituaries or research publications.
notes: Additional biographical information about the contributor. Recommended use is to draw biographical information from published sources or invite contributor to provide information. Note source at end of field. Free text.
contributorid: A unique number identifying a contributor. Automatically generated. Unique.
entered_by_user: The user name of the user creating the record. Entered automatically on creation.
entered_date: The date when the record is created. Entered automatically on creation.
updated_by_user: The user name of the user updating the data. Entered automatically on update.
updated_date: The date when the record is last updated. Entered automatically on update.
address: The contributor's house and street address of residency. Free text. Use only when provided by contributor. Not visible to users on public side.
suburb: The contributor's suburb address of residency. Free text. Use only when provided by contributor. Not visible to users on the public side.
state: The contributor's state address of residency. Select from controlled list. Use only when provided by contributor. Not visible to users on the public side.
email: The contributor's email address. Free text. Use only when provided by contributor. Not visible to users on the public side.
postcode: The contributor's postcode of residency. Four digit numeral. Use only when provided by contributor. Not visible to users on the public side.
countryid: A unique number identifying the contributor's country of residence. Select from Country table. Use only when provided by contributor. Unique.

Organisation

organisation: A group or company involved in the conception, production or presentation of an event. Organisations are distinguished by their name and location. A new record is created when an organisation changes name.
organisationid: A unique number identifying an organisation. Organisations that share the same name are given different IDs. Unique.
name: The name of the organisation. Free text. Care must be taken to prevent unnecessary duplicates.
other_names1: Other names by which the organisation is known. Free text. This field may be used to record former or subsequent names. It can also be used for variant names to avoid duplicate records.
other_names2: Other names by which the organisation is known. Free text. This field may be used to record former or subsequent names. It can also be used for variant names to avoid duplicate records.
other_names3: Other names by which the organisation is known. Free text. This field may be used to record former or subsequent names. It can also be used for variant names to avoid duplicate records.
address: The number and street of the organisation's address. Free text.
suburb: The suburb, town or locality of the organisation's address. Free text.
state: The state of the organisation's address. Select from controlled list.
postcode: The postcode of the organisation's address. Free text.
contact: The name of a contact person for the organisation. Free text, with capitalised initials. Not visible on the public side.
phone1: A contact telephone number for the organisation. Free text, numerically, including area codes. Not visible on the public side. Format +xx x xxxx xxxx. Append name of telephone line if known, e.g. box office, administration.
phone2: A contact telephone number for the organisation. Free text, numerically, including area codes. Not visible on the public side. Format +xx x xxxx xxxx. Append name of telephone line if known, e.g. box office, administration.
phone3: A contact telephone number for the organisation. Free text, numerically, including area codes. Not visible on the public side. Format +xx x xxxx xxxx. Append name of telephone line if known, e.g. box office, administration.
fax: A contact fax number for the organisation. Free text, numerically, including area codes. Not visible on the public side. Format +xx x xxxx xxxx.
email: A contact email address for the organisation. Free text. Not visible on the public side.
web_links: A website address for the organisation. Free text. 'http://' is required.
notes: Any other relevant information about the organisation not covered by other fields. Free text.
countryid: A unique number identifying a country.. Select from controlled list. Unique.
ddfirst_date: A two-digit number denoting the first day of existence of the organisation using the title denoted in name. Free text. Use leading zeros for single digit days.
mmfirst_date: A two-digit number denoting the first month of existence of the organisation using the title denoted in name. Free text. Use leading zeros for single digit months.
yyyyfirst_date: A four-digit number denoting the first year of existence of the organisation using the title denoted in name. Free text.
ddlast_date: A two-digit number denoting the last day of existence of the organisation using the title denoted in name. Free text. Use leading zeros for single digit days.
mmlast_date: A two-digit number denoting the last month of existence of the organisation using the title denoted in name. Free text. Use leading zeros for single digit months.
yyyylast_date: A four-digit number denoting the last year of existence of the organisation using the title denoted in name. Free text.
place_of_origin: An organisation place of origin. Select from venue table.
place_of_demise: An organisations place of demise. Select from venue table.

Venue

venue: A place where an event happens. Venues are distinguished by their name and location. A new record is created when a venue changes name.
venueid: A unique number identifying a venue. Different venues with the same name are given different IDs. Unique.
venue_name: The name of a venue. To be typed as free text. Care must be taken to prevent unnecessary duplicates, especially as some duplicates are justified by venues with the same name in different locations. Where a venue is located within a larger 'parent' venue it is given its own venue record with the name of the venue it is located within in the Other Names field.
other_names1: An additional or alternative name by which the venue is known. Free text. Used for former or subsequent names of venue, or names of related venues either smaller 'child' venues within, or larger 'parent' venues.
other_names2: An additional or alternative name by which the venue is known. Free text. Used for former or subsequent names of venue, or names of related venues either smaller 'child' venues within, or larger 'parent' venues.
other_names3: An additional or alternative name by which the venue is known. Free text. Used for former or subsequent names of venue, or names of related venues either smaller 'child' venues within, or larger 'parent' venues.
street: The number and street of the venue's address. Free text.
suburb: The suburb of the venue's address. Free text.
state: The state of the venue's address. Select from controlled list.
postcode: The postcode of the venue's address. Free text.
capacity: The number of spectators to which the venue can present an event. Prefer the highest number of the most common configuration. To be typed as a number.
contact: The name of a contact person for the venue. Free text, with capitalised initials. Not visible on the public side.
phone: A contact telephone number for the venue. Free text, numerically, including area codes. Format +xx x xxxx xxxx. Not visible on the public side.
fax: A contact fax number for the venue. Free text, numerically, including area codes. Format +xx x xxxx xxxx. Not visible on the public side.
email: A contact email address for the venue. Free text. Not visible on the public side.
web_links: A website address or URL for the venue. Free text. 'http://' is required.
notes: Any other relevant information about the venue not covered by other fields. Free text.
country: The country in which the venue is located. Select from controlled list.
countryid: The identifier for the country in which the venue is located. .
longitude: The longitudinal geographic coordinate of the venue. Free text, numerically, in decimals to five decimal points.
latitude: The latitudinal geographic coordinates of the venue. Free text, numerically, in decimals to five decimal points.
regional_or_metro: Indicates whether the location of the venue is within a specified type of area. Select from controlled list, e.g. regional, suburban, metroplitan.
elevation: The geographic measurement of elevation.
radius: The measurement surrounding the longitude and latitude fields to which the venue is accurate.
ddfirst_date: A two-digit number denoting the first day of existence of the venue using the title denoted in name. Free text. Use leading zeros for single digit days.
mmfirst_date: A two-digit number denoting the first month of existence of the venue using the title denoted in name. Free text. Use leading zeros for single digit months.
yyyyfirst_date: A four-digit number denoting the first year of existence of the venue using the title denoted in name. Free text.
ddlast_date: A two-digit number denoting the last day of existence of the venue using the title denoted in name. Free text. Use leading zeros for single digit days.
mmlast_date: A two-digit number denoting the last month of existence of the venue using the title denoted in name. Free text. Use leading zeros for single digit months.
yyyylast_date: A four-digit number denoting the last year of existence of the venue using the title denoted in name. Free text.

Resource

item: A resource is a text, image, object, recording or the like which relates to an event, or to a contributor, organisation or venue, or to a work, genre, content indicator or other resource. Some resources exist as individual items stored in collections (like programs, posters, photographs and so on). Other resources exist as multiple copies in libraries (books, journals, articles and so on). The fields for the resource table augment the existing IbsenStage Item table with fields drawn from the Dublin Core Metadata Element set. Not all fields will be relevant to each type of resource.
resource type: The type of resource. Controlled list, based on the Dublic Core Metadata Initiative Type Vocabulary: Collection, Dataset, Event, Image, InteractiveResource, MovingImage, PhysicalObject, Service, Software, Sound, StillImage and Text.
resource sub type: A more specific designation of the type of resource. Chosen from a set of sub types associated with each main Resource Type. The set of sub types is expandable. Changes made on request; prefer existing terms.
title: A name given to a resource. For example, the title of a book, a chapter or an article; a caption for a photograph or illustration. To be entered as free text. Use leading capitals except for articles, prepositions and pronouns.
title alternative: An alternative name given to a resource. Multiple names separated by ; .
resource contributor: An agent responsible for contributing to the resource. To include a mandatory Resource Creator (ResourceCreator [ContributorID/s]). This is the agent primarily responsible for creating the resource. For example, the author of an article, chapter or book; the photographer of a photo; the designer for a set design. Each creator or contributor will be listed as either Individual or Organisation, with a list of numerically ordered functions to choose from.
contributor id: A contributor (or contributors) to which the resource refers. Contributor associations are created where a resource depicts or describes a contributor. Use ResourceCreator or ResourceContributor where a contributor creates or contributes to a resource.
abstract/description: A description or abstract of the content of the resource.
comments: Notes or comments on the content of the resource.
source: The resource from which the described resource is derived. Used for resources which are included within or part of other resources. For example, the newspaper is the source for a newspaper article; the journal is the source for a journal article; an anthology is the source for a chapter; a collection is the source for an item within that collection.
resource id: Another resource (or resources) related in some way to the current resource. The relation is qualified according to type using the Dublin Core relation qualifiers.
publisher: An agent or organisation responsible for making the resource available. For example, the publisher of a book.
publisher location: The location of the agent or organisation responsible for making the resource available.
volume: The volume number identifying the part of a Source in which a resource is located. For example, the volume number of the journal in which an article is published.
issue: The issue number identifying the part of a Source in which a resource is located. For example, the issue number of the journal in which an article is published.
page: The page number or page range indicating where a resource is located in a Source. For example, the page number of a newspaper article, or the page range of a journal article or chapter in a book.
citation: A text string unambiguously identifying the resource, for example a bibliographic citation for an article, chapter of book. This is automatically generated from information provided in other fields. It will include ResourceCreator, Title, Source, Date, Publisher and other identifying and finding information appropriate to the resource type.
date created - day: Date when the record is created. Automatically generated.
date of issue - day: Date of publication of the resource.
date of copyright - day: Date of a statement of copyright in the resource.
date accessioned - day: Date of the accessioning of the resource. Used for material items stored in collections.
date notes: Notes or comments on date information. For example, if dates are estimated.
catalogue id: A unique identifier given to a resource which is part of a collection. Used for material items stored in collections. Unique.
holding institution: The name of the organisation which holds the resource. Used for material items stored in collections.
storage: A description of how and where the resource is stored. Used for material items, stored in collections.
donated/purchased: Indicate whether resource is donated to or purchased. Used for material items stored in collections.
from: Person or organisation from whom the resource was obtained. Used for material items stored in collections.
provenance: Statement of the provenance of the resource. Used for material items stored in collections.
significance: Statement of the significance of the resource. Used for material items stored in collections.
resource condition: An indication of the physical condition of the resource. Used for material items, stored in collections.
detail comments: Comments on the physical condition of the resource. Used for material items, stored in collections.
rights: A statement of copyright in the resource.
rights holder: An agent (or agents) asserting copyright in the resource.
access rights: Conditions regarding rights or restrictions to access the resource.
resource language: The language/s of the resource is in, where the resource has language content.
medium: The physical medium of the resource. Used for material items, stored in collections.
extent: The physical dimensions of the resource. Used for material items, stored in collections.
mimetype: The file format of the resource designated by Multipurpose Internet Mail Extensions (MIME). Used for digital items.
format: Other information relating to the file format, physical medium or dimensions of the resource.
resource url: A unique Uniform Resource Locator for the resource. Used for digital resources which are publicly and persistently accessible. Unique.
international standard book number: Unique identifier assigned to a book. Unique.
international standard music number: Unique identifier assigned to a piece of music. Unique.
international standard serial number: Unique identifier assigned to a serial (journal, magazine, newspaper). Unique.
serial resource and contribution number: Unique identifier assigned to an article published as part of a serial. Unique.
event id: An event (or events) associated with or referred to by the resource. Event associations will be created where a resource is created in the process of making or responding to an event.
contributor id: A contributor (or contributors) to which the resource refers. Contributor associations are created where a resource depicts or describes a contributor. Use ResourceCreator or ResourceContributor where a contributor creates or contributes to a resource.
organisation id: An organisation (or organisations) to which the resource refers. Organisation associations are created where a resource depicts or describes an organisation. Not to be mistaken with the Resource Contributor of Creator.
venue id: A venue (or venues) to which the resource refers. Venue associations will be created where a resource depicts or describes a venue.
work id: A work (or works) to which the resource refers. Work associations will be created where a resource relates, for example, to a dramatic work, than to an actual production.
genre id: A genre (or genres) to which the resource refers or relates. Genre associations will be created where a resource relates, for example, to a performance genre, rather than particular productions.
content indicator id: A content indicator (or content indicators) to which the resource refers or relates. Content Indicator associations will be created where a resource relates to a particular subject, rather than actual productions.
resource id: Another resource (or resources) related in some way to the current resource. The relation is qualified according to type using the Dublin Core relation qualifiers.
created by user: User who created the record. Automatically generated.
date created - day: Date when the record is created. Automatically generated.
update by user: User who last updated the record. Automatically generated.
date updated - day: Date when the record is last updated. Automatically generated.

Data Models

Events

Contributor

Organisation

Venue

Resource

Work