Archive for December, 2007

CAARP schema

The basic tables in CAARP are:

* film
* film_title
* film_production_company
* collections
* comment_search
* entity_role_links
* entity_roles
* program_extra_activities
* record_type
* user_role
* url
* user_roles
* company
* film_genre
* genre
* film_country_origin
* country
* state
* language
* film_distributor_company
* comments
* film_release
* sub_dub_sil_sound
* screenings
* screening_type
* billing
* venue
* venue_details
* cit_sub_country
* primary_purpose
* advanced_search
* sound_silent

A full breakdown of the tables is contained in this pdf document:

CAARPDatabaseSchema

Bonza – tables

Main tables for Bonza (further details below)
• PERSON
• COMPANY
• VENUE
• PRODUCTION TITLE
• REFERENCES

Other tables around these describe:
Notes, Roletypes, Images, Country.

There are also tables to do with those who add to the database and tracking their actions.

Database Summary of Purpose
The database was originally created to list references to different people, films and TV productions. The database has since been refurbished to list companies, and venues as well as references, people, and productions.

Bonza was set up by academics in the Media Studies department of RMIT University as a teaching and learning resource with a view to providing students an opportunity to record their research and make it publicly accessible. It had the added effect of allowing detailed referencing in the production of their online essays (and thereby, hopefully, reducing descriptiveness). The database allowed students to link their bibliographic and production references to entries already recorded in the database.

The main tables all include comments fields that allow the user, and subsequent users, to make comments on the particular person, reference, venue, company, or production.

Full list of Tables

Roletype
The roletype table is used to link with the person and company tables to provide lists for the different kinds of roles people/companies undertake in relation to a production reference.

For example the roletype table enables you to list John Smith as a ‘Gaffer’ within a production title.

If John Smith ran his own production design company, the roletype field allows you to list him as the ‘Owner’ of the company.

John Smith’s production company can be listed as a ‘production company’ within a production title.

Continue reading ‘Bonza – tables’


December 2007
M T W T F S S
« Nov    
 12
3456789
10111213141516
17181920212223
24252627282930
31