Permalink
Switch branches/tags
Nothing to show
Find file
Fetching contributors…
Cannot retrieve contributors at this time
216 lines (194 sloc) 7.07 KB
# encoding: UTF-8
# This file is auto-generated from the current state of the database. Instead
# of editing this file, please use the migrations feature of Active Record to
# incrementally modify your database, and then regenerate this schema definition.
#
# Note that this schema.rb definition is the authoritative source for your
# database schema. If you need to create the application database on another
# system, you should be using db:schema:load, not running all the migrations
# from scratch. The latter is a flawed and unsustainable approach (the more migrations
# you'll amass, the slower it'll run and the greater likelihood for issues).
#
# It's strongly recommended to check this file into your version control system.
ActiveRecord::Schema.define(:version => 20110301010754) do
create_table "courses", :force => true do |t|
t.integer "institution_id"
t.string "subject"
t.string "number"
t.string "title"
t.text "description"
t.text "course_attributes"
t.integer "credits"
t.datetime "created_at", :null => false
t.datetime "updated_at", :null => false
end
create_table "delayed_jobs", :force => true do |t|
t.integer "priority", :default => 0
t.integer "attempts", :default => 0
t.text "handler"
t.text "last_error"
t.datetime "run_at"
t.datetime "locked_at"
t.datetime "failed_at"
t.string "locked_by"
t.string "queue"
t.datetime "created_at", :null => false
t.datetime "updated_at", :null => false
end
create_table "documents", :force => true do |t|
t.integer "section_id"
t.integer "resource_id"
t.string "resource_type"
t.boolean "visible", :default => false
t.string "title"
t.text "description"
t.string "upload_file_name"
t.string "upload_content_type"
t.integer "upload_file_size"
t.datetime "upload_updated_at"
t.integer "position"
t.string "google_drive_file_id"
t.datetime "created_at", :null => false
t.datetime "updated_at", :null => false
end
create_table "events", :force => true do |t|
t.integer "section_id"
t.boolean "visible", :default => true
t.boolean "assignment"
t.string "title"
t.text "description"
t.datetime "starts_at"
t.datetime "ends_at"
t.integer "points_possible"
t.integer "weight"
t.datetime "created_at", :null => false
t.datetime "updated_at", :null => false
end
create_table "grades", :force => true do |t|
t.integer "event_id"
t.integer "student_id"
t.integer "score"
t.datetime "created_at", :null => false
t.datetime "updated_at", :null => false
end
create_table "institutions", :force => true do |t|
t.string "name"
t.string "subdomain"
t.string "email_domain"
t.string "upload_file_name"
t.string "upload_content_type"
t.integer "upload_file_size"
t.datetime "upload_updated_at"
t.datetime "created_at", :null => false
t.datetime "updated_at", :null => false
end
create_table "notices", :force => true do |t|
t.integer "section_id"
t.string "title"
t.text "text"
t.datetime "created_at", :null => false
t.datetime "updated_at", :null => false
end
create_table "notifications", :force => true do |t|
t.integer "user_id"
t.string "user_type"
t.integer "resource_id"
t.string "resource_type"
t.boolean "read", :default => false
t.text "text"
t.string "url"
t.string "css_class"
t.string "icon"
t.boolean "modal", :default => false
t.datetime "created_at", :null => false
t.datetime "updated_at", :null => false
end
add_index "notifications", ["user_type", "user_id"], :name => "index_notifications_on_user_type_and_user_id"
create_table "pages", :force => true do |t|
t.integer "section_id"
t.boolean "visible", :default => true
t.string "title"
t.string "link"
t.text "text"
t.integer "position"
t.datetime "created_at", :null => false
t.datetime "updated_at", :null => false
end
create_table "professors", :force => true do |t|
t.integer "institution_id"
t.string "email_address"
t.string "first_name"
t.string "last_name"
t.string "cookie"
t.string "google_calendar_id"
t.string "oauth_refresh_token"
t.string "oauth_access_token"
t.datetime "oauth_access_token_expires_at"
t.datetime "created_at", :null => false
t.datetime "updated_at", :null => false
end
create_table "sections", :force => true do |t|
t.integer "course_id"
t.integer "semester_id"
t.integer "professor_id"
t.string "name"
t.string "identifier"
t.integer "total_seats"
t.string "location"
t.string "days"
t.time "starts_at"
t.time "ends_at"
t.string "google_drive_folder_id"
t.integer "students_count", :default => 0
t.datetime "created_at", :null => false
t.datetime "updated_at", :null => false
end
create_table "sectionships", :force => true do |t|
t.integer "section_id"
t.integer "student_id"
t.datetime "created_at", :null => false
t.datetime "updated_at", :null => false
end
create_table "semesters", :force => true do |t|
t.integer "institution_id"
t.string "season"
t.integer "year"
t.boolean "current"
t.date "starts_on"
t.date "ends_on"
t.datetime "created_at", :null => false
t.datetime "updated_at", :null => false
end
create_table "settings", :force => true do |t|
t.integer "resource_id"
t.string "resource_type"
t.string "key"
t.text "value"
t.datetime "created_at", :null => false
t.datetime "updated_at", :null => false
end
add_index "settings", ["resource_type", "resource_id", "key"], :name => "index_settings_on_resource_type_and_resource_id_and_key"
create_table "students", :force => true do |t|
t.integer "institution_id"
t.string "email_address"
t.string "first_name"
t.string "last_name"
t.string "cookie"
t.string "google_calendar_id"
t.string "oauth_refresh_token"
t.string "oauth_access_token"
t.datetime "oauth_access_token_expires_at"
t.datetime "created_at", :null => false
t.datetime "updated_at", :null => false
end
create_table "versions", :force => true do |t|
t.integer "item_id"
t.string "item_type"
t.string "event", :null => false
t.string "whodunnit"
t.text "object"
t.datetime "created_at", :null => false
t.datetime "updated_at", :null => false
end
add_index "versions", ["item_type", "item_id"], :name => "index_versions_on_item_type_and_item_id"
end