snippet.rb

# 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 => 0) do

  create_table "belegt", :id => false, :force => true do |t|
    t.date    "VON"
    t.date    "BIS"
    t.string  "CODE",       :limit => 8
    t.integer "NR",                       :null => false
    t.integer "ANZAHL"
    t.string  "LTRAEGER",   :limit => 20
    t.integer "AUSVORGANG"
    t.string  "ART",        :limit => 12
    t.string  "BEMERKUNG",  :limit => 60
    t.string  "AUFOPTION",  :limit => 4
  end

  create_table "bildtext", :id => false, :force => true do |t|
    t.integer "NR",                                 :null => false
    t.binary  "BILD",         :limit => 2147483647
    t.binary  "TEXT",         :limit => 2147483647
    t.string  "ART",          :limit => 8
    t.integer "CODE"
    t.string  "IMGTYPE",      :limit => 4
    t.string  "UEBERSCHRIFT", :limit => 60
    t.integer "BILDINDEX"
  end

  create_table "bookings", :force => true do |t|
    t.integer "travel_id"
    t.string  "salutation",                :limit => 50,                  :null => false
    t.string  "firstname",                 :limit => 50,                  :null => false
    t.string  "lastname",                  :limit => 50,                  :null => false
    t.string  "street",                    :limit => 50,                  :null => false
    t.string  "postcode",                  :limit => 50,                  :null => false
    t.string  "city",                      :limit => 50,                  :null => false
    t.string  "phone",                     :limit => 50,                  :null => false
    t.string  "email",                     :limit => 50,                  :null => false
    t.string  "stop",                      :limit => 50
    t.string  "insurance_code",            :limit => 50
    t.float   "insurance_total_amount",                  :default => 0.0
    t.string  "transaction_nr",            :limit => 50
    t.string  "state",                     :limit => 50
    t.text    "result_of_option_booking"
    t.string  "ratio_booking_id",          :limit => 50
    t.text    "result_of_confirm_booking"
    t.string  "site_host",                 :limit => 50
  end

  create_table "categories", :force => true do |t|
    t.string  "code",     :limit => 50, :null => false
    t.string  "title_de", :limit => 50, :null => false
    t.string  "title_fr", :limit => 50, :null => false
    t.integer "site_id",                :null => false
  end

  create_table "frei", :id => false, :force => true do |t|
    t.integer  "ANZAHL"
    t.date     "VON"
    t.date     "BIS"
    t.string   "CODE",       :limit => 8
    t.integer  "NR",                       :null => false
    t.string   "LTRAEGER",   :limit => 20
    t.datetime "VERFALL"
    t.string   "BEMERKUNG",  :limit => 40
    t.text     "BEMERKUNG2"
  end

  create_table "haltestellen", :id => false, :force => true do |t|
    t.string  "CODE",      :limit => 8,  :null => false
    t.string  "PLZ",       :limit => 10
    t.string  "ORT",       :limit => 60
    t.string  "REISENR",   :limit => 20
    t.integer "STATIONID"
  end

  create_table "hotels", :id => false, :force => true do |t|
    t.string  "HOTELCODE",       :limit => 8,  :null => false
    t.string  "NAME",            :limit => 40
    t.string  "LAND",            :limit => 3
    t.string  "PLZ",             :limit => 10
    t.string  "ORT",             :limit => 40
    t.string  "STRASSE",         :limit => 40
    t.string  "TELEFON",         :limit => 20
    t.string  "FAX",             :limit => 20
    t.string  "ANSPRECHPARTNER", :limit => 40
    t.float   "ERM1",                          :null => false
    t.float   "ERM2",                          :null => false
    t.float   "ERM3",                          :null => false
    t.string  "ERMTEXT1",        :limit => 30
    t.string  "ERMTEXT2",        :limit => 30
    t.string  "ERMTEXT3",        :limit => 30
    t.integer "OPTIONSTAGE"
    t.integer "STATIONID"
    t.integer "TOURNR"
    t.integer "KENNZIFFER"
    t.string  "GESPERRT",        :limit => 4
  end

  create_table "insurances", :force => true do |t|
    t.string  "code",              :limit => 50
    t.string  "title",             :limit => 50
    t.integer "duration"
    t.float   "max_travel_amount"
    t.float   "price"
    t.integer "flat",              :limit => 1,  :default => 0
  end

  create_table "kontingente", :id => false, :force => true do |t|
    t.integer  "NR",                               :null => false
    t.string   "REISENR",            :limit => 20, :null => false
    t.string   "LCODE",              :limit => 4,  :null => false
    t.string   "HOTELCODE",          :limit => 8
    t.string   "BEZEICHNUNG",        :limit => 40
    t.float    "PREIS",                            :null => false
    t.string   "SACHKONTO",          :limit => 12
    t.string   "KOSTELLE1",          :limit => 12
    t.string   "KOSTELLE2",          :limit => 12
    t.integer  "MAXIMUM",                          :null => false
    t.integer  "VERFUEGBAR",                       :null => false
    t.integer  "GEBUCHT",                          :null => false
    t.string   "USTPFLICHTIG",       :limit => 4
    t.integer  "PROVKLASSE"
    t.integer  "STATIONID"
    t.string   "LTYP",               :limit => 4
    t.float    "EKPREIS"
    t.integer  "TERMINNR"
    t.float    "VWPREIS"
    t.datetime "TERMIN"
    t.string   "BEMERKUNG",          :limit => 40
    t.integer  "TERMINNR2"
    t.string   "AGENTURSPERRUNG",    :limit => 4
    t.integer  "KONTINGENTDETAILNR"
  end

  create_table "line_items", :force => true do |t|
    t.integer "booking_id"
    t.integer "product_id"
    t.string  "product_title", :limit => 50
    t.float   "product_price"
    t.integer "quantity"
  end

  create_table "payments", :force => true do |t|
    t.integer "booking_id"
    t.float   "amount"
    t.string  "transaction_nr",     :limit => 50
    t.string  "response_code",      :limit => 50
    t.string  "confirm_email",      :limit => 50
    t.text    "confirm_email_body"
  end

  create_table "regions", :force => true do |t|
    t.string  "code",     :limit => 50
    t.string  "title_de", :limit => 50
    t.string  "title_fr", :limit => 50
    t.integer "site_id",                :null => false
  end

  create_table "reisen", :id => false, :force => true do |t|
    t.integer  "NR",                                    :default => 0,   :null => false
    t.string   "REISENR",         :limit => 20,                          :null => false
    t.datetime "REISEVON",                                               :null => false
    t.datetime "REISEBIS",                                               :null => false
    t.datetime "RESVON"
    t.datetime "RESBIS"
    t.string   "ZIEL",            :limit => 60
    t.string   "AKBUS",           :limit => 15
    t.text     "BESCHREIBUNG"
    t.integer  "MAXIMUM",                                                :null => false
    t.integer  "MINIMUM",                                                :null => false
    t.integer  "IST",                                                    :null => false
    t.string   "KATEGORIE",       :limit => 15
    t.string   "GESPERRT",        :limit => 4
    t.string   "HINWEIS",         :limit => 60
    t.string   "SACHKONTO",       :limit => 12
    t.string   "KOSTELLE1",       :limit => 12
    t.string   "KOSTELLE2",       :limit => 12
    t.string   "PROVKONTO",       :limit => 12
    t.text     "TEXTINTERN"
    t.integer  "STATIONID"
    t.binary   "KALKULATION",     :limit => 2147483647
    t.string   "STORNOKONTO",     :limit => 12
    t.integer  "DISPONR"
    t.datetime "VORBEREITET"
    t.integer  "BASISREISE"
    t.integer  "VERSION"
    t.integer  "BILDREF"
    t.string   "INET",            :limit => 4
    t.string   "STAT1",           :limit => 4
    t.string   "STAT2",           :limit => 4
    t.string   "STAT3",           :limit => 4
    t.string   "STAT4",           :limit => 4
    t.string   "GEBIETSCODE",     :limit => 20
    t.float    "PAUSCHFAKTOR",                          :default => 1.0
    t.string   "REGION",          :limit => 20
    t.string   "BEFART",          :limit => 20
    t.float    "ANZAHLUNG"
    t.integer  "STORNOSTAFFEL"
    t.string   "ANZAHLUNGART",    :limit => 4
    t.string   "AGENTURSPERRUNG", :limit => 4
    t.string   "ABRECHNUNGSART",  :limit => 1
  end

  create_table "rooms", :force => true do |t|
    t.string  "code",        :limit => 50, :null => false
    t.integer "num_persons"
  end

  create_table "rundreisehotel", :id => false, :force => true do |t|
    t.integer  "NR",                       :null => false
    t.string   "HOTELCODE", :limit => 8
    t.string   "REISENR",   :limit => 20
    t.datetime "RESVON"
    t.datetime "RESBIS"
    t.string   "BEMERKUNG", :limit => 120
  end

  create_table "sites", :force => true do |t|
    t.string  "host",         :limit => 50,                :null => false
    t.string  "layout",       :limit => 50,                :null => false
    t.string  "cetrel_appid", :limit => 50,                :null => false
    t.integer "show_all",     :limit => 1,  :default => 1
    t.string  "redirect_to",  :limit => 50
  end

  create_table "stops", :force => true do |t|
    t.string "code",  :limit => 50
    t.string "title", :limit => 50
    t.float  "price"
  end

  create_table "transport_types", :force => true do |t|
    t.string  "code",     :limit => 50
    t.string  "title_de", :limit => 50
    t.string  "title_fr", :limit => 50
    t.integer "site_id",                :null => false
  end

  create_table "travelers", :force => true do |t|
    t.integer "booking_id"
    t.string  "salutation", :limit => 50, :null => false
    t.string  "firstname",  :limit => 50, :null => false
    t.string  "lastname",   :limit => 50, :null => false
    t.date    "birthday",                 :null => false
    t.integer "product_id"
  end

  create_table "zustiege", :id => false, :force => true do |t|
    t.integer  "NR",                                                          :null => false
    t.string   "CODE",           :limit => 8,                                 :null => false
    t.string   "REISENR",        :limit => 20,                                :null => false
    t.datetime "ABFAHRT",                                                     :null => false
    t.string   "HAUPTHALT",      :limit => 8,                                 :null => false
    t.string   "ZUBRINGER",      :limit => 8
    t.integer  "STATIONID"
    t.decimal  "ZUSCHLAG",                     :precision => 18, :scale => 2
    t.datetime "RUECKKEHR"
    t.string   "HAUPTHALTRUECK", :limit => 8
    t.string   "ZUBRINGERRUECK", :limit => 8
  end

end