Data Models

Events | Contributor | Organisation | Venue | Resource | Work

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 Ausstage. 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 (if Australia) or country (if overseas). 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 (Australian Dictionary of Biography, Parson's Companion to Theatre in Australia, and so on) or invite contributor to provide information. Note source at end of field. Free text.

nla
The contributor's Persistent Identifier at the National Library of Australia. Source from the National Library of Australia.

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 AusStage 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 created - month
.

date created - year
.

date of issue - day
Date of publication of the resource.

date of issue - month
.

date of issue - year
.

date of copyright - day
Date of a statement of copyright in the resource.

date of copyright - month
.

date of copyright - year
.

date accessioned - day
Date of the accessioning of the resource. Used for material items stored in collections.

date accessioned - month
.

date accessioned - year
.

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.

date created - month
.

date created - year
.

update by user
User who last updated the record. Automatically generated.

date updated - day
Date when the record is last updated. Automatically generated.

date updated - month
.

date updated - year
.

Work

work
A work is the abstract conception of an event, typically (though not always) expressed as a material resource, such as a script or score.

workid
A unique number identifying a work. Unique.

work_title
A name identifying a work. Prefer the original name, as conceived by creator.

alternative_work_title
Alternative names for a work. Use for alternative names, translations of name and variant spellings.

Controlled vocabularies

Genres

Functions

Subjects

Resource Types