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

Advertisements

0 Responses to “CAARP schema”



  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




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

%d bloggers like this: