create_table "programs" do |t|
    t.integer "id"
    t.integer "paradigm_id"
    t.integer "paradigm_title_id"
    t.string  "paradigm_series_name"
    t.string  "paradigm_episode_name"
    t.integer "paradigm_episode_number"
    t.text    "paradigm_abstract"
    t.text    "paradigm_body"
    t.string  "storer_id",               :limit => 24
  end

  create_table "date_spans", :force => true do |t|
    t.integer "id"
    t.integer  "date_spannable_id"
    t.string   "date_spannable_type"
    t.datetime "span_from"
    t.datetime "span_to"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  # date_spannable_id links back to the programs table. Date Spans are airings. For example, if you want to get everything that is showing from now forward, SELECT * FROM date_spans WHERE span_from > NOW(); Do a JOIN on programs to load the program with the timeslot.